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.

[Home] [Help]

APPS.INV_3PL_BILLING_UNITS_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 75: FROM MTL_MATERIAL_TRANSACTIONS MMT

71: , WMS_DEPLOY.GET_CLIENT_CODE( inventory_item_id ) CLIENT_CODE
72: , MMT.transaction_action_id
73: , MMT.primary_quantity
74: , MMT.creation_date
75: FROM MTL_MATERIAL_TRANSACTIONS MMT
76: , MTL_3PL_LOCATOR_OCCUPANCY MLC
77: WHERE MMT.organization_id = MLC.organization_id
78: AND WMS_DEPLOY.GET_CLIENT_CODE( MMT.inventory_item_id ) = nvl(p_client_code, MLC.client_code)
79: AND MMT.locator_id = MLC.locator_id

Line 97: FROM MTL_MATERIAL_TRANSACTIONS MMT

93: , WMS_DEPLOY.GET_CLIENT_CODE( inventory_item_id ) CLIENT_CODE
94: , MMT.transaction_action_id
95: , MMT.primary_quantity
96: , MMT.creation_date
97: FROM MTL_MATERIAL_TRANSACTIONS MMT
98: WHERE
99: WMS_DEPLOY.GET_CLIENT_CODE( MMT.inventory_item_id ) IS NOT NULL
100: AND NOT EXISTS (SELECT 1
101: FROM MTL_3PL_LOCATOR_OCCUPANCY MLC

Line 121: FROM MTL_MATERIAL_TRANSACTIONS MMT

117: , WMS_DEPLOY.GET_CLIENT_CODE( inventory_item_id ) CLIENT_CODE
118: , MMT.transaction_action_id
119: , MMT.primary_quantity
120: , MMT.creation_date
121: FROM MTL_MATERIAL_TRANSACTIONS MMT
122: WHERE
123: WMS_DEPLOY.GET_CLIENT_CODE( MMT.inventory_item_id ) IS NOT NULL
124: AND WMS_DEPLOY.GET_CLIENT_CODE( MMT.inventory_item_id ) = p_client_code
125: AND NOT EXISTS (SELECT 1