eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMF_RCV_ACCOUNTING_PKG dependencies on PO_LINE_LOCATIONS

Line 112: po_line_locations POLL

108: SELECT decode(RT.po_distribution_id, NULL, RT.amount * (POD.amount_ordered/POLL.amount),RT.amount)
109: INTO l_transaction_amount
110: FROM rcv_transactions RT,
111: po_distributions POD,
112: po_line_locations POLL
113: WHERE RT.transaction_id = p_rcv_accttxn.rcv_transaction_id
114: AND POD.po_distribution_id = p_rcv_accttxn.po_distribution_id
115: AND POLL.line_location_id = p_rcv_accttxn.po_line_location_id;
116: ELSIF(p_rcv_accttxn.event_source = 'INVOICEMATCH') THEN

Line 506: po_line_locations poll,

502: rt.source_doc_quantity
503: )
504: INTO l_source_doc_quantity
505: FROM rcv_transactions rt,
506: po_line_locations poll,
507: po_distributions pod
508: WHERE rt.transaction_id = p_rcv_accttxn.rcv_transaction_id
509: AND poll.line_location_id = p_rcv_accttxn.po_line_location_id
510: AND pod.po_distribution_id = p_rcv_accttxn.po_distribution_id;

Line 540: po_line_locations poll,

536: l_source_doc_quantity
537: )
538: INTO l_source_doc_quantity
539: FROM rcv_transactions rt,
540: po_line_locations poll,
541: po_distributions pod
542: WHERE rt.transaction_id = p_rcv_accttxn.rcv_transaction_id
543: AND poll.line_location_id = p_rcv_accttxn.po_line_location_id
544: AND pod.po_distribution_id = p_rcv_accttxn.po_distribution_id;

Line 898: FROM mtl_system_items msi, po_line_locations poll

894: l_stmt_num := 40;
895:
896: SELECT msi.inventory_asset_flag
897: INTO l_asset_flag
898: FROM mtl_system_items msi, po_line_locations poll
899: WHERE msi.inventory_item_id = p_rcv_accttxn.item_id
900: AND msi.organization_id = poll.ship_to_organization_id
901: AND poll.line_location_id = p_rcv_accttxn.po_line_location_id;
902: EXCEPTION

Line 1068: FROM po_line_locations poll

1064: l_stmt_num := 70;
1065:
1066: SELECT poll.price_override
1067: INTO l_unit_price
1068: FROM po_line_locations poll
1069: WHERE poll.line_location_id = p_rcv_accttxn.po_line_location_id;
1070: ELSIF (p_rcv_accttxn.event_source = 'INVOICEMATCH')
1071: THEN
1072: l_stmt_num := 80;

Line 1879: FROM po_line_locations

