DBA Data[Home] [Help]

APPS.GMF_RCV_ACCOUNTING_PKG dependencies on PO_LINES

Line 3366: po_lines pol,

3362: l_inv_trx.distribution_account_id, l_inv_trx.costed_flag,
3363: l_inv_trx.subinventory_code, l_inv_trx.locator_id,
3364: l_inv_trx.parent_transaction_flag, l_inv_trx.trx_source_line_id
3365: FROM rcv_transactions rt,
3366: po_lines pol,
3367: po_line_locations poll,
3368: po_distributions pod,
3369: fnd_currencies fc
3370: WHERE rt.transaction_id = p_rcv_accttxn.rcv_transaction_id

Line 4398: po_lines pol,

4394: l_rcv_accttxn.source_doc_uom, l_rcv_accttxn.currency_code
4395: FROM ap_invoice_distributions apid,
4396: po_distributions pod,
4397: po_line_locations poll,
4398: po_lines pol,
4399: po_headers poh
4400: WHERE apid.invoice_distribution_id = p_inv_distribution_id
4401: AND pod.po_distribution_id = apid.po_distribution_id
4402: AND pod.line_location_id = poll.line_location_id

Line 4436: po_lines pol,

4432: l_dest_org_id, l_rcv_accttxn.transaction_uom,
4433: l_rcv_accttxn.source_doc_uom, l_rcv_accttxn.currency_code,
4434: l_rcv_accttxn.destination_type_code
4435: FROM rcv_transactions rt,
4436: po_lines pol,
4437: po_line_locations poll,
4438: po_headers poh,
4439: po_distributions pod
4440: WHERE rt.transaction_id = p_rcv_transaction_id

Line 5491: po_lines pol,

5487: l_rcv_organization_id, l_item_id, l_category_id,
5488: l_project_id, l_accrual_flag
5489: FROM po_headers poh,
5490: po_line_locations poll,
5491: po_lines pol,
5492: rcv_transactions rt
5493: WHERE rt.transaction_id = p_rcv_transaction_id
5494: AND poh.po_header_id = rt.po_header_id
5495: AND poll.line_location_id = rt.po_line_location_id

Line 6290: po_lines pol,

6286: l_rcv_organization_id, l_category_id, l_project_id,
6287: l_accrual_flag
6288: FROM po_headers poh,
6289: po_line_locations poll,
6290: po_lines pol,
6291: po_distributions pod,
6292: rcv_transactions rt
6293: WHERE rt.transaction_id = p_rcv_transaction_id
6294: AND poh.po_header_id = rt.po_header_id

Line 6827: po_lines pol,

6823: l_rcv_organization_id, l_category_id, l_project_id,
6824: l_accrual_flag
6825: FROM po_headers poh,
6826: po_line_locations poll,
6827: po_lines pol,
6828: po_distributions pod,
6829: rcv_transactions rt
6830: WHERE rt.transaction_id = p_rcv_transaction_id
6831: AND poh.po_header_id = rt.po_header_id

Line 7455: po_lines pol,

7451: l_rcv_organization_id, l_item_id, l_category_id,
7452: l_project_id, l_accrual_flag
7453: FROM po_headers poh,
7454: po_line_locations poll,
7455: po_lines pol,
7456: rcv_transactions rt
7457: WHERE rt.transaction_id = p_rcv_transaction_id
7458: AND poh.po_header_id = rt.po_header_id
7459: AND poll.line_location_id = rt.po_line_location_id