Browsing articles in "Modüller"
Mar
7
2014

Satır ve Dağıtım bazında Alacaklar Muhasebesi Faturası Rapor Örneği

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

Mar
7
2014

Teslim Alma Satırı ile Eşlemesi Yapılan Borçlar Muhasebesi Faturası Detaylarını Gösteren Bir Rapor Örneği

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

Mar
7
2014

Fatura ve Dağıtımlarının Bilgisini Gösteren Rapor Örneği

/*###################################*/ # 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 […]

Mar
7
2014

Fatura ve Muhasebeleşme Bilgisini Gösteren Rapor Örneği

/*############################ #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 […]

Mar
7
2014

Fatura Satın Alma Durum Bilgilerini Gösteren Rapor Örneği

/*############################ # 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 […]

Mar
7
2014

Fatura Detay Bilgilerini Gösteren Rapor Örneği

/*##################### # 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 […]

Mar
7
2014

Telefon İletişim Bilgisi Oluşturma Örnek Scipti

Merhaba, Öncelikle aktarım yapacağımız listeyi bir tabloya gireriz.(xxtt.xxtt_is_cep_telefon) DECLARE ln_phone_id per_phones.phone_id%TYPE; ln_object_version_number per_phones.object_version_number%TYPE; CURSOR crs IS SELECT xx.person_id, xx.tel_number, xx.tip, xx.party_id FROM xxtt.xxtt_is_cep_telefon xx WHERE xx.person_id IS NOT NULL AND xx.employee_number = ‘1291’; BEGIN fnd_global.apps_initialize (2708, 50297, 800); FOR c1 IN crs LOOP hr_phone_api.create_phone (p_date_from => TO_DATE (’01-01-2000′), p_phone_type => c1.tip, p_phone_number => c1.tel_number, p_parent_id […]

Sayfalar:«1...141516171819202122»