DBA Data[Home] [Help]

APPS.POS_TOTALS_PO_SV dependencies on PO_DISTRIBUTIONS_ALL

Line 885: PO_DISTRIBUTIONS_ALL POD

881: CURSOR l_po_inv_paid_csr IS
882: select NVL(AI.payment_status_flag, 'N')
883: from AP_INVOICES_ALL AI,
884: AP_INVOICE_DISTRIBUTIONS_ALL AID,
885: PO_DISTRIBUTIONS_ALL POD
886: where AI.invoice_id = AID.invoice_id
887: and AID.po_distribution_id = POD.po_distribution_id
888: and POD.po_header_id = p_po_header_id
889: and POD.po_release_id is null;

Line 895: PO_DISTRIBUTIONS_ALL POD

891: CURSOR l_rel_inv_paid_csr IS
892: select NVL(AI.payment_status_flag, 'N')
893: from AP_INVOICES_ALL AI,
894: AP_INVOICE_DISTRIBUTIONS_ALL AID,
895: PO_DISTRIBUTIONS_ALL POD
896: where AI.invoice_id = AID.invoice_id
897: and AID.po_distribution_id = POD.po_distribution_id
898: and POD.po_header_id = p_po_header_id
899: and POD.po_release_id = p_po_release_id;

Line 980: PO_DISTRIBUTIONS_ALL POD

976: CURSOR l_inv_paid_csr IS
977: select NVL(AI.payment_status_flag, 'N')
978: from AP_INVOICES_ALL AI,
979: AP_INVOICE_DISTRIBUTIONS_ALL AID,
980: PO_DISTRIBUTIONS_ALL POD
981: where AI.invoice_id = AID.invoice_id
982: and AID.po_distribution_id = POD.po_distribution_id
983: and POD.line_location_id = p_line_location_id;
984: */