DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on RCV_TRANSACTIONS

Line 3665: FROM rcv_transactions rt

3661: -- since subinventory and locator information exists only for inventory transaction and not for RECEIVING
3662: CURSOR fetch_subinventory_loc IS
3663: SELECT DISTINCT subinventory,
3664: locator_id
3665: FROM rcv_transactions rt
3666: WHERE rt.shipment_header_id = p_sample.receipt_id
3667: AND rt.shipment_line_id = p_sample.receipt_line_id
3668: AND rt.destination_type_code = 'INVENTORY'
3669: AND rt.transaction_type = 'DELIVER';