Oracle Apps Questions

select pha.segment1 ,pha.vendor_id ,ap.org_id ,pha.creation_date ,pha.po_header_id ,pha.type_lookup_code ,ap.invoice_date ,ap.invoice_num ,ap.invoice_amount ,pda.po_line_id ,pda.code_combination_id ,ap.accts_pay_code_combination_id from po_headers_all pha ,ap_invoices_all ap ,po_distributions_all pda where pha.po_header_id=ap.po_header_id and pha.vendor_id=ap.vendor_id and pha.po_header_id=pda.po_header_id and ap.po_header_id=pda.po_header_id and ap.accts_pay_code_combination_id=pda.code_combination_id and pha.type_lookup_code='BLANKET' and ap.invoice_date between :p_fromdate and :p_todate and ap.org_id=:p_orgid
OPEN
0 answer