DBA Data[Home] [Help]

APPS.BOM_COMPONENT_API dependencies on MTL_ITEM_SUB_INVENTORIES

Line 3034: mtl_item_sub_inventories item

3030: BEGIN
3031: SELECT locator_type
3032: INTO sub_loc_code
3033: FROM mtl_secondary_inventories sub,
3034: mtl_item_sub_inventories item
3035: WHERE item.organization_id = sub.organization_id
3036: AND item.secondary_inventory =
3037: sub.secondary_inventory_name
3038: AND item.inventory_item_id = c3rec.CII

Line 3054: mtl_item_sub_inventories item

3050: BEGIN
3051: SELECT locator_type
3052: INTO sub_loc_code
3053: FROM mtl_secondary_inventories sub,
3054: mtl_item_sub_inventories item
3055: WHERE item.organization_id = sub.organization_id
3056: AND item.secondary_inventory =
3057: sub.secondary_inventory_name
3058: AND item.inventory_item_id = c3rec.CII

Line 4224: mtl_item_sub_inventories item

4220: BEGIN
4221: SELECT locator_type
4222: INTO sub_loc_code
4223: FROM mtl_secondary_inventories sub,
4224: mtl_item_sub_inventories item
4225: WHERE item.organization_id = sub.organization_id
4226: AND item.secondary_inventory =
4227: sub.secondary_inventory_name
4228: AND item.inventory_item_id = c1rec.CII

Line 4244: mtl_item_sub_inventories item

4240: BEGIN
4241: SELECT locator_type
4242: INTO sub_loc_code
4243: FROM mtl_secondary_inventories sub,
4244: mtl_item_sub_inventories item
4245: WHERE item.organization_id = sub.organization_id
4246: AND item.secondary_inventory =
4247: sub.secondary_inventory_name
4248: AND item.inventory_item_id = c1rec.CII