APPS.INV_3PL_BILLING_UNITS_PVT dependencies on MTL_PARAMETERS

Line 82: AND EXISTS (SELECT 1 FROM mtl_parameters mp

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
83: WHERE wms_enabled_flag = 'Y'
84: AND mp.organization_id = mmt.organization_id)
85: ORDER BY MMT.inventory_item_id, MMT.locator_id, MMT.creation_date;
86:

Line 107: AND EXISTS (SELECT 1 FROM mtl_parameters mp

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
108: WHERE wms_enabled_flag = 'Y'
109: AND mp.organization_id = mmt.organization_id)
110: ORDER BY MMT.inventory_item_id, MMT.locator_id, MMT.creation_date;
111:

Line 132: AND EXISTS (SELECT 1 FROM mtl_parameters mp

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
133: WHERE wms_enabled_flag = 'Y'
134: AND mp.organization_id = mmt.organization_id)
135: ORDER BY MMT.inventory_item_id, MMT.locator_id, MMT.creation_date;
136: