140: FROM DUAL
141: WHERE EXISTS (
142: SELECT 1
143: FROM BOM_INVENTORY_COMPONENTS BIC,
144: BOM_BILL_OF_MATERIALS BBM
145: WHERE BIC.bill_sequence_id = BBM.bill_sequence_id
146: AND BBM.organization_id = arg_org_id
147: AND BIC.component_item_id = arg_item_id
148: AND BIC.supply_subinventory = arg_subinv
160: FROM DUAL
161: WHERE EXISTS (
162: SELECT 1
163: FROM BOM_INVENTORY_COMPONENTS BIC,
164: BOM_BILL_OF_MATERIALS BBM
165: WHERE BIC.bill_sequence_id = BBM.bill_sequence_id
166: AND BBM.organization_id = arg_org_id
167: AND BIC.component_item_id = arg_item_id
168: AND BIC.supply_subinventory IS NULL);