DBA Data[Home] [Help]

APPS.BOMPVALB dependencies on MTL_ITEM_SUB_INVENTORIES

Line 1747: mtl_item_sub_inventories item

1743: begin
1744: select locator_type
1745: into sub_loc_code
1746: from mtl_secondary_inventories sub,
1747: mtl_item_sub_inventories item
1748: where item.organization_id = sub.organization_id
1749: and item.secondary_inventory = sub.secondary_inventory_name
1750: and item.inventory_item_id = c1rec.CII
1751: and sub.secondary_inventory_name = c1rec.SS

Line 1765: mtl_item_sub_inventories item

1761: begin
1762: select locator_type
1763: into sub_loc_code
1764: from mtl_secondary_inventories sub,
1765: mtl_item_sub_inventories item
1766: where item.organization_id = sub.organization_id
1767: and item.secondary_inventory = sub.secondary_inventory_name
1768: and item.inventory_item_id = c1rec.CII
1769: and sub.secondary_inventory_name = c1rec.SS