APPS.POS_TOTALS_PO_SV dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 921: AP_INVOICE_DISTRIBUTIONS_ALL AID,

917:
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

Line 933: AP_INVOICE_DISTRIBUTIONS_ALL AID,

929:
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

Line 1020: AP_INVOICE_DISTRIBUTIONS_ALL AID,

1016: /*
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;