289: CURSOR c_optional IS
290: select 1
291: from
292: msd_dem_app_instance_orgs morg,
293: bom_bill_of_materials bbm,
294: mtl_system_items msi, -- Parent
295: bom_inventory_components bic
296: where
297: bic.bill_sequence_id = bbm.bill_sequence_id
335: count(1)
336: FROM
337: mtl_system_items parent,
338: bom_inventory_components bic,
339: bom_bill_of_materials bom
340: WHERE
341: parent.bom_item_type = 5 and
342: parent.organization_id = bom.organization_id and
343: bom.ASSEMBLY_ITEM_ID = parent.inventory_item_id and
747: CURSOR C_IS_OPTIONAL
748: IS
749: SELECT 1
750: FROM msd_dem_app_instance_orgs mdaio,
751: bom_bill_of_materials bbm,
752: mtl_system_items msi,
753: bom_inventory_components bic
754: WHERE
755: bic.component_sequence_id = x_component_sequence_id
771: IS
772: SELECT
773: 1
774: FROM msd_dem_app_instance_orgs mdaio,
775: bom_bill_of_materials bbm,
776: mtl_system_items msi,
777: bom_inventory_components bic
778: WHERE
779: bic.component_sequence_id = x_component_sequence_id