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_AVAILABILITY dependencies on RCV_TRANSACTIONS

Line 34: FROM rcv_transactions_interface

30: WHERE processing_status_code = 'PENDING';
31:
32: CURSOR get_rti_rows IS
33: SELECT *
34: FROM rcv_transactions_interface
35: WHERE processing_status_code = 'PENDING';
36: BEGIN
37: IF (g_rti_normalized IS NOT NULL) THEN --because this is expensive, we only want to run it once per session
38: RETURN;

Line 191: to receipts/shipments in RCV_TRANSACTIONS_INTERFACE that apply

187: get_rcv_ship_row, get_rcv_po_row are all the same query, but
188: with different driving where clauses. The cursor used is
189: determined by p_supply_demand_type_id. The cursors return all
190: the rows in RCV_SHIPMENT_LINES and all the receipts/+correction
191: to receipts/shipments in RCV_TRANSACTIONS_INTERFACE that apply
192: to the backing doc
193:
194: The parameters p_organization_id, p_item_id, p_revision,
195: p_lot_number, p_subinventory_code, p_locator_id, p_project_id,

Line 228: FROM rcv_transactions_interface rti,

224: rti.item_id,
225: rti.unit_of_measure,
226: rti.primary_unit_of_measure,
227: rti.to_organization_id
228: FROM rcv_transactions_interface rti,
229: rcv_transactions rt
230: WHERE rti.parent_transaction_id = rt.transaction_id(+)
231: AND rti.quantity > 0
232: AND ( rti.transaction_type IN('RECEIVE', 'SHIP', 'DELIVER')

Line 229: rcv_transactions rt

225: rti.unit_of_measure,
226: rti.primary_unit_of_measure,
227: rti.to_organization_id
228: FROM rcv_transactions_interface rti,
229: rcv_transactions rt
230: WHERE rti.parent_transaction_id = rt.transaction_id(+)
231: AND rti.quantity > 0
232: AND ( rti.transaction_type IN('RECEIVE', 'SHIP', 'DELIVER')
233: OR ( rti.transaction_type = 'CORRECT'

Line 277: FROM rcv_transactions rt

273: AND ( p_locator_id IS NULL
274: OR p_locator_id = rsl.locator_id)
275: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
276: OR NVL(l_lpn_id, fnd_api.g_miss_num) IN(SELECT NVL(rt.lpn_id, fnd_api.g_miss_num) --Bug 5329067
277: FROM rcv_transactions rt
278: WHERE rt.shipment_line_id = rsl.shipment_line_id))
279: AND ( p_project_id IS NULL
280: OR p_project_id IN(SELECT rt.project_id
281: FROM rcv_transactions rt

Line 281: FROM rcv_transactions rt

277: FROM rcv_transactions rt
278: WHERE rt.shipment_line_id = rsl.shipment_line_id))
279: AND ( p_project_id IS NULL
280: OR p_project_id IN(SELECT rt.project_id
281: FROM rcv_transactions rt
282: WHERE rt.shipment_line_id = rsl.shipment_line_id))
283: AND ( p_task_id IS NULL
284: OR p_task_id IN(SELECT rt.task_id
285: FROM rcv_transactions rt

Line 285: FROM rcv_transactions rt

281: FROM rcv_transactions rt
282: WHERE rt.shipment_line_id = rsl.shipment_line_id))
283: AND ( p_task_id IS NULL
284: OR p_task_id IN(SELECT rt.task_id
285: FROM rcv_transactions rt
286: WHERE rt.shipment_line_id = rsl.shipment_line_id))
287: AND rsl.requisition_line_id = p_supply_demand_line_id;
288:
289: CURSOR get_rcv_oe_row IS

Line 315: FROM rcv_transactions_interface rti,

311: rti.item_id,
312: rti.unit_of_measure,
313: rti.primary_unit_of_measure,
314: rti.to_organization_id
315: FROM rcv_transactions_interface rti,
316: rcv_transactions rt
317: WHERE rti.parent_transaction_id = rt.transaction_id(+)
318: AND rti.quantity > 0
319: AND ( rti.transaction_type IN('RECEIVE', 'SHIP', 'DELIVER')

Line 316: rcv_transactions rt

312: rti.unit_of_measure,
313: rti.primary_unit_of_measure,
314: rti.to_organization_id
315: FROM rcv_transactions_interface rti,
316: rcv_transactions rt
317: WHERE rti.parent_transaction_id = rt.transaction_id(+)
318: AND rti.quantity > 0
319: AND ( rti.transaction_type IN('RECEIVE', 'SHIP', 'DELIVER')
320: OR ( rti.transaction_type = 'CORRECT'

Line 364: FROM rcv_transactions rt

360: AND ( p_locator_id IS NULL
361: OR p_locator_id = rsl.locator_id)
362: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
363: OR NVL(l_lpn_id, fnd_api.g_miss_num) IN(SELECT NVL(rt.lpn_id, fnd_api.g_miss_num)--Bug 5329067
364: FROM rcv_transactions rt
365: WHERE rt.shipment_line_id = rsl.shipment_line_id))
366: AND ( p_project_id IS NULL
367: OR p_project_id IN(SELECT rt.project_id
368: FROM rcv_transactions rt

Line 368: FROM rcv_transactions rt

364: FROM rcv_transactions rt
365: WHERE rt.shipment_line_id = rsl.shipment_line_id))
366: AND ( p_project_id IS NULL
367: OR p_project_id IN(SELECT rt.project_id
368: FROM rcv_transactions rt
369: WHERE rt.shipment_line_id = rsl.shipment_line_id))
370: AND ( p_task_id IS NULL
371: OR p_task_id IN(SELECT rt.task_id
372: FROM rcv_transactions rt

Line 372: FROM rcv_transactions rt

368: FROM rcv_transactions rt
369: WHERE rt.shipment_line_id = rsl.shipment_line_id))
370: AND ( p_task_id IS NULL
371: OR p_task_id IN(SELECT rt.task_id
372: FROM rcv_transactions rt
373: WHERE rt.shipment_line_id = rsl.shipment_line_id))
374: AND rsl.oe_order_line_id = p_supply_demand_line_id;
375:
376: /*

Line 413: FROM rcv_transactions_interface rti,

409: rti.item_id,
410: rti.unit_of_measure,
411: rti.primary_unit_of_measure,
412: rti.to_organization_id
413: FROM rcv_transactions_interface rti,
414: rcv_transactions rt
415: WHERE rti.parent_transaction_id = rt.transaction_id(+)
416: AND rti.quantity > 0
417: AND ( rti.transaction_type IN('RECEIVE', 'SHIP', 'DELIVER')

Line 414: rcv_transactions rt

410: rti.unit_of_measure,
411: rti.primary_unit_of_measure,
412: rti.to_organization_id
413: FROM rcv_transactions_interface rti,
414: rcv_transactions rt
415: WHERE rti.parent_transaction_id = rt.transaction_id(+)
416: AND rti.quantity > 0
417: AND ( rti.transaction_type IN('RECEIVE', 'SHIP', 'DELIVER')
418: OR ( rti.transaction_type = 'CORRECT'

Line 462: FROM rcv_transactions rt

458: AND ( p_locator_id IS NULL
459: OR p_locator_id = rsl.locator_id)
460: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
461: OR NVL(l_lpn_id, fnd_api.g_miss_num) IN(SELECT NVL(rt.lpn_id, fnd_api.g_miss_num) --Bug 5329067
462: FROM rcv_transactions rt
463: WHERE rt.shipment_line_id = rsl.shipment_line_id))
464: AND ( p_project_id IS NULL
465: OR p_project_id IN(SELECT rt.project_id
466: FROM rcv_transactions rt

Line 466: FROM rcv_transactions rt

462: FROM rcv_transactions rt
463: WHERE rt.shipment_line_id = rsl.shipment_line_id))
464: AND ( p_project_id IS NULL
465: OR p_project_id IN(SELECT rt.project_id
466: FROM rcv_transactions rt
467: WHERE rt.shipment_line_id = rsl.shipment_line_id))
468: AND ( p_task_id IS NULL
469: OR p_task_id IN(SELECT rt.task_id
470: FROM rcv_transactions rt

Line 470: FROM rcv_transactions rt

466: FROM rcv_transactions rt
467: WHERE rt.shipment_line_id = rsl.shipment_line_id))
468: AND ( p_task_id IS NULL
469: OR p_task_id IN(SELECT rt.task_id
470: FROM rcv_transactions rt
471: WHERE rt.shipment_line_id = rsl.shipment_line_id))
472: AND rsl.shipment_line_id = p_shipment_line_id;
473:
474: CURSOR get_rcv_po_row IS

Line 523: FROM rcv_transactions_interface rti,

519: rti.item_id,
520: rti.unit_of_measure,
521: rti.primary_unit_of_measure,
522: rti.to_organization_id
523: FROM rcv_transactions_interface rti,
524: rcv_transactions rt
525: WHERE rti.parent_transaction_id = rt.transaction_id(+)
526: AND ( rti.quantity > 0
527: OR (rti.quantity < 0 AND rti.transaction_type = 'CORRECT')

Line 524: rcv_transactions rt

520: rti.unit_of_measure,
521: rti.primary_unit_of_measure,
522: rti.to_organization_id
523: FROM rcv_transactions_interface rti,
524: rcv_transactions rt
525: WHERE rti.parent_transaction_id = rt.transaction_id(+)
526: AND ( rti.quantity > 0
527: OR (rti.quantity < 0 AND rti.transaction_type = 'CORRECT')
528: )--Bug 5329067

Line 579: FROM rcv_transactions rt

575: AND ( p_locator_id IS NULL
576: OR p_locator_id = rsl.locator_id)
577: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
578: OR NVL(l_lpn_id, fnd_api.g_miss_num) IN(SELECT NVL(rt.lpn_id, fnd_api.g_miss_num) --Bug 5329067
579: FROM rcv_transactions rt
580: WHERE rt.shipment_line_id = rsl.shipment_line_id))
581: AND ( p_project_id IS NULL
582: OR p_project_id IN(SELECT rt.project_id
583: FROM rcv_transactions rt

Line 583: FROM rcv_transactions rt

579: FROM rcv_transactions rt
580: WHERE rt.shipment_line_id = rsl.shipment_line_id))
581: AND ( p_project_id IS NULL
582: OR p_project_id IN(SELECT rt.project_id
583: FROM rcv_transactions rt
584: WHERE rt.shipment_line_id = rsl.shipment_line_id))
585: AND ( p_task_id IS NULL
586: OR p_task_id IN(SELECT rt.task_id
587: FROM rcv_transactions rt

Line 587: FROM rcv_transactions rt

583: FROM rcv_transactions rt
584: WHERE rt.shipment_line_id = rsl.shipment_line_id))
585: AND ( p_task_id IS NULL
586: OR p_task_id IN(SELECT rt.task_id
587: FROM rcv_transactions rt
588: WHERE rt.shipment_line_id = rsl.shipment_line_id))
589: AND rsl.po_line_location_id = p_supply_demand_line_id;
590:
591: x_order_row get_po_order%ROWTYPE;

Line 704: rcv_transactions_interface (RTI) and rcv_shipment_lines (RSL).

700:
701: /*
702: The logic below first defaults x_rcv_order_quantity from the
703: backing docs. It then loops through all the rows in
704: rcv_transactions_interface (RTI) and rcv_shipment_lines (RSL).
705: If the row is in RSL then it increases the running value of
706: x_rcv_quantity by shipped_quantity for non-wms orgs and increases the value
707: of x_rcv_quantity by received_quantity for wms orgs. We know that RSL's
708: shipped_quantity and receipt_quantity are an accurate summation of all rcv_transaction