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 396: FROM WIP_JOB_DTLS_INTERFACE

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

Line 723: FROM WIP_JOB_DTLS_INTERFACE

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

Line 789: FROM WIP_JOB_DTLS_INTERFACE

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

Line 939: FROM WIP_JOB_DTLS_INTERFACE

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

Line 1038: FROM WIP_JOB_DTLS_INTERFACE

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

Line 1112: FROM WIP_JOB_DTLS_INTERFACE

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

Line 1186: FROM WIP_JOB_DTLS_INTERFACE

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

Line 1263: FROM WIP_JOB_DTLS_INTERFACE

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

Line 1337: FROM WIP_JOB_DTLS_INTERFACE

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

Line 1483: FROM WIP_JOB_DTLS_INTERFACE

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

Line 1692: FROM WIP_JOB_DTLS_INTERFACE

1688: attribute_category, attribute1, attribute2, attribute3,
1689: attribute4, attribute5,
1690: attribute6, attribute7, attribute8, attribute9, attribute10,
1691: attribute11, attribute12, attribute13, attribute14, attribute15
1692: FROM WIP_JOB_DTLS_INTERFACE
1693: WHERE group_id = p_group_id
1694: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1695: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1696: AND wip_entity_id = p_wip_entity_id

Line 2112: FROM WIP_JOB_DTLS_INTERFACE WJDI, WIP_OPERATIONS WO

2108: WJDI.attribute4, WJDI.attribute5,
2109: WJDI.attribute6, WJDI.attribute7, WJDI.attribute8, WJDI.attribute9, WJDI.attribute10,
2110: WJDI.attribute11, WJDI.attribute12, WJDI.attribute13, WJDI.attribute14, WJDI.attribute15,
2111: WO.standard_operation_id curr_standard_operation_id
2112: FROM WIP_JOB_DTLS_INTERFACE WJDI, WIP_OPERATIONS WO
2113: WHERE group_id = p_group_id
2114: AND WJDI.process_phase = WIP_CONSTANTS.ML_VALIDATION
2115: AND WJDI.process_status IN (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2116: AND WJDI.wip_entity_id = p_wip_entity_id

Line 2295: from wip_job_dtls_interface wjdi

2291: * This is done as per Planning request
2292: */
2293: cursor c_invalid_rows is
2294: select wjdi.interface_id
2295: from wip_job_dtls_interface wjdi
2296: where wjdi.group_id = p_group_id
2297: and wjdi.process_phase = wip_constants.ml_validation
2298: and wjdi.process_status in (wip_constants.running,
2299: wip_constants.warning)

Line 2352: update wip_job_dtls_interface wjdi

2348: end if;
2349: end loop;
2350:
2351: if(l_error_exists) then
2352: update wip_job_dtls_interface wjdi
2353: set process_status = wip_constants.error
2354: where wjdi.group_id = p_group_id
2355: and wjdi.process_phase = wip_constants.ml_validation
2356: and wjdi.process_status in (wip_constants.running,

Line 2430: FROM WIP_JOB_DTLS_INTERFACE

2426: Cursor Usage_info (p_group_id number,
2427: p_wip_entity_id number,
2428: p_organization_id number) IS
2429: SELECT operation_seq_num, resource_seq_num
2430: FROM WIP_JOB_DTLS_INTERFACE
2431: WHERE group_id = p_group_id
2432: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2433: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
2434: AND wip_entity_id = p_wip_entity_id

Line 2471: FROM WIP_JOB_DTLS_INTERFACE

2467: completion_date, assigned_units, resource_serial_number,
2468: last_update_date, last_updated_by, creation_date, created_by,
2469: last_update_login, program_application_id, request_id, program_id,
2470: program_update_date, substitution_type
2471: FROM WIP_JOB_DTLS_INTERFACE
2472: WHERE group_id = p_group_id
2473: AND wip_entity_id = p_wip_entity_id
2474: AND organization_id = p_organization_id
2475: AND operation_seq_num = p_operation_seq_num

Line 2588: from wip_job_dtls_interface

2584:
2585: BEGIN
2586:
2587: select count(*) into x_count
2588: from wip_job_dtls_interface
2589: where group_id = p_group_id /* Fix for bug#3636378 */
2590: and wip_entity_id = p_wip_entity_id
2591: and organization_id = p_organization_id
2592: and operation_seq_num = p_operation_seq_num

Line 2677: FROM WIP_JOB_DTLS_INTERFACE

2673: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
2674: attribute8,attribute9,attribute10,attribute11,attribute12,
2675: attribute13,attribute14,attribute15,schedule_seq_num,
2676: substitute_group_num,replacement_group_num,batch_id
2677: FROM WIP_JOB_DTLS_INTERFACE
2678: WHERE group_id = p_group_id
2679: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2680: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2681: AND wip_entity_id = p_wip_entity_id

Line 2776: FROM WIP_JOB_DTLS_INTERFACE

2772: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
2773: attribute8,attribute9,attribute10,attribute11,attribute12,
2774: attribute13,attribute14,attribute15,schedule_seq_num,
2775: substitute_group_num,replacement_group_num,batch_id
2776: FROM WIP_JOB_DTLS_INTERFACE
2777: WHERE group_id = p_group_id
2778: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2779: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2780: AND wip_entity_id = p_wip_entity_id

Line 2821: FROM wip_job_dtls_interface wjdi,

2817: p_organization_id number) IS
2818: SELECT wjdi.serial_number_new serial_number,
2819: nvl(we.primary_item_id, wjsi.primary_item_id) primary_item_id,
2820: nvl(we.organization_id, wjsi.organization_id) organization_id
2821: FROM wip_job_dtls_interface wjdi,
2822: wip_job_schedule_interface wjsi,
2823: wip_entities we
2824: WHERE wjdi.group_id = p_group_id
2825: AND wjsi.group_id = p_group_id

Line 2882: FROM wip_job_dtls_interface wjdi,

2878: SELECT wjdi.serial_number_new,
2879: wjdi.serial_number_old,
2880: nvl(we.primary_item_id, wjsi.primary_item_id) primary_item_id,
2881: nvl(we.organization_id, wjsi.organization_id) organization_id
2882: FROM wip_job_dtls_interface wjdi,
2883: wip_job_schedule_interface wjsi,
2884: wip_entities we
2885: WHERE wjdi.group_id = p_group_id
2886: AND wjsi.group_id = p_group_id

Line 2955: FROM wip_job_dtls_interface wjdi,

2951: p_organization_id number) IS
2952: SELECT wjdi.serial_number_old serial_number,
2953: nvl(we.primary_item_id, wjsi.primary_item_id) primary_item_id,
2954: nvl(we.organization_id, wjsi.organization_id) organization_id
2955: FROM wip_job_dtls_interface wjdi,
2956: wip_job_schedule_interface wjsi,
2957: wip_entities we
2958: WHERE wjdi.group_id = p_group_id
2959: AND wjsi.group_id = p_group_id