DBA Data[Home] [Help]

APPS.INV_STANDALONE_SYNC_PUB dependencies on RCV_RECEIPT_CONFIRMATION_V

Line 95: FROM rcv_receipt_confirmation_v

91: UPDATE rcv_transactions
92: SET receipt_confirmation_extracted = l_RC_Extracted
93: WHERE transaction_id IN
94: (SELECT transaction_id
95: FROM rcv_receipt_confirmation_v
96: WHERE creation_date BETWEEN l_from_date AND l_to_date
97: AND category = nvl(l_category, category)
98: AND warehouse = l_warehouse
99: AND item = nvl(l_inventory_item, item)