1875: l_stmt_num := 30;
1876:
1877: SELECT match_option
1878: INTO l_match_option
1879: FROM po_line_locations
1880: WHERE line_location_id = l_po_line_location_id;
1881:
1882: -- Always use rate on the PO distribution for encumbrance reversals.
1883: IF ( l_match_option = 'P'

Line 3367: po_line_locations poll,

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
3371: AND pol.po_line_id = p_rcv_accttxn.po_line_id

Line 4397: po_line_locations poll,

4393: l_rcv_accttxn.source_doc_quantity,
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

Line 4437: po_line_locations poll,

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
4441: AND poh.po_header_id = rt.po_header_id

Line 4557: FROM po_line_locations poll

4553:
4554: -- Check if event is for a service line type
4555: SELECT DECODE (poll.matching_basis, 'AMOUNT', 'Y', 'N')
4556: INTO l_rcv_accttxn.service_flag
4557: FROM po_line_locations poll
4558: WHERE poll.line_location_id = l_rcv_accttxn.po_line_location_id;
4559:
4560: l_stmt_num := 90;
4561:

Line 5124: FROM po_line_locations poll

5120: l_stmt_num := 20;
5121:
5122: SELECT NVL (poll.accrue_on_receipt_flag, 'N')
5123: INTO l_accrue_on_receipt_flag
5124: FROM po_line_locations poll
5125: WHERE poll.line_location_id =
5126: p_rcv_accttxn_tbl (l_ctr_first).po_line_location_id;
5127:
5128: <>

Line 5490: po_line_locations poll,

5486: l_drop_ship_flag, l_po_org_id,
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

Line 6289: po_line_locations poll,

6285: l_drop_ship_flag, l_po_org_id,
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

Line 6826: po_line_locations poll,

6822: l_drop_ship_flag, l_po_org_id,
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

Line 7454: po_line_locations poll,

7450: l_drop_ship_flag, l_po_org_id,
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

Line 8108: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;

8104: l_parent_trx_type rcv_transactions.transaction_type%TYPE;
8105: l_grparent_trx_id rcv_transactions.transaction_id%TYPE;
8106: l_grparent_trx_type rcv_transactions.transaction_type%TYPE;
8107: l_po_header_id po_headers_all.po_header_id%TYPE;
8108: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;
8109: l_shipment_type po_line_locations_all.shipment_type%TYPE;
8110: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
8111: l_api_version NUMBER := 1.0;
8112: l_return_status VARCHAR2 (100);

Line 8109: l_shipment_type po_line_locations_all.shipment_type%TYPE;

8105: l_grparent_trx_id rcv_transactions.transaction_id%TYPE;
8106: l_grparent_trx_type rcv_transactions.transaction_type%TYPE;
8107: l_po_header_id po_headers_all.po_header_id%TYPE;
8108: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;
8109: l_shipment_type po_line_locations_all.shipment_type%TYPE;
8110: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
8111: l_api_version NUMBER := 1.0;
8112: l_return_status VARCHAR2 (100);
8113: l_msg_count NUMBER (38);

Line 8173: FROM po_line_locations

8169: -- r12: complex work procurement
8170: -- Exclude any transactions whose POLL.shipment_type = 'PREPAYMENT'
8171: SELECT shipment_type
8172: INTO l_shipment_type
8173: FROM po_line_locations
8174: WHERE line_location_id = l_po_line_location_id;
8175:
8176: IF (l_shipment_type = 'PREPAYMENT')
8177: THEN

Line 8467: l_matching_basis po_line_locations.matching_basis%TYPE;

8463: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;
8464: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
8465: l_rae_count NUMBER;
8466: -- 12i Complex Work Procurement------------------------------------
8467: l_matching_basis po_line_locations.matching_basis%TYPE;
8468: l_shipment_type po_line_locations.shipment_type%TYPE;
8469: -------------------------------------------------------------------
8470: l_proc_operating_unit NUMBER;
8471: l_po_distribution_id NUMBER;

Line 8468: l_shipment_type po_line_locations.shipment_type%TYPE;

8464: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
8465: l_rae_count NUMBER;
8466: -- 12i Complex Work Procurement------------------------------------
8467: l_matching_basis po_line_locations.matching_basis%TYPE;
8468: l_shipment_type po_line_locations.shipment_type%TYPE;
8469: -------------------------------------------------------------------
8470: l_proc_operating_unit NUMBER;
8471: l_po_distribution_id NUMBER;
8472: l_organization_id NUMBER;

Line 8517: po_line_locations poll,

8513: CURSOR c_po_dists_csr (l_rcv_txn IN NUMBER)
8514: IS
8515: SELECT pod.po_distribution_id
8516: FROM po_distributions pod,
8517: po_line_locations poll,
8518: rcv_transactions rt
8519: WHERE pod.line_location_id = poll.line_location_id
8520: AND poll.line_location_id = rt.po_line_location_id
8521: AND rt.transaction_id = l_rcv_txn;

Line 8528: FROM po_line_locations_all a,

8524: /* INVCONV ANTHIYAG Bug#5529309 18-Sep-2006 Start */
8525: BEGIN
8526: SELECT nvl(b.process_enabled_flag, 'N')
8527: INTO l_process_enabled_flag
8528: FROM po_line_locations_all a,
8529: mtl_parameters b
8530: WHERE a.line_location_id = p_po_line_location_id
8531: AND b.organization_id = a.ship_to_organization_id;
8532: EXCEPTION

Line 8609: FROM po_line_locations poll

8605:
8606: -- Get Matching Basis and Shipment Type
8607: SELECT poll.matching_basis, poll.shipment_type
8608: INTO l_matching_basis, l_shipment_type
8609: FROM po_line_locations poll
8610: WHERE poll.line_location_id = p_po_line_location_id;
8611:
8612: l_stmt_num := 30;
8613: