APPS.BOM_VALIDATE_SUB_COMPONENT dependencies on MTL_SYSTEM_ITEMS

Line 144: FROM mtl_system_items msi,

140: l_rec_BIT,
141: l_rec_CII,
142: l_rec_ID,
143: l_parent_BIT
144: FROM mtl_system_items msi,
145: bom_inventory_components bic,
146: bom_bill_of_materials bbom
147: WHERE msi.inventory_item_id = bbom.assembly_item_id
148: AND msi.organization_id = bbom.organization_id

Line 181: FROM mtl_system_items_b msi,

177: END;
178:
179: SELECT msi.bom_enabled_flag
180: INTO l_assy_bom_enabled
181: FROM mtl_system_items_b msi,
182: bom_bill_of_materials bbom
183: WHERE bbom.bill_sequence_id = l_rec_BSI
184: AND bbom.assembly_item_id = msi.inventory_item_id
185: AND bbom.organization_id = msi.organization_id;

Line 304: -- exists in MTL_SYSTEM_ITEMS and has the correct item attributes |

300: END IF;
301:
302: -----------------------------------------------------------------------
303: -- Check new substitute component item (for create or update) already |
304: -- exists in MTL_SYSTEM_ITEMS and has the correct item attributes |
305: -----------------------------------------------------------------------
306:
307: stmt_num := 7;
308: BEGIN

Line 313: FROM mtl_system_items

309: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Verify sub. comp. exists in MTL_System_Item with correct attributes . . .'); END IF;
310:
311: SELECT bom_item_type, bom_enabled_flag, eng_item_flag ,tracking_quantity_ind
312: INTO l_sbc_item_type, l_sbc_bom_enabled_flag, l_sbc_eng_item_flag,l_sbc_tracking_qty_ind
313: FROM mtl_system_items
314: WHERE organization_id = p_Sub_Comp_Unexp_Rec.Organization_Id
315: AND inventory_item_id = decode(p_Sub_Comp_Unexp_Rec.new_substitute_component_id,
316: NULL,
317: p_Sub_Comp_Unexp_Rec.substitute_component_id,

Line 398: FROM mtl_system_items msi

394: AND bbom.common_bill_sequence_id = l_rec_BSI
395: AND bbom.organization_id <> bbom.common_organization_id
396: AND not exists
397: (SELECT null
398: FROM mtl_system_items msi
399: WHERE msi.organization_id = bbom.organization_id
400: AND msi.inventory_item_id =
401: decode(p_Sub_Comp_Unexp_Rec.new_substitute_component_id,
402: NULL,

Line 712: SELECT 'x' INTO l_dummy FROM mtl_system_items WHERE

708: BEGIN
709: /* Enforce_Integer can be UP only if the component item's rounding control type allows
710: to round order quantities */
711:
712: SELECT 'x' INTO l_dummy FROM mtl_system_items WHERE
713: inventory_item_id = p_sub_comp_unexp_rec.component_item_id
714: AND organization_id = p_sub_comp_unexp_rec.organization_id
715: AND rounding_control_type = 1;
716:

Line 972: FROM mtl_system_items

968: l_Token_Tbl Error_Handler.Token_Tbl_Type;
969: l_Return_Status VARCHAR2(1);
970: CURSOR c_GetSubCompType IS
971: SELECT bom_item_type
972: FROM mtl_system_items
973: WHERE inventory_item_id = p_sub_comp_unexp_rec.substitute_component_id
974: AND organization_id = p_sub_comp_unexp_rec.organization_id;
975:
976: BEGIN