APPS.GMF_RCV_ACCOUNTING_PKG dependencies on PO_HEADERS

Line 1899: FROM po_distributions pod, po_headers poh

1895: SELECT NVL (pod.rate, 1), poh.rate_type,
1896: pod.rate_date
1897: INTO l_currency_conversion_rate, l_currency_conversion_type,
1898: l_currency_conversion_date
1899: FROM po_distributions pod, po_headers poh
1900: WHERE pod.po_distribution_id = p_rcv_accttxn.po_distribution_id
1901: AND poh.po_header_id = pod.po_header_id;
1902: ELSE
1903: -- This is also correct for ADJUST transactions where we only create one event

Line 4405: po_headers poh

4401: FROM ap_invoice_distributions apid,
4402: po_distributions pod,
4403: po_line_locations poll,
4404: po_lines pol,
4405: po_headers poh
4406: WHERE apid.invoice_distribution_id = p_inv_distribution_id
4407: AND pod.po_distribution_id = apid.po_distribution_id
4408: AND pod.line_location_id = poll.line_location_id
4409: AND pol.po_line_id = poll.po_line_id

Line 4450: po_headers poh,

4446: /* end LCM-OPM Integration */
4447: FROM rcv_transactions rt,
4448: po_lines pol,
4449: po_line_locations poll,
4450: po_headers poh,
4451: po_distributions pod
4452: WHERE rt.transaction_id = p_rcv_transaction_id
4453: AND poh.po_header_id = rt.po_header_id
4454: AND pol.po_line_id = rt.po_line_id

Line 5507: FROM po_headers poh,

5503: l_po_distribution_id, l_rcv_trx_date,
5504: l_drop_ship_flag, l_po_org_id,
5505: l_rcv_organization_id, l_item_id, l_category_id,
5506: l_project_id, l_accrual_flag
5507: FROM po_headers poh,
5508: po_line_locations poll,
5509: po_lines pol,
5510: rcv_transactions rt
5511: WHERE rt.transaction_id = p_rcv_transaction_id

Line 6309: FROM po_headers poh,

6305: l_destination_type, l_rcv_trx_date,
6306: l_drop_ship_flag, l_po_org_id,
6307: l_rcv_organization_id, l_category_id, l_project_id,
6308: l_accrual_flag
6309: FROM po_headers poh,
6310: po_line_locations poll,
6311: po_lines pol,
6312: po_distributions pod,
6313: rcv_transactions rt

Line 6880: FROM po_headers poh,

6876: l_destination_type, l_rcv_trx_date,
6877: l_drop_ship_flag, l_po_org_id,
6878: l_rcv_organization_id, l_category_id, l_project_id,
6879: l_accrual_flag
6880: FROM po_headers poh,
6881: po_line_locations poll,
6882: po_lines pol,
6883: po_distributions pod,
6884: rcv_transactions rt

Line 7508: FROM po_headers poh,

7504: l_po_distribution_id, l_rcv_trx_date,
7505: l_drop_ship_flag, l_po_org_id,
7506: l_rcv_organization_id, l_item_id, l_category_id,
7507: l_project_id, l_accrual_flag
7508: FROM po_headers poh,
7509: po_line_locations poll,
7510: po_lines pol,
7511: rcv_transactions rt
7512: WHERE rt.transaction_id = p_rcv_transaction_id

Line 8162: l_po_header_id po_headers_all.po_header_id%TYPE;

8158: l_parent_trx_id rcv_transactions.transaction_id%TYPE;
8159: l_parent_trx_type rcv_transactions.transaction_type%TYPE;
8160: l_grparent_trx_id rcv_transactions.transaction_id%TYPE;
8161: l_grparent_trx_type rcv_transactions.transaction_type%TYPE;
8162: l_po_header_id po_headers_all.po_header_id%TYPE;
8163: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;
8164: l_shipment_type po_line_locations_all.shipment_type%TYPE;
8165: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
8166: l_api_version NUMBER := 1.0;

Line 8711: FROM po_headers

8707:
8708: -- Get Procuring operating unit
8709: SELECT org_id
8710: INTO l_proc_operating_unit
8711: FROM po_headers
8712: WHERE po_header_id = p_po_header_id;
8713:
8714: -- Loop Through all Parent Transactions
8715: FOR c_par_txn IN c_parent_receive_txns_csr