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_MOVE_VALIDATOR dependencies on WIP_OPERATIONS

Line 410: FROM wip_operations wo

406: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
407: AND wmti.process_status = WIP_CONSTANTS.RUNNING
408: AND NOT EXISTS
409: (SELECT 'X'
410: FROM wip_operations wo
411: WHERE wo.wip_entity_id = wmti.wip_entity_id
412: AND wo.organization_id = wmti.organization_id
413: AND NVL(wo.repetitive_schedule_id, -1) =
414: NVL(wmti.repetitive_schedule_id, -1))

Line 856: FROM wip_operations wo

852: -- EZ Return and FM_OPERATION_SEQ_NUM is null
853: UPDATE wip_move_txn_interface wmti
854: SET wmti.fm_operation_seq_num =
855: (SELECT wo.operation_seq_num
856: FROM wip_operations wo
857: WHERE wo.wip_entity_id = wmti.wip_entity_id
858: AND wo.organization_id = wmti.organization_id
859: AND NVL(wo.repetitive_schedule_id, -1) =
860: NVL(wmti.repetitive_schedule_id, -1)

Line 881: FROM wip_operations wo

877: AND (wmti.fm_operation_seq_num IS NULL
878: OR
879: (NOT EXISTS
880: (SELECT 'X'
881: FROM wip_operations wo
882: WHERE wo.wip_entity_id = wmti.wip_entity_id
883: AND wo.organization_id = wmti.organization_id
884: AND wo.operation_seq_num = wmti.fm_operation_seq_num
885: AND NVL(wo.repetitive_schedule_id, -1) =

Line 906: FROM wip_operations wo

902: AND wmti.process_status = WIP_CONSTANTS.RUNNING
903: AND wmti.transaction_type = WIP_CONSTANTS.RET_TXN
904: AND wmti.fm_operation_seq_num <>
905: (SELECT wo.operation_seq_num
906: FROM wip_operations wo
907: WHERE wo.wip_entity_id = wmti.wip_entity_id
908: AND wo.organization_id = wmti.organization_id
909: AND NVL(wo.repetitive_schedule_id, -1) =
910: NVL(wmti.repetitive_schedule_id, -1)

Line 951: wip_operations wo

947: OR
948: (NOT EXISTS
949: (SELECT 'X'
950: FROM wip_valid_intraoperation_steps wvis,
951: wip_operations wo
952: WHERE wvis.organization_id = wmti.organization_id
953: AND wvis.step_lookup_type = wmti.fm_intraoperation_step_type
954: AND wo.organization_id = wmti.organization_id
955: AND wo.wip_entity_id = wmti.wip_entity_id

Line 1023: FROM wip_operations wo

1019: AND wmti.transaction_type = WIP_CONSTANTS.COMP_TXN
1020: AND wmti.fm_intraoperation_step_type = WIP_CONSTANTS.TOMOVE
1021: AND wmti.fm_operation_seq_num =
1022: (SELECT wo.operation_seq_num
1023: FROM wip_operations wo
1024: WHERE wo.wip_entity_id = wmti.wip_entity_id
1025: AND wo.organization_id = wmti.organization_id
1026: AND NVL(wo.repetitive_schedule_id, -1) =
1027: NVL(wmti.repetitive_schedule_id, -1)

Line 1067: FROM wip_operations wo

1063: -- EZ Completion and TO_OPERATION_SEQ_NUM is null
1064: UPDATE wip_move_txn_interface wmti
1065: SET wmti.to_operation_seq_num =
1066: (SELECT wo.operation_seq_num
1067: FROM wip_operations wo
1068: WHERE wo.wip_entity_id = wmti.wip_entity_id
1069: AND wo.organization_id = wmti.organization_id
1070: AND NVL(wo.repetitive_schedule_id, -1) =
1071: NVL(wmti.repetitive_schedule_id, -1)

Line 1084: FROM wip_operations wo

1080: next count point operation */
1081: UPDATE wip_move_txn_interface wmti
1082: SET wmti.to_operation_seq_num =
1083: (SELECT MIN(wo.operation_seq_num)
1084: FROM wip_operations wo
1085: WHERE wo.organization_id = wmti.organization_id
1086: AND wo.wip_entity_id = wmti.wip_entity_id
1087: AND NVL(wo.repetitive_schedule_id, -1) =
1088: NVL(wmti.repetitive_schedule_id, -1)

Line 1110: FROM wip_operations wo

1106: AND (wmti.to_operation_seq_num IS NULL
1107: OR
1108: (NOT EXISTS
1109: (SELECT 'X'
1110: FROM wip_operations wo
1111: WHERE wo.wip_entity_id = wmti.wip_entity_id
1112: AND wo.organization_id = wmti.organization_id
1113: AND wo.operation_seq_num = wmti.to_operation_seq_num
1114: AND NVL(wo.repetitive_schedule_id, -1) =

Line 1135: FROM wip_operations wo

1131: AND wmti.process_status = WIP_CONSTANTS.RUNNING
1132: AND wmti.transaction_type = WIP_CONSTANTS.COMP_TXN
1133: AND wmti.to_operation_seq_num <>
1134: (SELECT wo.operation_seq_num
1135: FROM wip_operations wo
1136: WHERE wo.wip_entity_id = wmti.wip_entity_id
1137: AND wo.organization_id = wmti.organization_id
1138: AND NVL(wo.repetitive_schedule_id, -1) =
1139: NVL(wmti.repetitive_schedule_id, -1)

Line 1184: wip_operations wo

1180: OR
1181: (NOT EXISTS
1182: (SELECT 'X'
1183: FROM wip_valid_intraoperation_steps wvis,
1184: wip_operations wo
1185: WHERE wvis.organization_id = wmti.organization_id
1186: AND wvis.step_lookup_type = wmti.to_intraoperation_step_type
1187: AND wo.organization_id = wmti.organization_id
1188: AND wo.wip_entity_id = wmti.wip_entity_id

Line 1800: wip_operations wo

1796: wmti.program_application_id,
1797: wmti.program_id,
1798: wmti.program_update_date
1799: FROM wip_move_txn_interface wmti,
1800: wip_operations wo
1801: WHERE wo.organization_id = wmti.organization_id
1802: AND wo.wip_entity_id = wmti.wip_entity_id
1803: AND NVL(wo.repetitive_schedule_id, -1) =
1804: NVL(wmti.repetitive_schedule_id, -1)

Line 2469: wip_operations wo1,

2465: AND EXISTS
2466: (SELECT 'X'
2467: FROM bom_departments bd,
2468: wip_operation_resources wor,
2469: wip_operations wo1,
2470: wip_operations wo2
2471: WHERE wor.organization_id = wmti.organization_id
2472: AND wor.wip_entity_id = wmti.wip_entity_id
2473: AND wor.operation_seq_num = wmti.to_operation_seq_num

Line 2470: wip_operations wo2

2466: (SELECT 'X'
2467: FROM bom_departments bd,
2468: wip_operation_resources wor,
2469: wip_operations wo1,
2470: wip_operations wo2
2471: WHERE wor.organization_id = wmti.organization_id
2472: AND wor.wip_entity_id = wmti.wip_entity_id
2473: AND wor.operation_seq_num = wmti.to_operation_seq_num
2474: AND wmti.fm_operation_seq_num < wmti.to_operation_seq_num

Line 2874: wip_operations wo1,

2870: FROM bom_standard_operations bso1,
2871: bom_standard_operations bso2,
2872: bom_departments bd1,
2873: bom_departments bd2,
2874: wip_operations wo1,
2875: wip_operations wo2
2876: WHERE wo1.organization_id = wmti.organization_id
2877: AND wo1.wip_entity_id = wmti.wip_entity_id
2878: AND wo1.operation_seq_num = wmti.fm_operation_seq_num

Line 2875: wip_operations wo2

2871: bom_standard_operations bso2,
2872: bom_departments bd1,
2873: bom_departments bd2,
2874: wip_operations wo1,
2875: wip_operations wo2
2876: WHERE wo1.organization_id = wmti.organization_id
2877: AND wo1.wip_entity_id = wmti.wip_entity_id
2878: AND wo1.operation_seq_num = wmti.fm_operation_seq_num
2879: AND wo2.organization_id = wmti.organization_id