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 […]

Personalization a niye ihtiyac duyarız? Customization dan farki nedir? Hangisini ne zaman kullanmak gerekir?Şimdi bir örnek üzerinden bunlari açıklamaya çalışalım.Diyelim ki standard PO ekraninda satin alma yapiyorsunuz ancak  PO’nun header kısmındaki DFF in bir alaninda bu satinalma icin ödemenin pesin mi taksitle mi alindigi bilgisi tutuluyor ve eğer satın alma taksitle yapıldıysa PO nun her […]

/*##################### # BASİT FATURA DETAY BİLGİLERİ /*#####################*/ SELECT aia.invoice_id , aia.invoice_num , aia.doc_sequence_value voucher_num , aia.invoice_date inv_date , 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 paid , aia.vat_code , pv.vendor_name […]