APPS.AP_APPROVAL_MATCHED_PKG dependencies on PO_HEADERS

Line 1921: po_headers PH,

1917: rcv_shipment_lines RSL,
1918: ap_invoice_lines L,
1919: ap_invoices I,
1920: po_line_locations PLL,
1921: po_headers PH,
1922: po_releases PR
1923: WHERE I.invoice_id = L.invoice_id
1924: AND L.po_line_location_id = PLL.line_location_id
1925: AND L.match_type in ( 'PRICE_CORRECTION', 'QTY_CORRECTION',

Line 3700: po_headers PH,

3696: MAX(aid.accounting_date) Accounting_date
3697: FROM po_distributions_ap_v PD,
3698: ap_invoice_distributions AID,
3699: po_line_locations PLL,
3700: po_headers PH,
3701: po_releases PR
3702: WHERE AID.invoice_id = p_invoice_id
3703: AND AID.final_match_flag = 'Y'
3704: AND AID.po_distribution_id = PD.po_distribution_id

Line 5150: po_headers PH

5146: * FC.minimum_accountable_unit)
5147: INTO l_po_total
5148: FROM fnd_currencies FC,
5149: po_line_locations PLL,
5150: po_headers PH
5151: WHERE PLL.line_location_id = p_line_location_id
5152: AND PH.po_header_id = PLL.po_header_id
5153: AND FC.currency_code = PH.currency_code;
5154:

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

5163: NVL(PLL.amount_cancelled, 0))
5164: / FC.minimum_accountable_unit)
5165: * FC.minimum_accountable_unit)
5166: INTO l_po_total
5167: FROM fnd_currencies FC, po_line_locations PLL, po_headers PH
5168: WHERE PLL.line_location_id = p_line_location_id
5169: AND PH.po_header_id = PLL.po_header_id
5170: AND FC.currency_code = PH.currency_code;
5171: