3319: BEGIN
3320:
3321: select ORGANIZATION_ID, ASSEMBLY_ITEM_ID
3322: into COMMON_ORGANIZATION_ID, COMMON_INVENTORY_ITEM_ID
3323: from BOM_BILL_OF_MATERIALS
3324: where BILL_SEQUENCE_ID in (select SOURCE_BILL_SEQUENCE_ID from BOM_BILL_OF_MATERIALS
3325: where ORGANIZATION_ID = in_organization_id
3326: and ASSEMBLY_ITEM_ID = in_inventory_item_id);
3327:
3320:
3321: select ORGANIZATION_ID, ASSEMBLY_ITEM_ID
3322: into COMMON_ORGANIZATION_ID, COMMON_INVENTORY_ITEM_ID
3323: from BOM_BILL_OF_MATERIALS
3324: where BILL_SEQUENCE_ID in (select SOURCE_BILL_SEQUENCE_ID from BOM_BILL_OF_MATERIALS
3325: where ORGANIZATION_ID = in_organization_id
3326: and ASSEMBLY_ITEM_ID = in_inventory_item_id);
3327:
3328: