526:
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
568:
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
628:
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
656:
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