APPS.MSD_SR_UTIL dependencies on BOM_BILL_OF_MATERIALS

Line 531: bom_bill_of_materials bbm,

527: CURSOR c_optional IS
528: select 1
529: from
530: msd_app_instance_orgs morg,
531: bom_bill_of_materials bbm,
532: mtl_system_items msi, -- Parent
533: bom_inventory_components bic
534: where
535: bic.bill_sequence_id = bbm.bill_sequence_id

Line 573: bom_bill_of_materials bbm,

569: CURSOR c_optional IS
570: select 1
571: from
572: msd_app_instance_orgs morg,
573: bom_bill_of_materials bbm,
574: mtl_system_items msi, -- Parent
575: bom_inventory_components bic
576: where
577: bic.bill_sequence_id = bbm.bill_sequence_id

Line 633: bom_bill_of_materials bbm,

629: CURSOR c_optional IS
630: select 1
631: from
632: msd_app_instance_orgs morg,
633: bom_bill_of_materials bbm,
634: mtl_system_items msi, -- Parent
635: bom_inventory_components bic
636: where
637: bic.component_sequence_id = l_component_seq_id

Line 661: bom_bill_of_materials bbm,

657: CURSOR c_parent_optional IS
658: select 1
659: from
660: msd_app_instance_orgs morg,
661: bom_bill_of_materials bbm,
662: mtl_system_items msi,
663: bom_inventory_components bic
664: where
665: bic.bill_sequence_id = bbm.bill_sequence_id

Line 722: FROM bom_bill_of_materials assemb,

718:
719:
720: CURSOR c_parent IS
721: SELECT assemb.assembly_item_id, msi.bom_item_type
722: FROM bom_bill_of_materials assemb,
723: bom_inventory_components comp,
724: mtl_system_items msi
725: WHERE
726: assemb.bill_sequence_id = comp.bill_sequence_id

Line 824: bom_bill_of_materials bom

820: count(1)
821: FROM
822: mtl_system_items parent,
823: bom_inventory_components bic,
824: bom_bill_of_materials bom
825: WHERE
826: parent.bom_item_type = 5 and
827: parent.organization_id = bom.organization_id and
828: bom.ASSEMBLY_ITEM_ID = parent.inventory_item_id and