DBA Data[Home] [Help]

APPS.INV_RESERVATION_AVAIL_PVT dependencies on RCV_TRANSACTIONS_INTERFACE

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'