APPS.MSD_SR_UTIL dependencies on BOM_BILL_OF_MATERIALS

Line 530: bom_bill_of_materials bbm,

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

Line 572: bom_bill_of_materials bbm,

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

Line 632: bom_bill_of_materials bbm,

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

Line 660: bom_bill_of_materials bbm,

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

Line 721: FROM bom_bill_of_materials assemb,

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

Line 892: bom_bill_of_materials bom

888: count(1)
889: FROM
890: mtl_system_items parent,
891: bom_inventory_components bic,
892: bom_bill_of_materials bom
893: WHERE
894: parent.bom_item_type = 5 and
895: parent.organization_id = bom.organization_id and
896: bom.ASSEMBLY_ITEM_ID = parent.inventory_item_id and