DBA Data[Home] [Help]

APPS.BOMPVALR dependencies on MTL_ITEM_SUB_INVENTORIES

Line 447: mtl_item_sub_inventories item

443: begin
444: select locator_type
445: into sub_loc_code
446: from mtl_secondary_inventories sub,
447: mtl_item_sub_inventories item
448: where item.organization_id = sub.organization_id
449: and item.secondary_inventory = sub.secondary_inventory_name
450: and item.inventory_item_id = c1rec.AII
451: and sub.secondary_inventory_name = c1rec.CS

Line 465: mtl_item_sub_inventories item

461: begin
462: select locator_type
463: into sub_loc_code
464: from mtl_secondary_inventories sub,
465: mtl_item_sub_inventories item
466: where item.organization_id = sub.organization_id
467: and item.secondary_inventory = sub.secondary_inventory_name
468: and item.inventory_item_id = c1rec.AII
469: and sub.secondary_inventory_name = c1rec.CS