DBA Data[Home] [Help]

APPS.EAM_EXPLODE_ACTIVITY_PVT dependencies on BOM_OPERATIONAL_ROUTINGS

Line 151: , BOM_OPERATIONAL_ROUTINGS BORT

147: , BORT.COMMON_ROUTING_SEQUENCE_ID COMMON_ROUTING_SEQUENCE_ID
148: , BOS.X_COORDINATE
149: , BOS.Y_COORDINATE
150: FROM BOM_OPERATION_SEQUENCES BOS
151: , BOM_OPERATIONAL_ROUTINGS BORT
152: WHERE BORT.assembly_item_id = p_eam_wo_rec.asset_activity_id
153: AND BORT.organization_id = p_eam_wo_rec.organization_id
154: AND BOS.ROUTING_SEQUENCE_ID = BORT.COMMON_ROUTING_SEQUENCE_ID -- agaurav- Changed ROUTING_SEQUENCE_ID to COMMON_ROUTING_SEQUENCE_ID
155: AND NVL(BOS.OPERATION_TYPE, 1) = 1

Line 220: , BOM_OPERATIONAL_ROUTINGS BORT

216: , 1 TRANSACTION_TYPE
217: FROM BOM_RESOURCES BR
218: , BOM_OPERATION_RESOURCES BOR
219: , BOM_OPERATION_SEQUENCES BOS
220: , BOM_OPERATIONAL_ROUTINGS BORT
221: WHERE BORT.assembly_item_id = p_eam_wo_rec.asset_activity_id
222: AND BORT.organization_id = p_eam_wo_rec.organization_id
223: AND BOS.ROUTING_SEQUENCE_ID = BORT.COMMON_ROUTING_SEQUENCE_ID -- agaurav- Changed ROUTING_SEQUENCE_ID to COMMON_ROUTING_SEQUENCE_ID
224: AND BOS.OPERATION_SEQUENCE_ID = BOR.OPERATION_SEQUENCE_ID

Line 270: , BOM_OPERATIONAL_ROUTINGS BORT

266: , 1 TRANSACTION_TYPE
267: FROM BOM_OPERATION_NETWORKS BON
268: , BOM_OPERATION_SEQUENCES BOS_FROM
269: , BOM_OPERATION_SEQUENCES BOS_TO
270: , BOM_OPERATIONAL_ROUTINGS BORT
271: WHERE BORT.assembly_item_id = p_eam_wo_rec.asset_activity_id
272: AND BORT.organization_id = p_eam_wo_rec.organization_id
273: AND BOS_FROM.ROUTING_SEQUENCE_ID = BORT.COMMON_ROUTING_SEQUENCE_ID -- agaurav- Changed ROUTING_SEQUENCE_ID to COMMON_ROUTING_SEQUENCE_ID
274: AND BOS_TO.ROUTING_SEQUENCE_ID = BORT.COMMON_ROUTING_SEQUENCE_ID -- agaurav- Changed ROUTING_SEQUENCE_ID to COMMON_ROUTING_SEQUENCE_ID

Line 298: , BOM_OPERATIONAL_ROUTINGS BORT

294: select 1
295: FROM BOM_OPERATION_NETWORKS BON
296: , BOM_OPERATION_SEQUENCES BOS_FROM
297: , BOM_OPERATION_SEQUENCES BOS_TO
298: , BOM_OPERATIONAL_ROUTINGS BORT
299: WHERE BORT.assembly_item_id = p_eam_wo_rec.asset_activity_id
300: AND BORT.organization_id = p_eam_wo_rec.organization_id
301: AND BOS_FROM.ROUTING_SEQUENCE_ID = BORT.COMMON_ROUTING_SEQUENCE_ID
302: -- agaurav- Changed ROUTING_SEQUENCE_ID to COMMON_ROUTING_SEQUENCE_ID

Line 448: , BOM_OPERATIONAL_ROUTINGS BORT

444: , null RETURN_STATUS
445: , 1 TRANSACTION_TYPE
446: FROM BOM_EXPLOSION_TEMP BE
447: , BOM_INVENTORY_COMPONENTS BIC
448: , BOM_OPERATIONAL_ROUTINGS BORT
449: , BOM_OPERATION_SEQUENCES BOS
450: , MTL_SYSTEM_ITEMS MSI
451: WHERE BE.GROUP_ID = v_grpID
452: AND BE.COMPONENT_SEQUENCE_ID = BIC.COMPONENT_SEQUENCE_ID

Line 959: X_from_entity_name => 'BOM_OPERATIONAL_ROUTINGS',

955: --Bug#3342391: Adding the code to copy the attachment from the routing header and each of the operations under it.
956: IF (p_common_routing_sequence_id) IS NOT NULL THEN
957: -- Copy the attachment from the routing header.
958: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS(
959: X_from_entity_name => 'BOM_OPERATIONAL_ROUTINGS',
960: X_from_pk1_value => p_common_routing_sequence_id,
961: X_from_pk2_value => '',
962: X_from_pk3_value => '',
963: X_from_pk4_value => '',