APPS.BOM_VALIDATE_SUB_COMPONENT dependencies on MTL_SYSTEM_ITEMS

Line 155: FROM mtl_system_items msi,

151: l_parent_BIT,
152: l_parent_PTO_flag,
153: l_rec_ATO_flag,
154: l_rec_optional
155: FROM mtl_system_items msi,
156: mtl_system_items msi2,
157: bom_inventory_components bic,
158: bom_bill_of_materials bbom
159: WHERE msi.inventory_item_id = bbom.assembly_item_id

Line 156: mtl_system_items msi2,

152: l_parent_PTO_flag,
153: l_rec_ATO_flag,
154: l_rec_optional
155: FROM mtl_system_items msi,
156: mtl_system_items msi2,
157: bom_inventory_components bic,
158: bom_bill_of_materials bbom
159: WHERE msi.inventory_item_id = bbom.assembly_item_id
160: AND msi.organization_id = bbom.organization_id

Line 242: FROM mtl_system_items_b msi,

238: END;
239:
240: SELECT msi.bom_enabled_flag
241: INTO l_assy_bom_enabled
242: FROM mtl_system_items_b msi,
243: bom_bill_of_materials bbom
244: WHERE bbom.bill_sequence_id = l_rec_BSI
245: AND bbom.assembly_item_id = msi.inventory_item_id
246: AND bbom.organization_id = msi.organization_id;

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

361: END IF;
362:
363: -----------------------------------------------------------------------
364: -- Check new substitute component item (for create or update) already |
365: -- exists in MTL_SYSTEM_ITEMS and has the correct item attributes |
366: -----------------------------------------------------------------------
367:
368: stmt_num := 7;
369: BEGIN

Line 374: FROM mtl_system_items

370: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Verify sub. comp. exists in MTL_System_Item with correct attributes . . .'); END IF;
371:
372: SELECT bom_item_type, bom_enabled_flag, eng_item_flag ,tracking_quantity_ind
373: INTO l_sbc_item_type, l_sbc_bom_enabled_flag, l_sbc_eng_item_flag,l_sbc_tracking_qty_ind
374: FROM mtl_system_items
375: WHERE organization_id = p_Sub_Comp_Unexp_Rec.Organization_Id
376: AND inventory_item_id = decode(p_Sub_Comp_Unexp_Rec.new_substitute_component_id,
377: NULL,
378: p_Sub_Comp_Unexp_Rec.substitute_component_id,

Line 459: FROM mtl_system_items msi

455: AND bbom.common_bill_sequence_id = l_rec_BSI
456: AND bbom.organization_id <> bbom.common_organization_id
457: AND not exists
458: (SELECT null
459: FROM mtl_system_items msi
460: WHERE msi.organization_id = bbom.organization_id
461: AND msi.inventory_item_id =
462: decode(p_Sub_Comp_Unexp_Rec.new_substitute_component_id,
463: NULL,

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

769: BEGIN
770: /* Enforce_Integer can be UP only if the component item's rounding control type allows
771: to round order quantities */
772:
773: SELECT 'x' INTO l_dummy FROM mtl_system_items WHERE
774: inventory_item_id = p_sub_comp_unexp_rec.component_item_id
775: AND organization_id = p_sub_comp_unexp_rec.organization_id
776: AND rounding_control_type = 1;
777:

Line 1033: FROM mtl_system_items

1029: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1030: l_Return_Status VARCHAR2(1);
1031: CURSOR c_GetSubCompType IS
1032: SELECT bom_item_type
1033: FROM mtl_system_items
1034: WHERE inventory_item_id = p_sub_comp_unexp_rec.substitute_component_id
1035: AND organization_id = p_sub_comp_unexp_rec.organization_id;
1036:
1037: BEGIN