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_JOB_DTLS_SUBSTITUTIONS dependencies on WIP_JOB_DTLS_INTERFACE

Line 30: FROM WIP_JOB_DTLS_INTERFACE

26: start_date, completion_date,attribute_category, attribute1,
27: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
28: attribute8,attribute9,attribute10,attribute11,attribute12,
29: attribute13,attribute14,attribute15
30: FROM WIP_JOB_DTLS_INTERFACE
31: WHERE group_id = p_group_id
32: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
33: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
34: AND wip_entity_id = p_wip_entity_id

Line 107: FROM WIP_JOB_DTLS_INTERFACE

103: attribute13,attribute14,attribute15,schedule_seq_num,
104: substitute_group_num,replacement_group_num, firm_flag, setup_id,
105: group_sequence_id, group_sequence_number, maximum_assigned_units,
106: parent_seq_num, batch_id
107: FROM WIP_JOB_DTLS_INTERFACE
108: WHERE group_id = p_group_id
109: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
110: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
111: AND wip_entity_id = p_wip_entity_id

Line 375: FROM WIP_JOB_DTLS_INTERFACE

371: attribute13,attribute14,attribute15, schedule_seq_num,
372: substitute_group_num, replacement_group_num, firm_flag,setup_id,
373: group_sequence_id, group_sequence_number, maximum_assigned_units,
374: parent_seq_num, batch_id
375: FROM WIP_JOB_DTLS_INTERFACE
376: WHERE group_id = p_group_id
377: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
378: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
379: AND wip_entity_id = p_wip_entity_id

Line 397: FROM WIP_JOB_DTLS_INTERFACE

393: and wo.operation_seq_num = wor.operation_seq_num
394: and wor.wip_entity_id = p_wip_entity_id
395: and wor.organization_id = p_organization_id
396: and not exists ( select 1
397: FROM WIP_JOB_DTLS_INTERFACE
398: WHERE group_id = p_group_id
399: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
400: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
401: AND wip_entity_id = p_wip_entity_id

Line 722: FROM WIP_JOB_DTLS_INTERFACE

718: start_date, completion_date,attribute_category, attribute1,
719: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
720: attribute8,attribute9,attribute10,attribute11,attribute12,
721: attribute13,attribute14,attribute15
722: FROM WIP_JOB_DTLS_INTERFACE
723: WHERE group_id = p_group_id
724: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
725: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
726: AND wip_entity_id = p_wip_entity_id

Line 788: FROM WIP_JOB_DTLS_INTERFACE

784: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
785: attribute8,attribute9,attribute10,attribute11,attribute12,
786: attribute13,attribute14,attribute15,schedule_seq_num,
787: substitute_group_num,replacement_group_num
788: FROM WIP_JOB_DTLS_INTERFACE
789: WHERE group_id = p_group_id
790: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
791: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
792: AND wip_entity_id = p_wip_entity_id

Line 938: FROM WIP_JOB_DTLS_INTERFACE

934: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
935: attribute8,attribute9,attribute10,attribute11,attribute12,
936: attribute13,attribute14,attribute15, schedule_seq_num,
937: substitute_group_num, replacement_group_num
938: FROM WIP_JOB_DTLS_INTERFACE
939: WHERE group_id = p_group_id
940: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
941: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
942: AND wip_entity_id = p_wip_entity_id

Line 1039: FROM WIP_JOB_DTLS_INTERFACE

1035: p_organization_id number) IS
1036: SELECT distinct operation_seq_num, resource_seq_num, resource_serial_number,
1037: resource_instance_id, start_date, completion_date, batch_id, interface_id,
1038: created_by, creation_date,last_updated_by,last_update_date
1039: FROM WIP_JOB_DTLS_INTERFACE
1040: WHERE group_id = p_group_id
1041: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1042: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1043: AND wip_entity_id = p_wip_entity_id

Line 1113: FROM WIP_JOB_DTLS_INTERFACE

1109: p_organization_id number) IS
1110: SELECT distinct operation_seq_num, resource_seq_num, resource_serial_number,
1111: resource_instance_id, start_date, completion_date, batch_id,
1112: created_by, creation_date,last_updated_by,last_update_date
1113: FROM WIP_JOB_DTLS_INTERFACE
1114: WHERE group_id = p_group_id
1115: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1116: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1117: AND wip_entity_id = p_wip_entity_id

Line 1189: FROM WIP_JOB_DTLS_INTERFACE

