APPS.POS_TOTALS_PO_SV dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 884: AP_INVOICE_DISTRIBUTIONS_ALL AID,

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

Line 894: AP_INVOICE_DISTRIBUTIONS_ALL AID,

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

Line 979: AP_INVOICE_DISTRIBUTIONS_ALL AID,

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