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.WIP_MTI_PUB dependencies on WIP_OPERATIONS

Line 950: from wip_operations wo

946: program_id = fnd_global.conc_program_id,
947: program_update_date = sysdate,
948: request_id = fnd_global.conc_request_id,
949: operation_seq_num = (select max(operation_seq_num)
950: from wip_operations wo
951: where wo.organization_id = mti.organization_id
952: and wo.wip_entity_id = mti.transaction_source_id
953: and ( mti.wip_entity_type in (1,5)
954: or ( mti.wip_entity_type = 2

Line 973: from wip_operations wo

969: program_id = fnd_global.conc_program_id,
970: program_update_date = sysdate,
971: request_id = fnd_global.conc_request_id,
972: operation_seq_num = (select nvl(max(operation_seq_num), 1)
973: from wip_operations wo
974: where wo.organization_id = mti.organization_id
975: and wo.wip_entity_id = mti.transaction_source_id
976: and ( mti.wip_entity_type in (1,5,6)
977: or ( mti.wip_entity_type = 2

Line 1023: from wip_operations wo

1019: 0)),
1020: 0,
1021: 0,
1022: 1))
1023: from wip_operations wo
1024: where wo.wip_entity_id = mti.transaction_source_id
1025: and wo.organization_id = mti.organization_id
1026: and ( mti.wip_entity_type in (1, 5, 6)
1027: or ( mti.wip_entity_type = 2

Line 1431: from wip_operations wo

1427: and wip_entity_type <> 4
1428: and operation_seq_num is not null
1429: and (primary_quantity - nvl(overcompletion_primary_qty, 0)) >
1430: (select sum(quantity_waiting_to_move)
1431: from wip_operations wo
1432: where wo.wip_entity_id = mti.transaction_source_id
1433: and wo.organization_id = mti.organization_id
1434: and wo.operation_seq_num = mti.operation_seq_num
1435: and ( mti.wip_entity_type in (1,5)