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.INV_RESERVATION_AVAIL_PVT dependencies on RCV_TRANSACTIONS

Line 621: FROM rcv_transactions_interface rti

617: IF nvl(l_primary_reserved_quantity,0) > 0 THEN
618: BEGIN
619: SELECT Nvl(ABS(SUM(primary_quantity)),0)
620: INTO l_rti_primary_quantity
621: FROM rcv_transactions_interface rti
622: WHERE to_organization_id = p_organization_id
623: AND item_id = p_item_id
624: AND NVL(item_revision, '@@@') = NVL(p_revision,NVL(item_revision, '@@@'))
625: AND rti.processing_status_code <> 'ERROR'

Line 627: AND NOT exists (SELECT '1' FROM rcv_transactions rt

623: AND item_id = p_item_id
624: AND NVL(item_revision, '@@@') = NVL(p_revision,NVL(item_revision, '@@@'))
625: AND rti.processing_status_code <> 'ERROR'
626: AND rti.transaction_status_code <> 'ERROR'
627: AND NOT exists (SELECT '1' FROM rcv_transactions rt
628: WHERE rt.interface_transaction_id = rti.interface_transaction_id)
629: AND (TRANSACTION_TYPE = 'DELIVER'
630: OR (TRANSACTION_TYPE IN ('RETURN TO VENDOR','RETURN TO CUSTOMER')
631: AND EXISTS (SELECT '1' FROM rcv_transactions rt

Line 631: AND EXISTS (SELECT '1' FROM rcv_transactions rt

627: AND NOT exists (SELECT '1' FROM rcv_transactions rt
628: WHERE rt.interface_transaction_id = rti.interface_transaction_id)
629: AND (TRANSACTION_TYPE = 'DELIVER'
630: OR (TRANSACTION_TYPE IN ('RETURN TO VENDOR','RETURN TO CUSTOMER')
631: AND EXISTS (SELECT '1' FROM rcv_transactions rt
632: WHERE rt.transaction_id = rti.parent_transaction_id
633: AND rt.transaction_type IN ('RECEIVE','ACCEPT','REJECT','TRANSFER')))
634: OR (TRANSACTION_TYPE IN ('CORRECT')
635: AND quantity < 0

Line 636: AND EXISTS (SELECT '1' FROM rcv_transactions rt

632: WHERE rt.transaction_id = rti.parent_transaction_id
633: AND rt.transaction_type IN ('RECEIVE','ACCEPT','REJECT','TRANSFER')))
634: OR (TRANSACTION_TYPE IN ('CORRECT')
635: AND quantity < 0
636: AND EXISTS (SELECT '1' FROM rcv_transactions rt
637: WHERE rt.transaction_id = rti.parent_transaction_id
638: AND rt.transaction_type IN ('RECEIVE')))
639: OR (TRANSACTION_TYPE IN ('CORRECT')
640: AND quantity > 0

Line 641: AND EXISTS (SELECT '1' FROM rcv_transactions rt

637: WHERE rt.transaction_id = rti.parent_transaction_id
638: AND rt.transaction_type IN ('RECEIVE')))
639: OR (TRANSACTION_TYPE IN ('CORRECT')
640: AND quantity > 0
641: AND EXISTS (SELECT '1' FROM rcv_transactions rt
642: WHERE rt.transaction_id = rti.parent_transaction_id
643: AND rt.transaction_type IN ('DELIVER'))));
644: EXCEPTION
645: WHEN OTHERS THEN