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 952: wip_operations wo

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

Line 1047: FROM wip_operations wo

1043: AND wmti.transaction_type = WIP_CONSTANTS.COMP_TXN
1044: AND wmti.fm_intraoperation_step_type = WIP_CONSTANTS.TOMOVE
1045: AND wmti.fm_operation_seq_num =
1046: (SELECT wo.operation_seq_num
1047: FROM wip_operations wo
1048: WHERE wo.wip_entity_id = wmti.wip_entity_id
1049: AND wo.organization_id = wmti.organization_id
1050: AND NVL(wo.repetitive_schedule_id, -1) =
1051: NVL(wmti.repetitive_schedule_id, -1)

Line 1091: FROM wip_operations wo

1087: -- EZ Completion and TO_OPERATION_SEQ_NUM is null
1088: UPDATE wip_move_txn_interface wmti
1089: SET wmti.to_operation_seq_num =
1090: (SELECT wo.operation_seq_num
1091: FROM wip_operations wo
1092: WHERE wo.wip_entity_id = wmti.wip_entity_id
1093: AND wo.organization_id = wmti.organization_id
1094: AND NVL(wo.repetitive_schedule_id, -1) =
1095: NVL(wmti.repetitive_schedule_id, -1)

Line 1108: FROM wip_operations wo

1104: next count point operation */
1105: UPDATE wip_move_txn_interface wmti
1106: SET wmti.to_operation_seq_num =
1107: (SELECT MIN(wo.operation_seq_num)
1108: FROM wip_operations wo
1109: WHERE wo.organization_id = wmti.organization_id
1110: AND wo.wip_entity_id = wmti.wip_entity_id
1111: AND NVL(wo.repetitive_schedule_id, -1) =
1112: NVL(wmti.repetitive_schedule_id, -1)

Line 1134: FROM wip_operations wo

1130: AND (wmti.to_operation_seq_num IS NULL
1131: OR
1132: (NOT EXISTS
1133: (SELECT 'X'
1134: FROM wip_operations wo
1135: WHERE wo.wip_entity_id = wmti.wip_entity_id
1136: AND wo.organization_id = wmti.organization_id
1137: AND wo.operation_seq_num = wmti.to_operation_seq_num
1138: AND NVL(wo.repetitive_schedule_id, -1) =

Line 1159: FROM wip_operations wo

1155: AND wmti.process_status = WIP_CONSTANTS.RUNNING
1156: AND wmti.transaction_type = WIP_CONSTANTS.COMP_TXN
1157: AND wmti.to_operation_seq_num <>
1158: (SELECT wo.operation_seq_num
1159: FROM wip_operations wo
1160: WHERE wo.wip_entity_id = wmti.wip_entity_id
1161: AND wo.organization_id = wmti.organization_id
1162: AND NVL(wo.repetitive_schedule_id, -1) =
1163: NVL(wmti.repetitive_schedule_id, -1)

Line 1209: wip_operations wo

1205: OR
1206: (NOT EXISTS
1207: (SELECT 'X'
1208: FROM wip_valid_intraoperation_steps wvis,
1209: wip_operations wo
1210: WHERE wvis.organization_id = wmti.organization_id
1211: AND wvis.step_lookup_type = wmti.to_intraoperation_step_type
1212: AND wo.organization_id = wmti.organization_id
1213: AND wo.wip_entity_id = wmti.wip_entity_id

Line 1868: wip_operations wo

1864: wmti.program_application_id,
1865: wmti.program_id,
1866: wmti.program_update_date
1867: FROM wip_move_txn_interface wmti,
1868: wip_operations wo
1869: WHERE wo.organization_id = wmti.organization_id
1870: AND wo.wip_entity_id = wmti.wip_entity_id
1871: AND NVL(wo.repetitive_schedule_id, -1) =
1872: NVL(wmti.repetitive_schedule_id, -1)

Line 2537: wip_operations wo1,

2533: AND EXISTS
2534: (SELECT 'X'
2535: FROM bom_departments bd,
2536: wip_operation_resources wor,
2537: wip_operations wo1,
2538: wip_operations wo2
2539: WHERE wor.organization_id = wmti.organization_id
2540: AND wor.wip_entity_id = wmti.wip_entity_id
2541: AND wor.operation_seq_num = wmti.to_operation_seq_num

Line 2538: wip_operations wo2

2534: (SELECT 'X'
2535: FROM bom_departments bd,
2536: wip_operation_resources wor,
2537: wip_operations wo1,
2538: wip_operations wo2
2539: WHERE wor.organization_id = wmti.organization_id
2540: AND wor.wip_entity_id = wmti.wip_entity_id
2541: AND wor.operation_seq_num = wmti.to_operation_seq_num
2542: AND wmti.fm_operation_seq_num < wmti.to_operation_seq_num

Line 2942: wip_operations wo1,

2938: FROM bom_standard_operations bso1,
2939: bom_standard_operations bso2,
2940: bom_departments bd1,
2941: bom_departments bd2,
2942: wip_operations wo1,
2943: wip_operations wo2
2944: WHERE wo1.organization_id = wmti.organization_id
2945: AND wo1.wip_entity_id = wmti.wip_entity_id
2946: AND wo1.operation_seq_num = wmti.fm_operation_seq_num

Line 2943: wip_operations wo2

2939: bom_standard_operations bso2,
2940: bom_departments bd1,
2941: bom_departments bd2,
2942: wip_operations wo1,
2943: wip_operations wo2
2944: WHERE wo1.organization_id = wmti.organization_id
2945: AND wo1.wip_entity_id = wmti.wip_entity_id
2946: AND wo1.operation_seq_num = wmti.fm_operation_seq_num
2947: AND wo2.organization_id = wmti.organization_id