eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_PICK_DROP_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 3546: , mtl_secondary_inventories msi

3542: , NULL, 0
3543: , 1
3544: ) parent_line_id
3545: FROM mtl_material_transactions_temp mmtt
3546: , mtl_secondary_inventories msi
3547: , mtl_item_locations mil
3548: , mtl_txn_request_lines mtrl
3549: , wsh_delivery_details_ob_grp_v wdd
3550: , wsh_delivery_assignments_v wda

Line 3594: , mtl_secondary_inventories msi

3590: , NULL, 0
3591: , 1
3592: ) parent_line_id
3593: FROM mtl_material_transactions_temp mmtt
3594: , mtl_secondary_inventories msi
3595: , mtl_item_locations mil
3596: , mtl_txn_request_lines mtrl
3597: , mtl_txn_request_headers mtrh
3598: , wms_dispatched_tasks wdt -- Added for bug 12853197

Line 3642: , mtl_secondary_inventories msi

3638: , NULL, 0
3639: , 1
3640: ) parent_line_id
3641: FROM mtl_material_transactions_temp mmtt
3642: , mtl_secondary_inventories msi
3643: , mtl_item_locations mil
3644: , mtl_txn_request_lines mtrl
3645: , mtl_txn_request_headers mtrh
3646: WHERE mmtt.organization_id = p_org_id

Line 8918: FROM mtl_secondary_inventories msi

8914: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
8915: AND mmtt.transaction_action_id in (2,28)
8916: AND EXISTS
8917: ( SELECT 'x'
8918: FROM mtl_secondary_inventories msi
8919: WHERE msi.secondary_inventory_name = mmtt.transfer_subinventory
8920: AND msi.organization_id = mmtt.organization_id
8921: AND NVL(msi.disable_date,sysdate + 1)
8922: > sysdate