DBA Data[Home] [Help]

APPS.PO_CHG_REQUEST_PVT dependencies on RCV_TRANSACTIONS_INTERFACE

Line 3188: from RCV_TRANSACTIONS_INTERFACE rti

3184: if ( l_po_change_requests(j).action_type in ('CANCELLATION')) then --AND
3185: -- l_po_change_requests(j).request_level='SHIPMENT' ) then
3186: select count(*)
3187: into l_count_asn
3188: from RCV_TRANSACTIONS_INTERFACE rti
3189: where rti.TRANSACTION_TYPE = 'SHIP' and
3190: rti.PROCESSING_STATUS_CODE = 'PENDING' and
3191: rti.quantity > 0 and
3192: rti.PO_HEADER_ID = p_po_header_id and