APPS.INV_REPLENISH_COUNT_PVT dependencies on MTL_SECONDARY_LOCATORS

Line 331: FROM mtl_item_locations mil, mtl_system_items_vl msiv, mtl_secondary_locators msl, mtl_replenish_lines mrl, mfg_lookups ml

327: , ml.meaning count_type
328: , mrl.replenishment_line_id replenishment_line_id
329: , msiv.description item_description
330: , msiv.primary_uom_code primary_uom_code
331: FROM mtl_item_locations mil, mtl_system_items_vl msiv, mtl_secondary_locators msl, mtl_replenish_lines mrl, mfg_lookups ml
332: WHERE msl.inventory_item_id = msiv.inventory_item_id
333: AND msl.organization_id = msiv.organization_id
334: AND msl.secondary_locator = mil.inventory_location_id
335: AND msl.organization_id = mil.organization_id

Line 558: FROM mtl_secondary_locators msl, mtl_item_locations mil, mtl_system_items msi

554: locator_id IS NULL
555: OR count_type_code = 3
556: OR NOT EXISTS(
557: SELECT maximum_quantity
558: FROM mtl_secondary_locators msl, mtl_item_locations mil, mtl_system_items msi
559: WHERE msl.inventory_item_id = mrl.inventory_item_id
560: AND msl.secondary_locator = mrl.locator_id
561: AND msl.organization_id = mrl.organization_id
562: AND msi.inventory_item_id = msl.inventory_item_id

Line 572: FROM mtl_secondary_locators msl, mtl_item_locations mil, mtl_system_items msi

568: AND NVL(mil.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE))
569: OR(
570: EXISTS(
571: SELECT maximum_quantity
572: FROM mtl_secondary_locators msl, mtl_item_locations mil, mtl_system_items msi
573: WHERE msl.inventory_item_id = mrl.inventory_item_id
574: AND msl.secondary_locator = mrl.locator_id
575: AND msl.organization_id = mrl.organization_id
576: AND msi.inventory_item_id = msl.inventory_item_id