1185: p_wip_entity_id number,
1186: p_organization_id number) IS
1187: SELECT distinct operation_seq_num, resource_seq_num, resource_serial_number,
1188: resource_instance_id, start_date, completion_date, batch_id
1189: FROM WIP_JOB_DTLS_INTERFACE
1190: WHERE group_id = p_group_id
1191: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1192: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1193: AND wip_entity_id = p_wip_entity_id

Line 1266: FROM WIP_JOB_DTLS_INTERFACE

1262: mps_date_required, attribute_category, attribute1,
1263: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
1264: attribute8,attribute9,attribute10,attribute11,attribute12,
1265: attribute13,attribute14,attribute15
1266: FROM WIP_JOB_DTLS_INTERFACE
1267: WHERE group_id = p_group_id
1268: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1269: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
1270: AND wip_entity_id = p_wip_entity_id

Line 1340: FROM WIP_JOB_DTLS_INTERFACE

1336: attribute_category, attribute1,
1337: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
1338: attribute8,attribute9,attribute10,attribute11,attribute12,
1339: attribute13,attribute14,attribute15
1340: FROM WIP_JOB_DTLS_INTERFACE
1341: WHERE group_id = p_group_id
1342: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1343: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1344: AND wip_entity_id = p_wip_entity_id

Line 1486: FROM WIP_JOB_DTLS_INTERFACE

1482: attribute_category, attribute1,
1483: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
1484: attribute8,attribute9,attribute10,attribute11,attribute12,
1485: attribute13,attribute14,attribute15
1486: FROM WIP_JOB_DTLS_INTERFACE
1487: WHERE group_id = p_group_id
1488: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1489: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1490: AND wip_entity_id = p_wip_entity_id

Line 1713: FROM WIP_JOB_DTLS_INTERFACE

1709: attribute_category, attribute1, attribute2, attribute3,
1710: attribute4, attribute5,
1711: attribute6, attribute7, attribute8, attribute9, attribute10,
1712: attribute11, attribute12, attribute13, attribute14, attribute15
1713: FROM WIP_JOB_DTLS_INTERFACE
1714: WHERE group_id = p_group_id
1715: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1716: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1717: AND wip_entity_id = p_wip_entity_id

Line 1834: update wip_job_dtls_interface wjdi

