eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_EXPLODE_ACTIVITY_PVT dependencies on BOM_OPERATION_SEQUENCES

Line 150: FROM BOM_OPERATION_SEQUENCES BOS

146: -- one of the entities requires common_routing_sequence_id as a primary key.Hence being added to the query.
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

Line 219: , BOM_OPERATION_SEQUENCES BOS

215: , null RETURN_STATUS
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

Line 268: , BOM_OPERATION_SEQUENCES BOS_FROM

264: , BON.ATTRIBUTE15 ATTRIBUTE15
265: , null RETURN_STATUS
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

Line 269: , BOM_OPERATION_SEQUENCES BOS_TO

265: , null RETURN_STATUS
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

Line 296: , BOM_OPERATION_SEQUENCES BOS_FROM

292: -- one such operation, then don't create any networks.
293: AND NOT EXISTS (
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

Line 297: , BOM_OPERATION_SEQUENCES BOS_TO

293: AND NOT EXISTS (
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

Line 449: , BOM_OPERATION_SEQUENCES BOS

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
453: AND BE.COMPONENT_ITEM_ID = MSI.INVENTORY_ITEM_ID

Line 982: X_from_entity_name => 'BOM_OPERATION_SEQUENCES',

978:
979: -- Copy the attachment for each of the operations
980: IF p_operation_sequence_id IS NOT NULL THEN
981: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS(
982: X_from_entity_name => 'BOM_OPERATION_SEQUENCES',
983: X_from_pk1_value => p_operation_sequence_id,
984: X_from_pk2_value => '',
985: X_from_pk3_value => '',
986: X_from_pk4_value => '',