DBA Data[Home] [Help]

APPS.INV_REPLENISH_COUNT_PVT dependencies on MFG_LOOKUPS

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 369: FROM mtl_system_items_vl msiv, mtl_item_sub_inventories mis, mtl_replenish_lines mrl, mfg_lookups ml

365: , ml.meaning count_type
366: , mrl.replenishment_line_id replenishment_line_id
367: , msiv.description item_description
368: , msiv.primary_uom_code primary_uom_code
369: FROM mtl_system_items_vl msiv, mtl_item_sub_inventories mis, mtl_replenish_lines mrl, mfg_lookups ml
370: WHERE mis.inventory_item_id = msiv.inventory_item_id
371: AND mis.organization_id = msiv.organization_id
372: AND mis.organization_id = p_organization_id
373: AND mis.secondary_inventory = p_subinventory_code