1830: IF l_op_exists = 1 THEN
1831: fnd_message.set_name('WIP','WIP_ADD_OP_INVALID');
1832: wip_jsi_utils.record_current_error(FALSE);
1833:
1834: update wip_job_dtls_interface wjdi
1835: set process_status = wip_constants.error
1836: where group_id = p_group_id
1837: and process_phase = wip_constants.ml_validation
1838: and process_status in (wip_constants.running,

Line 1876: update wip_job_dtls_interface wjdi

1872:
1873: IF l_txn_exists = 1 THEN
1874: fnd_message.set_name('WIP','WIP_ADD_OP_INVALID');
1875: wip_jsi_utils.record_current_error(FALSE);
1876: update wip_job_dtls_interface wjdi
1877: set process_status = wip_constants.error
1878: where group_id = p_group_id
1879: and process_phase = wip_constants.ml_validation
1880: and process_status in (wip_constants.running,

Line 2235: FROM WIP_JOB_DTLS_INTERFACE WJDI, WIP_OPERATIONS WO

2231: WJDI.attribute4, WJDI.attribute5,
2232: WJDI.attribute6, WJDI.attribute7, WJDI.attribute8, WJDI.attribute9, WJDI.attribute10,
2233: WJDI.attribute11, WJDI.attribute12, WJDI.attribute13, WJDI.attribute14, WJDI.attribute15,
2234: WO.standard_operation_id curr_standard_operation_id
2235: FROM WIP_JOB_DTLS_INTERFACE WJDI, WIP_OPERATIONS WO
2236: WHERE group_id = p_group_id
2237: AND WJDI.process_phase = WIP_CONSTANTS.ML_VALIDATION
2238: AND WJDI.process_status IN (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2239: AND WJDI.wip_entity_id = p_wip_entity_id

Line 2420: from wip_job_dtls_interface wjdi

2416: * This is done as per Planning request
2417: */
2418: cursor c_invalid_rows is
2419: select wjdi.interface_id
2420: from wip_job_dtls_interface wjdi
2421: where wjdi.group_id = p_group_id
2422: and wjdi.process_phase = wip_constants.ml_validation
2423: and wjdi.process_status in (wip_constants.running,
2424: wip_constants.warning)

Line 2478: update wip_job_dtls_interface wjdi

2474: end if;
2475: end loop;
2476:
2477: if(l_error_exists) then
2478: update wip_job_dtls_interface wjdi
2479: set process_status = wip_constants.error
2480: where wjdi.group_id = p_group_id
2481: and wjdi.process_phase = wip_constants.ml_validation
2482: and wjdi.process_status in (wip_constants.running,

Line 2556: FROM WIP_JOB_DTLS_INTERFACE

2552: Cursor Usage_info (p_group_id number,
2553: p_wip_entity_id number,
2554: p_organization_id number) IS
2555: SELECT operation_seq_num, resource_seq_num
2556: FROM WIP_JOB_DTLS_INTERFACE
2557: WHERE group_id = p_group_id
2558: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2559: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
2560: AND wip_entity_id = p_wip_entity_id

Line 2597: FROM WIP_JOB_DTLS_INTERFACE

2593: completion_date, assigned_units, resource_serial_number,
2594: last_update_date, last_updated_by, creation_date, created_by,
2595: last_update_login, program_application_id, request_id, program_id,
2596: program_update_date, substitution_type
2597: FROM WIP_JOB_DTLS_INTERFACE
2598: WHERE group_id = p_group_id
2599: AND wip_entity_id = p_wip_entity_id
2600: AND organization_id = p_organization_id
2601: AND operation_seq_num = p_operation_seq_num

Line 2714: from wip_job_dtls_interface

2710:
2711: BEGIN
2712:
2713: select count(*) into x_count
2714: from wip_job_dtls_interface
2715: where group_id = p_group_id /* Fix for bug#3636378 */
2716: and wip_entity_id = p_wip_entity_id
2717: and organization_id = p_organization_id
2718: and operation_seq_num = p_operation_seq_num

Line 2803: FROM WIP_JOB_DTLS_INTERFACE

2799: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
2800: attribute8,attribute9,attribute10,attribute11,attribute12,
2801: attribute13,attribute14,attribute15,schedule_seq_num,
2802: substitute_group_num,replacement_group_num,batch_id
2803: FROM WIP_JOB_DTLS_INTERFACE
2804: WHERE group_id = p_group_id
2805: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2806: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2807: AND wip_entity_id = p_wip_entity_id

Line 2902: FROM WIP_JOB_DTLS_INTERFACE

2898: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
2899: attribute8,attribute9,attribute10,attribute11,attribute12,
2900: attribute13,attribute14,attribute15,schedule_seq_num,
2901: substitute_group_num,replacement_group_num,batch_id
2902: FROM WIP_JOB_DTLS_INTERFACE
2903: WHERE group_id = p_group_id
2904: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2905: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2906: AND wip_entity_id = p_wip_entity_id

Line 2947: FROM wip_job_dtls_interface wjdi,

2943: p_organization_id number) IS
2944: SELECT wjdi.serial_number_new serial_number,
2945: nvl(we.primary_item_id, wjsi.primary_item_id) primary_item_id,
2946: nvl(we.organization_id, wjsi.organization_id) organization_id
2947: FROM wip_job_dtls_interface wjdi,
2948: wip_job_schedule_interface wjsi,
2949: wip_entities we
2950: WHERE wjdi.group_id = p_group_id
2951: AND wjsi.group_id = p_group_id

Line 3008: FROM wip_job_dtls_interface wjdi,

3004: SELECT wjdi.serial_number_new,
3005: wjdi.serial_number_old,
3006: nvl(we.primary_item_id, wjsi.primary_item_id) primary_item_id,
3007: nvl(we.organization_id, wjsi.organization_id) organization_id
3008: FROM wip_job_dtls_interface wjdi,
3009: wip_job_schedule_interface wjsi,
3010: wip_entities we
3011: WHERE wjdi.group_id = p_group_id
3012: AND wjsi.group_id = p_group_id

Line 3081: FROM wip_job_dtls_interface wjdi,

3077: p_organization_id number) IS
3078: SELECT wjdi.serial_number_old serial_number,
3079: nvl(we.primary_item_id, wjsi.primary_item_id) primary_item_id,
3080: nvl(we.organization_id, wjsi.organization_id) organization_id
3081: FROM wip_job_dtls_interface wjdi,
3082: wip_job_schedule_interface wjsi,
3083: wip_entities we
3084: WHERE wjdi.group_id = p_group_id
3085: AND wjsi.group_id = p_group_id