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.RCV_ACCEVENTS_PVT dependencies on PO_LINE_LOCATIONS

Line 72: l_po_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;

68: l_grparent_trx_type RCV_TRANSACTIONS.transaction_type%TYPE;
69: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
70:
71: -- 12i Complex Work Procurement -------------------------------------------
72: l_po_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
73: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
74: ---------------------------------------------------------------------------
75:
76: l_opm_flag NUMBER;

Line 73: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;

69: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
70:
71: -- 12i Complex Work Procurement -------------------------------------------
72: l_po_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
73: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
74: ---------------------------------------------------------------------------
75:
76: l_opm_flag NUMBER;
77: l_cr_flag BOOLEAN;

Line 199: FROM po_line_locations

195: -- R12: Complex Work Procurement
196: -- Exclude any transactions whose POLL.shipment_type = 'PREPAYMENT'.
197: SELECT shipment_type
198: INTO l_shipment_type
199: FROM po_line_locations
200: WHERE line_location_id = l_po_line_location_id;
201:
202: IF (l_shipment_type = 'PREPAYMENT') THEN
203: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 404: l_matching_basis PO_LINE_LOCATIONS.matching_basis%TYPE;

400: l_rcv_events_tbl RCV_SeedEvents_PVT.rcv_event_tbl_type;
401: l_rae_count NUMBER;
402:
403: -- 12i Complex Work Procurement------------------------------------
404: l_matching_basis PO_LINE_LOCATIONS.matching_basis%TYPE;
405: l_shipment_type PO_LINE_LOCATIONS.shipment_type%TYPE;
406: -------------------------------------------------------------------
407: l_proc_operating_unit NUMBER;
408: l_po_distribution_id NUMBER;

Line 405: l_shipment_type PO_LINE_LOCATIONS.shipment_type%TYPE;

401: l_rae_count NUMBER;
402:
403: -- 12i Complex Work Procurement------------------------------------
404: l_matching_basis PO_LINE_LOCATIONS.matching_basis%TYPE;
405: l_shipment_type PO_LINE_LOCATIONS.shipment_type%TYPE;
406: -------------------------------------------------------------------
407: l_proc_operating_unit NUMBER;
408: l_po_distribution_id NUMBER;
409: l_organization_id NUMBER;

Line 451: po_line_locations POLL,

447:
448: CURSOR c_po_dists_csr (l_rcv_txn IN NUMBER) IS
449: SELECT POD.po_distribution_id
450: FROM po_distributions POD,
451: po_line_locations POLL,
452: rcv_transactions RT
453: WHERE POD.line_location_id = POLL.line_location_id
454: AND POLL.line_location_id = RT.po_line_location_id
455: AND RT.transaction_id = l_rcv_txn;

Line 513: FROM po_line_locations POLL

509:
510: -- Get Matching Basis and Shipment Type
511: SELECT POLL.matching_basis, POLL.shipment_type
512: INTO l_matching_basis, l_shipment_type
513: FROM po_line_locations POLL
514: WHERE POLL.line_location_id = p_po_line_location_id;
515:
516: l_stmt_num := 30;
517:

Line 1148: po_line_locations POLL,

1144: l_po_document_type_code,
1145: /* Support for Landed Cost Management */
1146: l_lcm_flag
1147: FROM po_headers POH,
1148: po_line_locations POLL,
1149: po_lines POL,
1150: rcv_transactions RT
1151: WHERE RT.transaction_id = p_rcv_transaction_id
1152: AND POH.po_header_id = RT.po_header_id

Line 1838: po_line_locations POLL,

1834: l_po_document_type_code,
1835: /* Support for Landed Cost Management */
1836: l_lcm_flag
1837: FROM po_headers POH,
1838: po_line_locations POLL,
1839: po_lines POL,
1840: po_distributions POD,
1841: rcv_transactions RT
1842: WHERE RT.transaction_id = p_rcv_transaction_id

Line 2384: po_line_locations POLL,

2380: l_po_document_type_code,
2381: /* Support for Landed Cost Management */
2382: l_lcm_flag
2383: FROM po_headers POH,
2384: po_line_locations POLL,
2385: po_lines POL,
2386: po_distributions POD,
2387: rcv_transactions RT
2388: WHERE RT.transaction_id = p_rcv_transaction_id

Line 2939: po_line_locations POLL,

2935: l_po_document_type_code,
2936: /* Support for Landed Cost Management */
2937: l_lcm_flag
2938: FROM po_headers POH,
2939: po_line_locations POLL,
2940: po_lines POL,
2941: rcv_transactions RT
2942: WHERE RT.transaction_id = p_rcv_transaction_id
2943: AND POH.po_header_id = RT.po_header_id

Line 3620: po_line_locations POLL,

3616: l_accrual_flag,
3617: /* Support for Landed Cost Management */
3618: l_lcm_flag
3619: FROM po_headers POH,
3620: po_line_locations POLL,
3621: po_lines POL,
3622: po_distributions POD,
3623: rcv_transactions RT
3624: WHERE RT.transaction_id = p_rcv_transaction_id