APPS.INV_3PL_BILLING_UNITS_PVT dependencies on MTL_3PL_LOCATOR_OCCUPANCY

Line 76: , MTL_3PL_LOCATOR_OCCUPANCY MLC

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
80: AND MMT.creation_date between MLC.last_invoiced_date and p_end_date

Line 101: FROM MTL_3PL_LOCATOR_OCCUPANCY MLC

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
104: AND MMT.locator_id = MLC.locator_id)
105: AND MMT.creation_date BETWEEN p_start_date AND p_end_date

Line 126: FROM MTL_3PL_LOCATOR_OCCUPANCY MLC

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
129: AND MMT.locator_id = MLC.locator_id)
130: AND MMT.creation_date BETWEEN p_start_date AND p_end_date

Line 320: FROM mtl_3pl_locator_occupancy

316:
317: BEGIN
318: SELECT upgrade_date
319: INTO l_upgrade_date
320: FROM mtl_3pl_locator_occupancy
321: WHERE upgrade_date IS NOT NULL
322: AND ROWNUM <2;
323:
324: EXCEPTION