DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on RCV_TRANSACTIONS

Line 4302: FROM rcv_transactions rt

4298: -- since subinventory and locator information exists only for inventory transaction and not for RECEIVING
4299: CURSOR fetch_subinventory_loc IS
4300: SELECT DISTINCT subinventory,
4301: locator_id
4302: FROM rcv_transactions rt
4303: WHERE rt.shipment_header_id = p_sample.receipt_id
4304: AND rt.shipment_line_id = p_sample.receipt_line_id
4305: AND rt.destination_type_code = 'INVENTORY'
4306: AND rt.transaction_type = 'DELIVER';