DBA Data[Home] [Help]

APPS.AP_INVOICES_UTILITY_PKG dependencies on PO_HEADERS

Line 932: po_headers PH

928: CURSOR po_number_cursor IS
929: SELECT DISTINCT ph.segment1, ph.po_header_id,
930: NVL(SUM(L.amount),0)
931: FROM ap_invoice_lines_all L,
932: po_headers PH
933: WHERE L.invoice_id = l_invoice_id
934: AND L.po_header_id = PH.po_header_id
935: AND L.match_type IN ( 'PRICE_CORRECTION', 'QTY_CORRECTION',
936: 'ITEM_TO_PO', 'ITEM_TO_RECEIPT', 'AMOUNT_CORRECTION',

Line 1172: po_headers PH

1168:
1169: CURSOR po_number_cursor IS
1170: SELECT DISTINCT(ph.segment1)
1171: FROM ap_invoice_lines L,
1172: po_headers PH
1173: WHERE L.invoice_id = l_invoice_id
1174: AND NOT EXISTS (SELECT AIL.corrected_inv_id
1175: FROM ap_invoice_lines AIL
1176: WHERE NVL( AIL.discarded_flag, 'N' ) <> 'Y'