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 3359: , mtl_secondary_inventories msi

3355: , NULL, 0
3356: , 1
3357: ) parent_line_id
3358: FROM mtl_material_transactions_temp mmtt
3359: , mtl_secondary_inventories msi
3360: , mtl_item_locations mil
3361: , mtl_txn_request_lines mtrl
3362: , wsh_delivery_details_ob_grp_v wdd
3363: , wsh_delivery_assignments_v wda

Line 3405: , mtl_secondary_inventories msi

3401: , NULL, 0
3402: , 1
3403: ) parent_line_id
3404: FROM mtl_material_transactions_temp mmtt
3405: , mtl_secondary_inventories msi
3406: , mtl_item_locations mil
3407: , mtl_txn_request_lines mtrl
3408: , mtl_txn_request_headers mtrh
3409: WHERE mmtt.organization_id = p_org_id

Line 3449: , mtl_secondary_inventories msi

3445: , NULL, 0
3446: , 1
3447: ) parent_line_id
3448: FROM mtl_material_transactions_temp mmtt
3449: , mtl_secondary_inventories msi
3450: , mtl_item_locations mil
3451: , mtl_txn_request_lines mtrl
3452: , mtl_txn_request_headers mtrh
3453: WHERE mmtt.organization_id = p_org_id

Line 8624: FROM mtl_secondary_inventories msi

8620: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
8621: AND mmtt.transaction_action_id in (2,28)
8622: AND EXISTS
8623: ( SELECT 'x'
8624: FROM mtl_secondary_inventories msi
8625: WHERE msi.secondary_inventory_name = mmtt.transfer_subinventory
8626: AND msi.organization_id = mmtt.organization_id
8627: AND NVL(msi.disable_date,sysdate + 1)
8628: > sysdate