DBA Data[Home] [Help]

APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 3364: from po_distributions_all pod

3360: is
3361: select pod.po_header_id
3362: ,pod.po_line_id
3363: ,apd.rcv_transaction_id /*Added by vkantamn for Bug#6083978*/
3364: from po_distributions_all pod
3365: ,ap_invoice_distributions_all apd
3366: where pod.po_distribution_id = apd.po_distribution_id
3367: and apd.invoice_id = cp_invoice_id
3368: and apd.invoice_distribution_id = cp_distribution_id;

Line 3639: ,po_distributions_all pod

3635: is
3636: select recs.service_type_code
3637: from jai_rgm_trx_records recs
3638: ,jai_rgm_trx_refs refs
3639: ,po_distributions_all pod
3640: ,ap_invoice_distributions_all apd
3641: where pod.po_line_id = p_document_line_id
3642: and pod.po_distribution_id = apd.po_distribution_id
3643: and apd.invoice_distribution_id = refs.item_line_id