Aktif olan müşterilerin müşteri ve adres tanımlamalarının görüntülendiği rapor örneği   SELECT hp.party_name , hca.account_number act_no , hca.cust_account_id , hca.party_id , DECODE(hca.status, ‘I’, ‘Inactive’, ‘A’, ‘Active’, ‘Other’) hdr , ‘##’ , hca.creation_date hdr_creation_date , fu_header.description hdr_created_by , hca.last_update_date hdr_updated , fu_hdr_upd.description hdr_updated_by , ‘###’ , hcsua.org_id , hps.party_site_number site_num , hcsua.cust_acct_site_id , hcsua.location , hcsua.site_use_code […]

Alacaklar faturasının detaylarının görüntülenebildiği (satırlar ve dağıtımlarının, dağıtım hesaplarının, hangi tip ve kaynak ile oluşturulduğu bilgileri dahil ) bir rapor örneği.   SELECT rcta.trx_number , rcta.customer_trx_id , rba.name batch , rcta.creation_date , rctta.name tx_type , hp.party_number party , hca.account_number act_no , hp.party_name , hps.party_site_number site_num , rcta.request_id — Autoinvoice Import Program , rbsa.name source , […]

      SELECT aia.invoice_id , aia.invoice_num , aida.creation_date , aida.last_updated_by , aida.distribution_line_number dist_line , aida.line_type_lookup_code dist_line_type , aida.period_name dist_line_period , aida.match_status_flag , aida.posted_flag , aida.quantity_invoiced , aida.amount dist_amt , pha.segment1 po , pv.vendor_name supplier , rt.transaction_id rx_id FROM ap.ap_invoices_all aia , ap.ap_invoice_distributions_all aida , ap.ap_terms_tl att , applsys.fnd_user fu , po.po_vendors pv , po.po_vendor_sites_all […]

Kullanıcı adıyla kullanıcının sistemde sahip olduğu sorumlulukları görebiliriz. SELECT fu.user_name, fr.responsibility_name, furg.START_DATE, furg.END_DATE FROM fnd_user_resp_groups_direct furg, fnd_user fu, fnd_responsibility_tl fr WHERE fu.user_name = UPPER (‘MYILMAZ’) AND furg.user_id = fu.user_id AND furg.responsibility_id = fr.responsibility_id AND fr.language = USERENV (‘LANG’);

/*###################################*/ # Basit Fatura Dağıtım Bilgisi /*##################################*/ SELECT aia.invoice_id , aia.invoice_num , aia.doc_sequence_value voucher_num , aida.* FROM ap.ap_invoices_all aia , ap.ap_invoice_distributions_all aida , ap.ap_terms_tl att , applsys.fnd_user fu , po.po_vendors pv , po.po_vendor_sites_all pvsa WHERE aia.invoice_id = aida.invoice_id AND aia.terms_id = att.term_id AND aia.created_by = fu.user_id AND aia.vendor_id = pv.vendor_id AND aia.vendor_site_id = pvsa.vendor_site_id AND pv.vendor_id […]

/*############################ #Temel Fatura Bilgileri ve Hesaplaması yapılanlar /*###########################*/ SELECT aia.invoice_id , aia.invoice_num , aia.doc_sequence_value voucher_num , aia.invoice_date inv_date , aia.doc_sequence_value , aaea.event_type_code , aia.source , aia.invoice_type_lookup_code inv_type , att.name pay_terms , aia.invoice_currency_code inv_curr , aia.payment_currency_code pay_curr , aia.creation_date inv_cr_date , fu.description cr_by , aia.invoice_amount total_inv_amt , aia.approved_amount basic_amt , aia.validated_tax_amount tax_amt , aia.description , aia.payment_status_flag […]

/*############################ # Fatura Satın Alma Durum Bilgileri /*##########################*/ SELECT aia.invoice_id , aia.invoice_num , aia.invoice_amount , aia.invoice_date , ‘———-‘ , pha.segment1 , ‘———-‘ , aha.hold_date , aha.release_reason , aha.last_update_date , aha.hold_lookup_code , aha.hold_reason , ‘———-‘ , pda.quantity_billed FROM ap.ap_invoices_all aia , ap.ap_invoice_distributions_all aida , po.po_headers_all pha , po.po_distributions_all pda , ap.ap_holds_all aha , po.po_vendors pv — use […]