APPS.AP_APPROVAL_MATCHED_PKG dependencies on PO_HEADERS

Line 2149: po_headers PH,

2145: rcv_shipment_lines RSL,
2146: ap_invoice_lines L,
2147: ap_invoices I,
2148: po_line_locations PLL,
2149: po_headers PH,
2150: po_releases PR
2151: WHERE I.invoice_id = L.invoice_id
2152: AND L.po_line_location_id = PLL.line_location_id
2153: AND L.match_type in ( 'PRICE_CORRECTION', 'QTY_CORRECTION',

Line 4143: po_headers PH,

4139: MAX(aid.accounting_date) Accounting_date
4140: FROM po_distributions_ap_v PD,
4141: ap_invoice_distributions AID,
4142: po_line_locations PLL,
4143: po_headers PH,
4144: po_releases PR
4145: WHERE AID.invoice_id = p_invoice_id
4146: AND AID.final_match_flag = 'Y'
4147: AND AID.po_distribution_id = PD.po_distribution_id

Line 5572: po_headers PH

5568: * FC.minimum_accountable_unit)
5569: INTO l_po_total
5570: FROM fnd_currencies FC,
5571: po_line_locations PLL,
5572: po_headers PH
5573: WHERE PLL.line_location_id = p_line_location_id
5574: AND PH.po_header_id = PLL.po_header_id
5575: AND FC.currency_code = PH.currency_code;
5576:

Line 5589: FROM fnd_currencies FC, po_line_locations PLL, po_headers PH

5585: NVL(PLL.amount_cancelled, 0))
5586: / FC.minimum_accountable_unit)
5587: * FC.minimum_accountable_unit)
5588: INTO l_po_total
5589: FROM fnd_currencies FC, po_line_locations PLL, po_headers PH
5590: WHERE PLL.line_location_id = p_line_location_id
5591: AND PH.po_header_id = PLL.po_header_id
5592: AND FC.currency_code = PH.currency_code;
5593: