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 WMS_DEPLOY

Line 71: , WMS_DEPLOY.GET_CLIENT_CODE( inventory_item_id ) CLIENT_CODE

67: CURSOR sel_eligible_transactions (p_end_date DATE, p_client_code VARCHAR2)
68: IS
69: SELECT /*+ parallel(MMT) */ MMT.locator_id
70: , MMT.organization_id
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

Line 78: AND WMS_DEPLOY.GET_CLIENT_CODE( MMT.inventory_item_id ) = nvl(p_client_code, MLC.client_code)

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
80: AND MMT.creation_date between MLC.last_invoiced_date and p_end_date
81: AND MMT.transaction_action_id not in (5,6,24,30,26,7,11,17,10,9,13,14,56,57)
82: AND EXISTS (SELECT 1 FROM mtl_parameters mp

Line 93: , WMS_DEPLOY.GET_CLIENT_CODE( inventory_item_id ) CLIENT_CODE

89: IS
90:
91: SELECT /*+ parallel(MMT) */ MMT.locator_id
92: , MMT.organization_id
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

Line 99: WMS_DEPLOY.GET_CLIENT_CODE( MMT.inventory_item_id ) IS NOT NULL

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
102: WHERE MMT.organization_id = MLC.organization_id
103: AND WMS_DEPLOY.GET_CLIENT_CODE( MMT.inventory_item_id ) = MLC.client_code

Line 103: AND WMS_DEPLOY.GET_CLIENT_CODE( MMT.inventory_item_id ) = MLC.client_code

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
102: WHERE MMT.organization_id = MLC.organization_id
103: AND WMS_DEPLOY.GET_CLIENT_CODE( MMT.inventory_item_id ) = MLC.client_code
104: AND MMT.locator_id = MLC.locator_id)
105: AND MMT.creation_date BETWEEN p_start_date AND p_end_date
106: AND MMT.transaction_action_id not in (5,6,24,30,26,7,11,17,10,9,13,14,56,57)
107: AND EXISTS (SELECT 1 FROM mtl_parameters mp

Line 117: , WMS_DEPLOY.GET_CLIENT_CODE( inventory_item_id ) CLIENT_CODE

113: IS
114:
115: SELECT /*+ parallel(MMT) */ MMT.locator_id
116: , MMT.organization_id
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

Line 123: WMS_DEPLOY.GET_CLIENT_CODE( MMT.inventory_item_id ) IS NOT NULL

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
126: FROM MTL_3PL_LOCATOR_OCCUPANCY MLC
127: WHERE MMT.organization_id = MLC.organization_id

Line 124: AND WMS_DEPLOY.GET_CLIENT_CODE( MMT.inventory_item_id ) = p_client_code

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
126: FROM MTL_3PL_LOCATOR_OCCUPANCY MLC
127: WHERE MMT.organization_id = MLC.organization_id
128: AND WMS_DEPLOY.GET_CLIENT_CODE( MMT.inventory_item_id ) = p_client_code

Line 128: AND WMS_DEPLOY.GET_CLIENT_CODE( MMT.inventory_item_id ) = p_client_code

124: AND WMS_DEPLOY.GET_CLIENT_CODE( MMT.inventory_item_id ) = p_client_code
125: AND NOT EXISTS (SELECT 1
126: FROM MTL_3PL_LOCATOR_OCCUPANCY MLC
127: WHERE MMT.organization_id = MLC.organization_id
128: AND WMS_DEPLOY.GET_CLIENT_CODE( MMT.inventory_item_id ) = p_client_code
129: AND MMT.locator_id = MLC.locator_id)
130: AND MMT.creation_date BETWEEN p_start_date AND p_end_date
131: AND MMT.transaction_action_id not in (5,6,24,30,26,7,11,17,10,9,13,14,56,57)
132: AND EXISTS (SELECT 1 FROM mtl_parameters mp

Line 330: WHERE profile_option_name = 'WMS_DEPLOYMENT_MODE'

326: BEGIN
327: SELECT creation_date
328: INTO l_profile_creation_date
329: FROM fnd_profile_options
330: WHERE profile_option_name = 'WMS_DEPLOYMENT_MODE'
331: AND application_id = 385;
332: EXCEPTION
333: WHEN OTHERS THEN
334: l_profile_creation_date:= NULL;