APPS.BOM_VALIDATE_REF_DESIGNATOR dependencies on MTL_SYSTEM_ITEMS

Line 275: FROM mtl_system_items msi,

271: l_parent_BIT,
272: l_parent_PTO_flag,
273: l_rec_ATO_flag,
274: l_rec_optional
275: FROM mtl_system_items msi,
276: mtl_system_items msi2,
277: bom_inventory_components bic,
278: bom_bill_of_materials bbom
279: WHERE msi.inventory_item_id = bbom.assembly_item_id

Line 276: mtl_system_items msi2,

272: l_parent_PTO_flag,
273: l_rec_ATO_flag,
274: l_rec_optional
275: FROM mtl_system_items msi,
276: mtl_system_items msi2,
277: bom_inventory_components bic,
278: bom_bill_of_materials bbom
279: WHERE msi.inventory_item_id = bbom.assembly_item_id
280: AND msi.organization_id = bbom.organization_id

Line 366: FROM mtl_system_items_b msi,

362:
363: /*Check BOM enabled flag of the assembly*/
364: SELECT msi.bom_enabled_flag
365: INTO l_assy_bom_enabled
366: FROM mtl_system_items_b msi,
367: bom_bill_of_materials bbom
368: WHERE bbom.bill_sequence_id = p_Ref_Desg_Unexp_Rec.bill_sequence_id
369: AND bbom.assembly_item_id = msi.inventory_item_id
370: AND bbom.organization_id = msi.organization_id;

Line 567: mtl_system_items msi,

563: INTO l_dummy
564: FROM sys.dual
565: WHERE EXISTS (SELECT 'Planning Item'
566: FROM bom_bill_of_materials bom,
567: mtl_system_items msi,
568: bom_inventory_components bic
569: WHERE msi.bom_item_type = 3 /* PLANNING */
570: AND msi.inventory_item_id = bom.assembly_item_id
571: AND msi.organization_id = bom.organization_id

Line 882: FROM mtl_system_items msi,

878: l_parent_BIT,
879: l_parent_PTO_flag,
880: l_rec_ATO_flag,
881: l_rec_optional
882: FROM mtl_system_items msi,
883: mtl_system_items msi2,
884: bom_inventory_components bic,
885: bom_bill_of_materials bbom
886: WHERE msi.inventory_item_id = bbom.assembly_item_id

Line 883: mtl_system_items msi2,

879: l_parent_PTO_flag,
880: l_rec_ATO_flag,
881: l_rec_optional
882: FROM mtl_system_items msi,
883: mtl_system_items msi2,
884: bom_inventory_components bic,
885: bom_bill_of_materials bbom
886: WHERE msi.inventory_item_id = bbom.assembly_item_id
887: AND msi.organization_id = bbom.organization_id