DBA Data[Home] [Help]

APPS.GMF_RCV_ACCOUNTING_PKG dependencies on PO_LINES

Line 3372: po_lines pol,

3368: l_inv_trx.distribution_account_id, l_inv_trx.costed_flag,
3369: l_inv_trx.subinventory_code, l_inv_trx.locator_id,
3370: l_inv_trx.parent_transaction_flag, l_inv_trx.trx_source_line_id
3371: FROM rcv_transactions rt,
3372: po_lines pol,
3373: po_line_locations poll,
3374: po_distributions pod,
3375: fnd_currencies fc
3376: WHERE rt.transaction_id = p_rcv_accttxn.rcv_transaction_id

Line 4404: po_lines pol,

4400: l_rcv_accttxn.source_doc_uom, l_rcv_accttxn.currency_code
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

Line 4448: po_lines pol,

4444: /* start LCM-OPM Integration */
4445: l_rcv_accttxn.unit_landed_cost
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

Line 5509: po_lines pol,

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
5512: AND poh.po_header_id = rt.po_header_id
5513: AND poll.line_location_id = rt.po_line_location_id

Line 6311: po_lines pol,

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
6314: WHERE rt.transaction_id = p_rcv_transaction_id
6315: AND poh.po_header_id = rt.po_header_id

Line 6882: po_lines pol,

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
6885: WHERE rt.transaction_id = p_rcv_transaction_id
6886: AND poh.po_header_id = rt.po_header_id

Line 7510: po_lines pol,

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
7513: AND poh.po_header_id = rt.po_header_id
7514: AND poll.line_location_id = rt.po_line_location_id