The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
p_eam_wo_rec.batch_id batch_id
, p_eam_wo_rec.header_id header_id
, p_eam_wo_rec.wip_entity_id WIP_ENTITY_ID
, p_eam_wo_rec.organization_id ORGANIZATION_ID
, BOS.OPERATION_SEQUENCE_ID OPERATION_SEQUENCE_ID
, BOS.OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, BOS.STANDARD_OPERATION_ID STANDARD_OPERATION_ID
, BOS.DEPARTMENT_ID DEPARTMENT_ID
, BOS.OPERATION_DESCRIPTION DESCRIPTION
, BOS.LONG_DESCRIPTION LONG_DESCRIPTION
, 0 MINIMUM_TRANSFER_QUANTITY
, 1 COUNT_POINT_TYPE
, 1 BACKFLUSH_FLAG
, BOS.SHUTDOWN_TYPE SHUTDOWN_TYPE
, nvl(p_eam_wo_rec.scheduled_start_date,SYSDATE) START_DATE
, nvl(p_eam_wo_rec.scheduled_completion_date,SYSDATE) COMPLETION_DATE
, BOS.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, BOS.ATTRIBUTE1 ATTRIBUTE1
, BOS.ATTRIBUTE2 ATTRIBUTE2
, BOS.ATTRIBUTE3 ATTRIBUTE3
, BOS.ATTRIBUTE4 ATTRIBUTE4
, BOS.ATTRIBUTE5 ATTRIBUTE5
, BOS.ATTRIBUTE6 ATTRIBUTE6
, BOS.ATTRIBUTE7 ATTRIBUTE7
, BOS.ATTRIBUTE8 ATTRIBUTE8
, BOS.ATTRIBUTE9 ATTRIBUTE9
, BOS.ATTRIBUTE10 ATTRIBUTE10
, BOS.ATTRIBUTE11 ATTRIBUTE11
, BOS.ATTRIBUTE12 ATTRIBUTE12
, BOS.ATTRIBUTE13 ATTRIBUTE13
, BOS.ATTRIBUTE14 ATTRIBUTE14
, BOS.ATTRIBUTE15 ATTRIBUTE15
, null RETURN_STATUS
, 1 TRANSACTION_TYPE
-- Bug 3262984 : For adding attachments from the activity to the workorder on explosion
-- one of the entities requires common_routing_sequence_id as a primary key.Hence being added to the query.
, BORT.COMMON_ROUTING_SEQUENCE_ID COMMON_ROUTING_SEQUENCE_ID
, BOS.X_COORDINATE
, BOS.Y_COORDINATE
FROM BOM_OPERATION_SEQUENCES BOS
, BOM_OPERATIONAL_ROUTINGS BORT
WHERE BORT.assembly_item_id = p_eam_wo_rec.asset_activity_id
AND BORT.organization_id = p_eam_wo_rec.organization_id
AND BOS.ROUTING_SEQUENCE_ID = BORT.COMMON_ROUTING_SEQUENCE_ID -- agaurav- Changed ROUTING_SEQUENCE_ID to COMMON_ROUTING_SEQUENCE_ID
AND NVL(BOS.OPERATION_TYPE, 1) = 1
AND BOS.EFFECTIVITY_DATE <= p_rout_rev_datetime
AND NVL(BOS.DISABLE_DATE, p_rout_rev_datetime + 2) >= p_rout_rev_datetime
AND BOS.IMPLEMENTATION_DATE IS NOT NULL
AND ( ( p_eam_wo_rec.alternate_routing_designator is not null
AND nvl(BORT.ALTERNATE_ROUTING_DESIGNATOR,'null_routing_designator') = nvl(p_eam_wo_rec.alternate_routing_designator,'null_routing_designator') )
OR ( p_eam_wo_rec.alternate_routing_designator is null
AND nvl(BORT.ALTERNATE_ROUTING_DESIGNATOR,'null_routing_designator') = nvl(p_eam_wo_rec.alternate_routing_designator,'null_routing_designator') )
) ;
SELECT
p_eam_wo_rec.batch_id batch_id
, p_eam_wo_rec.header_id header_id
, p_eam_wo_rec.wip_entity_id WIP_ENTITY_ID
, p_eam_wo_rec.organization_id ORGANIZATION_ID
, BOS.OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, BOS.DEPARTMENT_ID DEPARTMENT_ID
, BOR.RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM
, BOR.RESOURCE_ID RESOURCE_ID
, BR.UNIT_OF_MEASURE UOM_CODE
, BOR.BASIS_TYPE BASIS_TYPE
, BOR.USAGE_RATE_OR_AMOUNT USAGE_RATE_OR_AMOUNT
, BOR.ACTIVITY_ID ACTIVITY_ID
, BOR.SCHEDULE_FLAG SCHEDULED_FLAG
, BOR.ASSIGNED_UNITS ASSIGNED_UNITS
--added for bug 4363800 decode statement to select 2,3 as eAM supports only 2 or 3
, DECODE(BOR.AUTOCHARGE_TYPE,1,2,4,3,3,3,2) AUTOCHARGE_TYPE -- Fix for Bug 3823415
, BOR.STANDARD_RATE_FLAG STANDARD_RATE_FLAG
, 0 APPLIED_RESOURCE_UNITS
, 0 APPLIED_RESOURCE_VALUE
, nvl(p_eam_wo_rec.scheduled_start_date,SYSDATE) START_DATE
, nvl(p_eam_wo_rec.scheduled_completion_date,SYSDATE) COMPLETION_DATE
, 0 REPLACEMENT_GROUP_NUM
, BOR.SCHEDULE_SEQ_NUM SCHEDULE_SEQ_NUM
, BOR.SUBSTITUTE_GROUP_NUM SUBSTITUTE_GROUP_NUM
, BOR.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, BOR.ATTRIBUTE1 ATTRIBUTE1
, BOR.ATTRIBUTE2 ATTRIBUTE2
, BOR.ATTRIBUTE3 ATTRIBUTE3
, BOR.ATTRIBUTE4 ATTRIBUTE4
, BOR.ATTRIBUTE5 ATTRIBUTE5
, BOR.ATTRIBUTE6 ATTRIBUTE6
, BOR.ATTRIBUTE7 ATTRIBUTE7
, BOR.ATTRIBUTE8 ATTRIBUTE8
, BOR.ATTRIBUTE9 ATTRIBUTE9
, BOR.ATTRIBUTE10 ATTRIBUTE10
, BOR.ATTRIBUTE11 ATTRIBUTE11
, BOR.ATTRIBUTE12 ATTRIBUTE12
, BOR.ATTRIBUTE13 ATTRIBUTE13
, BOR.ATTRIBUTE14 ATTRIBUTE14
, BOR.ATTRIBUTE15 ATTRIBUTE15
, null RETURN_STATUS
, 1 TRANSACTION_TYPE
FROM BOM_RESOURCES BR
, BOM_OPERATION_RESOURCES BOR
, BOM_OPERATION_SEQUENCES BOS
, BOM_OPERATIONAL_ROUTINGS BORT
WHERE BORT.assembly_item_id = p_eam_wo_rec.asset_activity_id
AND BORT.organization_id = p_eam_wo_rec.organization_id
AND BOS.ROUTING_SEQUENCE_ID = BORT.COMMON_ROUTING_SEQUENCE_ID -- agaurav- Changed ROUTING_SEQUENCE_ID to COMMON_ROUTING_SEQUENCE_ID
AND BOS.OPERATION_SEQUENCE_ID = BOR.OPERATION_SEQUENCE_ID
AND BOS.EFFECTIVITY_DATE <= p_rout_rev_datetime
AND NVL(BOS.DISABLE_DATE, p_rout_rev_datetime + 2) >= p_rout_rev_datetime
AND BOR.RESOURCE_ID = BR.RESOURCE_ID
AND BR.ORGANIZATION_ID = p_eam_wo_rec.organization_id
AND (BOR.ACD_TYPE IS NULL OR BOR.ACD_TYPE <> 3)
AND ( ( p_eam_wo_rec.alternate_routing_designator is not null
AND nvl(BORT.ALTERNATE_ROUTING_DESIGNATOR,'null_routing_designator') = nvl(p_eam_wo_rec.alternate_routing_designator,'null_routing_designator') )
OR ( p_eam_wo_rec.alternate_routing_designator is null
AND nvl(BORT.ALTERNATE_ROUTING_DESIGNATOR,'null_routing_designator') = nvl(p_eam_wo_rec.alternate_routing_designator,'null_routing_designator') )
) ;
SELECT
p_eam_wo_rec.batch_id batch_id
, p_eam_wo_rec.header_id header_id
, p_eam_wo_rec.wip_entity_id WIP_ENTITY_ID
, p_eam_wo_rec.organization_id ORGANIZATION_ID
, BOS_FROM.OPERATION_SEQ_NUM PRIOR_OPERATION
, BOS_TO.OPERATION_SEQ_NUM NEXT_OPERATION
, BON.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, BON.ATTRIBUTE1 ATTRIBUTE1
, BON.ATTRIBUTE2 ATTRIBUTE2
, BON.ATTRIBUTE3 ATTRIBUTE3
, BON.ATTRIBUTE4 ATTRIBUTE4
, BON.ATTRIBUTE5 ATTRIBUTE5
, BON.ATTRIBUTE6 ATTRIBUTE6
, BON.ATTRIBUTE7 ATTRIBUTE7
, BON.ATTRIBUTE8 ATTRIBUTE8
, BON.ATTRIBUTE9 ATTRIBUTE9
, BON.ATTRIBUTE10 ATTRIBUTE10
, BON.ATTRIBUTE11 ATTRIBUTE11
, BON.ATTRIBUTE12 ATTRIBUTE12
, BON.ATTRIBUTE13 ATTRIBUTE13
, BON.ATTRIBUTE14 ATTRIBUTE14
, BON.ATTRIBUTE15 ATTRIBUTE15
, null RETURN_STATUS
, 1 TRANSACTION_TYPE
FROM BOM_OPERATION_NETWORKS BON
, BOM_OPERATION_SEQUENCES BOS_FROM
, BOM_OPERATION_SEQUENCES BOS_TO
, BOM_OPERATIONAL_ROUTINGS BORT
WHERE BORT.assembly_item_id = p_eam_wo_rec.asset_activity_id
AND BORT.organization_id = p_eam_wo_rec.organization_id
AND BOS_FROM.ROUTING_SEQUENCE_ID = BORT.COMMON_ROUTING_SEQUENCE_ID -- agaurav- Changed ROUTING_SEQUENCE_ID to COMMON_ROUTING_SEQUENCE_ID
AND BOS_TO.ROUTING_SEQUENCE_ID = BORT.COMMON_ROUTING_SEQUENCE_ID -- agaurav- Changed ROUTING_SEQUENCE_ID to COMMON_ROUTING_SEQUENCE_ID
AND BOS_FROM.EFFECTIVITY_DATE <= p_rout_rev_datetime
AND NVL(BOS_FROM.DISABLE_DATE, p_rout_rev_datetime + 2) >= p_rout_rev_datetime
AND BOS_TO.EFFECTIVITY_DATE <= p_rout_rev_datetime
AND NVL(BOS_TO.DISABLE_DATE, p_rout_rev_datetime + 2) >= p_rout_rev_datetime
AND BON.FROM_OP_SEQ_ID = BOS_FROM.OPERATION_SEQUENCE_ID
AND BON.TO_OP_SEQ_ID = BOS_TO.OPERATION_SEQUENCE_ID
AND NVL(BON.EFFECTIVITY_DATE, SYSDATE-2) < SYSDATE
AND NVL(BON.DISABLE_DATE, SYSDATE+2) > SYSDATE
-- agaurav - Added the check for alternate_routing_designator so that the
-- - operations are copied either from the primary or alternate routing.
AND ( ( p_eam_wo_rec.alternate_routing_designator is not null
AND nvl(BORT.ALTERNATE_ROUTING_DESIGNATOR,'null_routing_designator') = nvl(p_eam_wo_rec.alternate_routing_designator,'null_routing_designator') )
OR ( p_eam_wo_rec.alternate_routing_designator is null
AND nvl(BORT.ALTERNATE_ROUTING_DESIGNATOR,'null_routing_designator') = nvl(p_eam_wo_rec.alternate_routing_designator,'null_routing_designator') )
)
-- Bugfix 3556118 : There should not be any operation as part of the
-- network that is outside it's effectivity dates. If there is even
-- one such operation, then don't create any networks.
AND NOT EXISTS (
select 1
FROM BOM_OPERATION_NETWORKS BON
, BOM_OPERATION_SEQUENCES BOS_FROM
, BOM_OPERATION_SEQUENCES BOS_TO
, BOM_OPERATIONAL_ROUTINGS BORT
WHERE BORT.assembly_item_id = p_eam_wo_rec.asset_activity_id
AND BORT.organization_id = p_eam_wo_rec.organization_id
AND BOS_FROM.ROUTING_SEQUENCE_ID = BORT.COMMON_ROUTING_SEQUENCE_ID
-- agaurav- Changed ROUTING_SEQUENCE_ID to COMMON_ROUTING_SEQUENCE_ID
AND BOS_TO.ROUTING_SEQUENCE_ID = BORT.COMMON_ROUTING_SEQUENCE_ID
-- agaurav- Changed ROUTING_SEQUENCE_ID to COMMON_ROUTING_SEQUENCE_ID
AND ( p_rout_rev_datetime NOT BETWEEN BOS_FROM.EFFECTIVITY_DATE AND
NVL(BOS_FROM.DISABLE_DATE, p_rout_rev_datetime)
OR p_rout_rev_datetime NOT BETWEEN BOS_TO.EFFECTIVITY_DATE AND
NVL(BOS_TO.DISABLE_DATE, p_rout_rev_datetime)
)
AND BON.FROM_OP_SEQ_ID = BOS_FROM.OPERATION_SEQUENCE_ID
AND BON.TO_OP_SEQ_ID = BOS_TO.OPERATION_SEQUENCE_ID
AND NVL(BON.EFFECTIVITY_DATE, SYSDATE-2) < SYSDATE
AND NVL(BON.DISABLE_DATE, SYSDATE+2) > SYSDATE
-- agaurav - Added the check for alternate_routing_designator so that the
-- - operations are copied either from the primary or alternate routing.
AND ( ( p_eam_wo_rec.alternate_routing_designator is not null
AND
nvl(BORT.ALTERNATE_ROUTING_DESIGNATOR,'null_routing_designator') =
nvl(p_eam_wo_rec.alternate_routing_designator,'null_routing_designator') )
OR ( p_eam_wo_rec.alternate_routing_designator is null
AND
nvl(BORT.ALTERNATE_ROUTING_DESIGNATOR,'null_routing_designator') =
nvl(p_eam_wo_rec.alternate_routing_designator,'null_routing_designator') )
)
);
(SELECT
p_eam_wo_rec.batch_id batch_id
, p_eam_wo_rec.header_id header_id
, null row_id
, p_eam_wo_rec.wip_entity_id WIP_ENTITY_ID
, p_eam_wo_rec.organization_id ORGANIZATION_ID
, BE.OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, BE.COMPONENT_ITEM_ID INVENTORY_ITEM_ID
, BE.COMPONENT_QUANTITY QUANTITY_PER_ASSEMBLY
, to_number(null) DEPARTMENT_ID
, BIC.WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE
, nvl(p_eam_wo_rec.scheduled_start_date,SYSDATE) DATE_REQUIRED
, extended_quantity REQUIRED_QUANTITY
--fix for 3550864.
, null REQUESTED_QUANTITY
--fix for 3571180
,null RELEASED_QUANTITY
, 0 QUANTITY_ISSUED
, NVL(BIC.SUPPLY_SUBINVENTORY, MSI.WIP_SUPPLY_SUBINVENTORY) SUPPLY_SUBINVENTORY
, DECODE(BIC.SUPPLY_SUBINVENTORY, NULL, MSI.WIP_SUPPLY_LOCATOR_ID,BIC.SUPPLY_LOCATOR_ID) SUPPLY_LOCATOR_ID
, wip_constants.SUPPLY_NET MRP_NET_FLAG
, 0 MPS_REQUIRED_QUANTITY
, null /*bugfix#5059638 nvl(p_eam_wo_rec.scheduled_start_date,SYSDATE)*/ MPS_DATE_REQUIRED
, BIC.COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, BIC.COMPONENT_REMARKS COMMENTS
, BIC.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, BIC.ATTRIBUTE1 ATTRIBUTE1
, BIC.ATTRIBUTE2 ATTRIBUTE2
, BIC.ATTRIBUTE3 ATTRIBUTE3
, BIC.ATTRIBUTE4 ATTRIBUTE4
, BIC.ATTRIBUTE5 ATTRIBUTE5
, BIC.ATTRIBUTE6 ATTRIBUTE6
, BIC.ATTRIBUTE7 ATTRIBUTE7
, BIC.ATTRIBUTE8 ATTRIBUTE8
, BIC.ATTRIBUTE9 ATTRIBUTE9
, BIC.ATTRIBUTE10 ATTRIBUTE10
, BIC.ATTRIBUTE11 ATTRIBUTE11
, BIC.ATTRIBUTE12 ATTRIBUTE12
, BIC.ATTRIBUTE13 ATTRIBUTE13
, BIC.ATTRIBUTE14 ATTRIBUTE14
, BIC.ATTRIBUTE15 ATTRIBUTE15
, BE.AUTO_REQUEST_MATERIAL AUTO_REQUEST_MATERIAL
, BIC.SUGGESTED_VENDOR_NAME SUGGESTED_VENDOR_NAME
, BIC.VENDOR_ID VENDOR_ID
, BIC.UNIT_PRICE UNIT_PRICE
, null REQUEST_ID
, null PROGRAM_APPLICATION_ID
, null PROGRAM_ID
, null PROGRAM_UPDATE_DATE
, null RETURN_STATUS
, 1 TRANSACTION_TYPE
FROM BOM_EXPLOSION_TEMP BE
, BOM_INVENTORY_COMPONENTS BIC
, MTL_SYSTEM_ITEMS MSI
WHERE BE.GROUP_ID = v_grpID
AND BE.COMPONENT_SEQUENCE_ID = BIC.COMPONENT_SEQUENCE_ID
AND BE.COMPONENT_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND BE.COMPONENT_ITEM_ID <> p_eam_wo_rec.asset_activity_id --EXCLUDE ASSY IF IT IS IN THE TABLE
AND MSI.ORGANIZATION_ID = p_eam_wo_rec.organization_id
AND BE.OPERATION_SEQ_NUM = 1)
UNION
(SELECT
p_eam_wo_rec.batch_id batch_id
, p_eam_wo_rec.header_id header_id
, null row_id
, p_eam_wo_rec.wip_entity_id WIP_ENTITY_ID
, p_eam_wo_rec.organization_id ORGANIZATION_ID
, BE.OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, BE.COMPONENT_ITEM_ID INVENTORY_ITEM_ID
, BE.COMPONENT_QUANTITY QUANTITY_PER_ASSEMBLY
, BOS.DEPARTMENT_ID DEPARTMENT_ID
, BIC.WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE
, nvl(p_eam_wo_rec.scheduled_start_date,SYSDATE) DATE_REQUIRED
, extended_quantity REQUIRED_QUANTITY
--fix for 3550864.
, null REQUESTED_QUANTITY
--fix for 3572280
, null RELEASED_QUANTITY
, 0 QUANTITY_ISSUED
, NVL(BIC.SUPPLY_SUBINVENTORY, MSI.WIP_SUPPLY_SUBINVENTORY) SUPPLY_SUBINVENTORY
, DECODE(BIC.SUPPLY_SUBINVENTORY, NULL, MSI.WIP_SUPPLY_LOCATOR_ID,BIC.SUPPLY_LOCATOR_ID) SUPPLY_LOCATOR_ID
, wip_constants.SUPPLY_NET MRP_NET_FLAG
, 0 MPS_REQUIRED_QUANTITY
, null /*bugfix#5059638 nvl(p_eam_wo_rec.scheduled_start_date,SYSDATE)*/ MPS_DATE_REQUIRED
, BIC.COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, BIC.COMPONENT_REMARKS COMMENTS
, BIC.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, BIC.ATTRIBUTE1 ATTRIBUTE1
, BIC.ATTRIBUTE2 ATTRIBUTE2
, BIC.ATTRIBUTE3 ATTRIBUTE3
, BIC.ATTRIBUTE4 ATTRIBUTE4
, BIC.ATTRIBUTE5 ATTRIBUTE5
, BIC.ATTRIBUTE6 ATTRIBUTE6
, BIC.ATTRIBUTE7 ATTRIBUTE7
, BIC.ATTRIBUTE8 ATTRIBUTE8
, BIC.ATTRIBUTE9 ATTRIBUTE9
, BIC.ATTRIBUTE10 ATTRIBUTE10
, BIC.ATTRIBUTE11 ATTRIBUTE11
, BIC.ATTRIBUTE12 ATTRIBUTE12
, BIC.ATTRIBUTE13 ATTRIBUTE13
, BIC.ATTRIBUTE14 ATTRIBUTE14
, BIC.ATTRIBUTE15 ATTRIBUTE15
, BE.AUTO_REQUEST_MATERIAL AUTO_REQUEST_MATERIAL
, BIC.SUGGESTED_VENDOR_NAME SUGGESTED_VENDOR_NAME
, BIC.VENDOR_ID VENDOR_ID
, BIC.UNIT_PRICE UNIT_PRICE
, null REQUEST_ID
, null PROGRAM_APPLICATION_ID
, null PROGRAM_ID
, null PROGRAM_UPDATE_DATE
, null RETURN_STATUS
, 1 TRANSACTION_TYPE
FROM BOM_EXPLOSION_TEMP BE
, BOM_INVENTORY_COMPONENTS BIC
, BOM_OPERATIONAL_ROUTINGS BORT
, BOM_OPERATION_SEQUENCES BOS
, MTL_SYSTEM_ITEMS MSI
WHERE BE.GROUP_ID = v_grpID
AND BE.COMPONENT_SEQUENCE_ID = BIC.COMPONENT_SEQUENCE_ID
AND BE.COMPONENT_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND BE.COMPONENT_ITEM_ID <> p_eam_wo_rec.asset_activity_id --EXCLUDE ASSY IF IT IS IN THE TABLE
AND MSI.ORGANIZATION_ID = p_eam_wo_rec.organization_id
AND BORT.assembly_item_id = p_eam_wo_rec.asset_activity_id
AND BORT.organization_id = p_eam_wo_rec.organization_id
AND BOS.ROUTING_SEQUENCE_ID = BORT.COMMON_ROUTING_SEQUENCE_ID
AND BOS.EFFECTIVITY_DATE <= p_bom_rev_datetime
AND NVL(BOS.DISABLE_DATE, p_bom_rev_datetime + 2) >= p_bom_rev_datetime
AND BE.OPERATION_SEQ_NUM = BIC.OPERATION_SEQ_NUM
AND BOS.OPERATION_SEQ_NUM = BIC.OPERATION_SEQ_NUM
AND NVL(BOS.OPERATION_TYPE, 1) = 1
AND BOS.EFFECTIVITY_DATE <= p_bom_rev_datetime
AND NVL(BOS.DISABLE_DATE, p_bom_rev_datetime + 2) >= p_bom_rev_datetime
AND BOS.IMPLEMENTATION_DATE IS NOT NULL
AND (( p_eam_wo_rec.alternate_routing_designator is not null
AND nvl(BORT.ALTERNATE_ROUTING_DESIGNATOR,'null_routing_designator') =
nvl(p_eam_wo_rec.alternate_routing_designator,'null_routing_designator')
)
OR
( p_eam_wo_rec.alternate_routing_designator is null
AND nvl(BORT.ALTERNATE_ROUTING_DESIGNATOR,'null_routing_designator') =
nvl(p_eam_wo_rec.alternate_routing_designator,'null_routing_designator')
)
)
AND BE.OPERATION_SEQ_NUM <> 1);
select
bom_explosion_temp_s.nextval
into l_group_id
from dual;
delete bom_explosion_temp
where group_id = l_group_id;
select bill_sequence_id
into l_bill_sequence_id
from bom_bill_of_materials
where organization_id= l_eam_wo_rec.organization_id
and assembly_item_id = l_eam_wo_rec.asset_activity_id
and (l_eam_wo_rec.alternate_bom_designator is null
or (l_eam_wo_rec.alternate_bom_designator is not null
and alternate_bom_designator = l_eam_wo_rec.alternate_bom_designator));
X_last_update_login => '',
X_program_application_id=> '',
X_program_id => '',
X_request_id => ''
);
X_last_update_login => '',
X_program_application_id=> '',
X_program_id => '',
X_request_id => ''
);
X_last_update_login => '',
X_program_application_id=> '',
X_program_id => '',
X_request_id => ''
);
X_last_update_login => '',
X_program_application_id=> '',
X_program_id => '',
X_request_id => ''
);