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 236: to receipts/shipments in RCV_TRANSACTIONS_INTERFACE that apply

232: get_rcv_ship_row, get_rcv_po_row are all the same query, but
233: with different driving where clauses. The cursor used is
234: determined by p_supply_demand_type_id. The cursors return all
235: the rows in RCV_SHIPMENT_LINES and all the receipts/+correction
236: to receipts/shipments in RCV_TRANSACTIONS_INTERFACE that apply
237: to the backing doc
238:
239: The parameters p_organization_id, p_item_id, p_revision,
240: p_lot_number, p_subinventory_code, p_locator_id, p_project_id,

Line 273: FROM rcv_transactions_interface rti,

269: rti.item_id,
270: rti.unit_of_measure,
271: rti.primary_unit_of_measure,
272: rti.to_organization_id
273: FROM rcv_transactions_interface rti,
274: rcv_transactions rt
275: WHERE rti.parent_transaction_id = rt.transaction_id(+)
276: AND rti.quantity > 0
277: AND ( rti.transaction_type IN('RECEIVE', 'SHIP', 'DELIVER')

Line 274: rcv_transactions rt

270: rti.unit_of_measure,
271: rti.primary_unit_of_measure,
272: rti.to_organization_id
273: FROM rcv_transactions_interface rti,
274: rcv_transactions rt
275: WHERE rti.parent_transaction_id = rt.transaction_id(+)
276: AND rti.quantity > 0
277: AND ( rti.transaction_type IN('RECEIVE', 'SHIP', 'DELIVER')
278: OR ( rti.transaction_type = 'CORRECT'

Line 322: FROM rcv_transactions rt

318: AND ( p_locator_id IS NULL
319: OR p_locator_id = rsl.locator_id)
320: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
321: OR NVL(l_lpn_id, fnd_api.g_miss_num) IN(SELECT NVL(rt.lpn_id, fnd_api.g_miss_num) --Bug 5329067
322: FROM rcv_transactions rt
323: WHERE rt.shipment_line_id = rsl.shipment_line_id))
324: AND ( p_project_id IS NULL
325: OR p_project_id IN(SELECT rt.project_id
326: FROM rcv_transactions rt

Line 326: FROM rcv_transactions rt

322: FROM rcv_transactions rt
323: WHERE rt.shipment_line_id = rsl.shipment_line_id))
324: AND ( p_project_id IS NULL
325: OR p_project_id IN(SELECT rt.project_id
326: FROM rcv_transactions rt
327: WHERE rt.shipment_line_id = rsl.shipment_line_id))
328: AND ( p_task_id IS NULL
329: OR p_task_id IN(SELECT rt.task_id
330: FROM rcv_transactions rt

Line 330: FROM rcv_transactions rt

326: FROM rcv_transactions rt
327: WHERE rt.shipment_line_id = rsl.shipment_line_id))
328: AND ( p_task_id IS NULL
329: OR p_task_id IN(SELECT rt.task_id
330: FROM rcv_transactions rt
331: WHERE rt.shipment_line_id = rsl.shipment_line_id))
332: AND rsl.requisition_line_id = p_supply_demand_line_id;
333:
334: CURSOR get_rcv_oe_row IS

Line 360: FROM rcv_transactions_interface rti,

356: rti.item_id,
357: rti.unit_of_measure,
358: rti.primary_unit_of_measure,
359: rti.to_organization_id
360: FROM rcv_transactions_interface rti,
361: rcv_transactions rt
362: WHERE rti.parent_transaction_id = rt.transaction_id(+)
363: AND rti.quantity > 0
364: AND ( rti.transaction_type IN('RECEIVE', 'SHIP', 'DELIVER')

Line 361: rcv_transactions rt

357: rti.unit_of_measure,
358: rti.primary_unit_of_measure,
359: rti.to_organization_id
360: FROM rcv_transactions_interface rti,
361: rcv_transactions rt
362: WHERE rti.parent_transaction_id = rt.transaction_id(+)
363: AND rti.quantity > 0
364: AND ( rti.transaction_type IN('RECEIVE', 'SHIP', 'DELIVER')
365: OR ( rti.transaction_type = 'CORRECT'

Line 409: FROM rcv_transactions rt

405: AND ( p_locator_id IS NULL
406: OR p_locator_id = rsl.locator_id)
407: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
408: OR NVL(l_lpn_id, fnd_api.g_miss_num) IN(SELECT NVL(rt.lpn_id, fnd_api.g_miss_num)--Bug 5329067
409: FROM rcv_transactions rt
410: WHERE rt.shipment_line_id = rsl.shipment_line_id))
411: AND ( p_project_id IS NULL
412: OR p_project_id IN(SELECT rt.project_id
413: FROM rcv_transactions rt

Line 413: FROM rcv_transactions rt

409: FROM rcv_transactions rt
410: WHERE rt.shipment_line_id = rsl.shipment_line_id))
411: AND ( p_project_id IS NULL
412: OR p_project_id IN(SELECT rt.project_id
413: FROM rcv_transactions rt
414: WHERE rt.shipment_line_id = rsl.shipment_line_id))
415: AND ( p_task_id IS NULL
416: OR p_task_id IN(SELECT rt.task_id
417: FROM rcv_transactions rt

Line 417: FROM rcv_transactions rt

413: FROM rcv_transactions rt
414: WHERE rt.shipment_line_id = rsl.shipment_line_id))
415: AND ( p_task_id IS NULL
416: OR p_task_id IN(SELECT rt.task_id
417: FROM rcv_transactions rt
418: WHERE rt.shipment_line_id = rsl.shipment_line_id))
419: AND rsl.oe_order_line_id = p_supply_demand_line_id;
420:
421: /*

Line 458: FROM rcv_transactions_interface rti,

454: rti.item_id,
455: rti.unit_of_measure,
456: rti.primary_unit_of_measure,
457: rti.to_organization_id
458: FROM rcv_transactions_interface rti,
459: rcv_transactions rt
460: WHERE rti.parent_transaction_id = rt.transaction_id(+)
461: AND rti.quantity > 0
462: AND ( rti.transaction_type IN('RECEIVE', 'SHIP', 'DELIVER')

Line 459: rcv_transactions rt

455: rti.unit_of_measure,
456: rti.primary_unit_of_measure,
457: rti.to_organization_id
458: FROM rcv_transactions_interface rti,
459: rcv_transactions rt
460: WHERE rti.parent_transaction_id = rt.transaction_id(+)
461: AND rti.quantity > 0
462: AND ( rti.transaction_type IN('RECEIVE', 'SHIP', 'DELIVER')
463: OR ( rti.transaction_type = 'CORRECT'

Line 507: FROM rcv_transactions rt

503: AND ( p_locator_id IS NULL
504: OR p_locator_id = rsl.locator_id)
505: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
506: OR NVL(l_lpn_id, fnd_api.g_miss_num) IN(SELECT NVL(rt.lpn_id, fnd_api.g_miss_num) --Bug 5329067
507: FROM rcv_transactions rt
508: WHERE rt.shipment_line_id = rsl.shipment_line_id))
509: AND ( p_project_id IS NULL
510: OR p_project_id IN(SELECT rt.project_id
511: FROM rcv_transactions rt

Line 511: FROM rcv_transactions rt

507: FROM rcv_transactions rt
508: WHERE rt.shipment_line_id = rsl.shipment_line_id))
509: AND ( p_project_id IS NULL
510: OR p_project_id IN(SELECT rt.project_id
511: FROM rcv_transactions rt
512: WHERE rt.shipment_line_id = rsl.shipment_line_id))
513: AND ( p_task_id IS NULL
514: OR p_task_id IN(SELECT rt.task_id
515: FROM rcv_transactions rt

Line 515: FROM rcv_transactions rt

511: FROM rcv_transactions rt
512: WHERE rt.shipment_line_id = rsl.shipment_line_id))
513: AND ( p_task_id IS NULL
514: OR p_task_id IN(SELECT rt.task_id
515: FROM rcv_transactions rt
516: WHERE rt.shipment_line_id = rsl.shipment_line_id))
517: AND rsl.shipment_line_id = p_shipment_line_id;
518:
519: CURSOR get_rcv_po_row IS

Line 568: FROM rcv_transactions_interface rti,

564: rti.item_id,
565: rti.unit_of_measure,
566: rti.primary_unit_of_measure,
567: rti.to_organization_id
568: FROM rcv_transactions_interface rti,
569: rcv_transactions rt
570: WHERE rti.parent_transaction_id = rt.transaction_id(+)
571: AND ( rti.quantity > 0
572: OR (rti.quantity < 0 AND rti.transaction_type = 'CORRECT')

Line 569: rcv_transactions rt

565: rti.unit_of_measure,
566: rti.primary_unit_of_measure,
567: rti.to_organization_id
568: FROM rcv_transactions_interface rti,
569: rcv_transactions rt
570: WHERE rti.parent_transaction_id = rt.transaction_id(+)
571: AND ( rti.quantity > 0
572: OR (rti.quantity < 0 AND rti.transaction_type = 'CORRECT')
573: )--Bug 5329067

Line 624: FROM rcv_transactions rt

620: AND ( p_locator_id IS NULL
621: OR p_locator_id = rsl.locator_id)
622: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
623: OR NVL(l_lpn_id, fnd_api.g_miss_num) IN(SELECT NVL(rt.lpn_id, fnd_api.g_miss_num) --Bug 5329067
624: FROM rcv_transactions rt
625: WHERE rt.shipment_line_id = rsl.shipment_line_id))
626: AND ( p_project_id IS NULL
627: OR p_project_id IN(SELECT rt.project_id
628: FROM rcv_transactions rt

Line 628: FROM rcv_transactions rt

624: FROM rcv_transactions rt
625: WHERE rt.shipment_line_id = rsl.shipment_line_id))
626: AND ( p_project_id IS NULL
627: OR p_project_id IN(SELECT rt.project_id
628: FROM rcv_transactions rt
629: WHERE rt.shipment_line_id = rsl.shipment_line_id))
630: AND ( p_task_id IS NULL
631: OR p_task_id IN(SELECT rt.task_id
632: FROM rcv_transactions rt

Line 632: FROM rcv_transactions rt

628: FROM rcv_transactions rt
629: WHERE rt.shipment_line_id = rsl.shipment_line_id))
630: AND ( p_task_id IS NULL
631: OR p_task_id IN(SELECT rt.task_id
632: FROM rcv_transactions rt
633: WHERE rt.shipment_line_id = rsl.shipment_line_id))
634: AND rsl.po_line_location_id = p_supply_demand_line_id;
635:
636: x_order_row get_po_order%ROWTYPE;

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

750:
751: /*
752: The logic below first defaults x_rcv_order_quantity from the
753: backing docs. It then loops through all the rows in
754: rcv_transactions_interface (RTI) and rcv_shipment_lines (RSL).
755: If the row is in RSL then it increases the running value of
756: x_rcv_quantity by shipped_quantity for non-wms orgs and increases the value
757: of x_rcv_quantity by received_quantity for wms orgs. We know that RSL's
758: shipped_quantity and receipt_quantity are an accurate summation of all rcv_transaction