APPS.POS_TOTALS_PO_SV dependencies on PO_DISTRIBUTIONS_ALL

Line 922: PO_DISTRIBUTIONS_ALL POD

918: CURSOR l_po_inv_paid_csr IS
919: select NVL(AI.payment_status_flag, 'N')
920: from AP_INVOICES_ALL AI,
921: AP_INVOICE_DISTRIBUTIONS_ALL AID,
922: PO_DISTRIBUTIONS_ALL POD
923: where AI.invoice_id = AID.invoice_id
924: and AID.po_distribution_id = POD.po_distribution_id
925: and POD.po_header_id = p_po_header_id
926: and POD.po_release_id is null

Line 934: PO_DISTRIBUTIONS_ALL POD

930: CURSOR l_rel_inv_paid_csr IS
931: select NVL(AI.payment_status_flag, 'N')
932: from AP_INVOICES_ALL AI,
933: AP_INVOICE_DISTRIBUTIONS_ALL AID,
934: PO_DISTRIBUTIONS_ALL POD
935: where AI.invoice_id = AID.invoice_id
936: and AID.po_distribution_id = POD.po_distribution_id
937: and POD.po_header_id = p_po_header_id
938: and POD.po_release_id = p_po_release_id

Line 1021: PO_DISTRIBUTIONS_ALL POD

1017: CURSOR l_inv_paid_csr IS
1018: select NVL(AI.payment_status_flag, 'N')
1019: from AP_INVOICES_ALL AI,
1020: AP_INVOICE_DISTRIBUTIONS_ALL AID,
1021: PO_DISTRIBUTIONS_ALL POD
1022: where AI.invoice_id = AID.invoice_id
1023: and AID.po_distribution_id = POD.po_distribution_id
1024: and POD.line_location_id = p_line_location_id;
1025: */