DBA Data[Home] [Help]

APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 1947: from po_distributions_all pod

1943: is
1944: select pod.po_header_id
1945: ,pod.po_line_id
1946: ,apd.rcv_transaction_id /*Added by vkantamn for Bug#6083978*/
1947: from po_distributions_all pod
1948: ,ap_invoice_distributions_all apd
1949: where pod.po_distribution_id = apd.po_distribution_id
1950: and apd.invoice_id = cp_invoice_id
1951: and apd.invoice_distribution_id = cp_distribution_id;

Line 2233: ,po_distributions_all pod

2229: is
2230: select recs.service_type_code
2231: from jai_rgm_trx_records recs
2232: ,jai_rgm_trx_refs refs
2233: ,po_distributions_all pod
2234: ,ap_invoice_distributions_all apd
2235: where pod.po_line_id = p_document_line_id
2236: and pod.po_distribution_id = apd.po_distribution_id
2237: and apd.invoice_distribution_id = refs.item_line_id