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 STANDARD

Line 25: activity_id, autocharge_type, standard_rate_flag,

21: last_update_login, request_id, program_application_id,
22: program_id, program_update_date,
23: scheduled_flag, assigned_units, applied_resource_units,
24: applied_resource_value, uom_code, basis_type,
25: activity_id, autocharge_type, standard_rate_flag,
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

Line 99: activity_id, autocharge_type, standard_rate_flag,

95: last_update_login, request_id, program_application_id,
96: program_id, program_update_date,
97: scheduled_flag, assigned_units, applied_resource_units,
98: applied_resource_value, uom_code, basis_type,
99: activity_id, autocharge_type, standard_rate_flag,
100: start_date, completion_date,attribute_category, attribute1,
101: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
102: attribute8,attribute9,attribute10,attribute11,attribute12,
103: attribute13,attribute14,attribute15,schedule_seq_num,

Line 172: standard_rate_flag,

168: uom_code,
169: basis_type,
170: activity_id,
171: autocharge_type,
172: standard_rate_flag,
173: start_date,
174: completion_date,
175: attribute_category,
176: attribute1,

Line 225: cur_row.standard_rate_flag,

221: cur_row.uom_code,
222: cur_row.basis_type,
223: cur_row.activity_id,
224: cur_row.autocharge_type,
225: cur_row.standard_rate_flag,
226: cur_row.start_date,
227: cur_row.completion_date,
228: cur_row.attribute_category,
229: cur_row.attribute1,

Line 367: activity_id, autocharge_type, standard_rate_flag,

363: last_update_login, request_id, program_application_id,
364: program_id, program_update_date,
365: scheduled_flag, assigned_units, applied_resource_units,
366: applied_resource_value, uom_code, basis_type,
367: activity_id, autocharge_type, standard_rate_flag,
368: start_date, completion_date,attribute_category, attribute1,
369: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
370: attribute8,attribute9,attribute10,attribute11,attribute12,
371: attribute13,attribute14,attribute15, schedule_seq_num,

Line 521: standard_rate_flag = nvl(cur_row.standard_rate_flag, standard_rate_flag),

517: uom_code = nvl(cur_row.uom_code, uom_code),
518: basis_type = nvl(cur_row.basis_type, basis_type),
519: activity_id = nvl(cur_row.activity_id, activity_id),
520: autocharge_type = nvl(cur_row.autocharge_type, autocharge_type),
521: standard_rate_flag = nvl(cur_row.standard_rate_flag, standard_rate_flag),
522: start_date = nvl(cur_row.start_date, start_date),
523: completion_date = nvl(cur_row.completion_date, completion_date),
524: attribute_category = NVL(cur_row.attribute_category,
525: attribute_category),

Line 717: activity_id, autocharge_type, standard_rate_flag,

713: last_update_login, request_id, program_application_id,
714: program_id, program_update_date,
715: scheduled_flag, assigned_units, applied_resource_units,
716: applied_resource_value, uom_code, basis_type,
717: activity_id, autocharge_type, standard_rate_flag,
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

Line 782: activity_id, autocharge_type, standard_rate_flag,

778: last_update_login, request_id, program_application_id,
779: program_id, program_update_date,
780: scheduled_flag, assigned_units, maximum_assigned_units,applied_resource_units,
781: applied_resource_value, uom_code, basis_type,
782: activity_id, autocharge_type, standard_rate_flag,
783: start_date, completion_date,attribute_category, attribute1,
784: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
785: attribute8,attribute9,attribute10,attribute11,attribute12,
786: attribute13,attribute14,attribute15,schedule_seq_num,

Line 832: standard_rate_flag,

828: uom_code,
829: basis_type,
830: activity_id,
831: autocharge_type,
832: standard_rate_flag,
833: start_date,
834: completion_date,
835: attribute_category,
836: attribute1,

Line 880: cur_row.standard_rate_flag,

876: cur_row.uom_code,
877: cur_row.basis_type,
878: cur_row.activity_id,
879: cur_row.autocharge_type,
880: cur_row.standard_rate_flag,
881: cur_row.start_date,
882: cur_row.completion_date,
883: cur_row.attribute_category,
884: cur_row.attribute1,

Line 932: activity_id, autocharge_type, standard_rate_flag,

928: last_update_login, request_id, program_application_id,
929: program_id, program_update_date,
930: scheduled_flag, assigned_units, maximum_assigned_units,applied_resource_units,
931: applied_resource_value, uom_code, basis_type,
932: activity_id, autocharge_type, standard_rate_flag,
933: start_date, completion_date,attribute_category, attribute1,
934: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
935: attribute8,attribute9,attribute10,attribute11,attribute12,
936: attribute13,attribute14,attribute15, schedule_seq_num,

Line 981: standard_rate_flag = nvl(cur_row.standard_rate_flag, standard_rate_flag),

977: uom_code = cur_row.uom_code,
978: basis_type = nvl(cur_row.basis_type, basis_type),
979: activity_id = cur_row.activity_id,
980: autocharge_type = nvl(cur_row.autocharge_type, autocharge_type),
981: standard_rate_flag = nvl(cur_row.standard_rate_flag, standard_rate_flag),
982: start_date = nvl(cur_row.start_date, start_date),
983: completion_date = nvl(cur_row.completion_date, completion_date),
984: attribute_category = NVL(cur_row.attribute_category,
985: attribute_category),

Line 1701: SELECT distinct parent_header_id, operation_seq_num, standard_operation_id,

1697:
1698: CURSOR oper_info ( p_group_id number,
1699: p_wip_entity_id number,
1700: p_organization_id number) IS
1701: SELECT distinct parent_header_id, operation_seq_num, standard_operation_id,
1702: department_id, description , first_unit_start_date,
1703: first_unit_completion_date, last_unit_start_date,
1704: last_unit_completion_date, minimum_transfer_quantity,
1705: count_point_type, backflush_flag,last_update_date,

Line 1928: IF cur_oper.standard_operation_id is not null THEN

1924: l_quantity_in_queue := 0;
1925:
1926: END IF;
1927:
1928: IF cur_oper.standard_operation_id is not null THEN
1929: wip_operations_pkg.add(p_organization_id,
1930: p_wip_entity_id,
1931: cur_oper.operation_seq_num,
1932: cur_oper.standard_operation_id,

Line 1932: cur_oper.standard_operation_id,

1928: IF cur_oper.standard_operation_id is not null THEN
1929: wip_operations_pkg.add(p_organization_id,
1930: p_wip_entity_id,
1931: cur_oper.operation_seq_num,
1932: cur_oper.standard_operation_id,
1933: cur_oper.department_id);
1934: UPDATE WIP_OPERATIONS
1935: SET last_update_date = sysdate,/*BUG 6721823*/
1936: last_updated_by = NVL(cur_oper.last_updated_by,last_updated_by),

Line 2050: standard_operation_id,

2046: request_id,
2047: program_application_id,
2048: program_id,
2049: program_update_date,
2050: standard_operation_id,
2051: department_id,
2052: description,
2053: scheduled_quantity,
2054: quantity_in_queue,

Line 2098: cur_oper.standard_operation_id,

2094: cur_oper.request_id,
2095: cur_oper.program_application_id,
2096: cur_oper.program_id,
2097: cur_oper.program_update_date,
2098: cur_oper.standard_operation_id,
2099: cur_oper.department_id,
2100: cur_oper.description,
2101: l_scheduled_quantity,
2102: l_quantity_in_queue,

Line 2217: SELECT WJDI.parent_header_id, WJDI.operation_seq_num, WJDI.standard_operation_id,

2213:
2214: CURSOR oper_info ( p_group_id number,
2215: p_wip_entity_id number,
2216: p_organization_id number) IS
2217: SELECT WJDI.parent_header_id, WJDI.operation_seq_num, WJDI.standard_operation_id,
2218: WJDI.department_id, WJDI.description ,
2219: /*Fix for But 8784056 (FP of 8704687). format the date from WJDI without second before update WIP_OPERATIONS, to make it consistant with other files.*/
2220: -- No need to truncate dates. Bug 13045227.
2221: WJDI.first_unit_start_date first_unit_start_date,

Line 2234: WO.standard_operation_id curr_standard_operation_id

2230: WJDI.attribute_category, WJDI.attribute1, WJDI.attribute2, WJDI.attribute3,
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)

Line 2266: if (cur_oper.curr_standard_operation_id is not null or cur_oper.standard_operation_id is not null ) then

2262:
2263: FOR cur_oper IN oper_info(p_group_id,p_wip_entity_id,p_organization_id) LOOP
2264:
2265: /* fix for bug#2653621, disable update of std_op_id and its department, same as form */
2266: if (cur_oper.curr_standard_operation_id is not null or cur_oper.standard_operation_id is not null ) then
2267: WIP_JSI_Utils.record_error_text
2268: ( 'Changing of Std Operation ID, and its associated Department ID in an operation is disallowed',
2269: true);
2270: cur_oper.standard_operation_id := null;

Line 2270: cur_oper.standard_operation_id := null;

2266: if (cur_oper.curr_standard_operation_id is not null or cur_oper.standard_operation_id is not null ) then
2267: WIP_JSI_Utils.record_error_text
2268: ( 'Changing of Std Operation ID, and its associated Department ID in an operation is disallowed',
2269: true);
2270: cur_oper.standard_operation_id := null;
2271: cur_oper.department_id := null;
2272: end if;
2273:
2274: --Bug#4675116

Line 2295: standard_operation_id = NVL(cur_oper.standard_operation_id,

2291: program_application_id = fnd_global.prog_appl_id,
2292: program_id = fnd_global.conc_program_id,
2293: program_update_date = sysdate,
2294: /*BUG 12814417 @End */
2295: standard_operation_id = NVL(cur_oper.standard_operation_id,
2296: standard_operation_id),
2297: department_id = NVL(cur_oper.department_id,department_id),
2298: description = NVL(cur_oper.description,description),
2299: first_unit_start_date = NVL(cur_oper.first_unit_start_date,

Line 2296: standard_operation_id),

2292: program_id = fnd_global.conc_program_id,
2293: program_update_date = sysdate,
2294: /*BUG 12814417 @End */
2295: standard_operation_id = NVL(cur_oper.standard_operation_id,
2296: standard_operation_id),
2297: department_id = NVL(cur_oper.department_id,department_id),
2298: description = NVL(cur_oper.description,description),
2299: first_unit_start_date = NVL(cur_oper.first_unit_start_date,
2300: first_unit_start_date),

Line 3156: l_load_type in ( wip_constants.create_job,wip_constants.create_ns_job)) /Bug 13004022 - Added wip_constants.create_ns_job for auto association of serial numbers for non standard job also /

3152: from wip_job_schedule_interface
3153: where rowid = p_rowid;
3154:
3155: if(l_defaultSN = wip_constants.yes and
3156: l_load_type in ( wip_constants.create_job,wip_constants.create_ns_job)) /*Bug 13004022 - Added wip_constants.create_ns_job for auto association of serial numbers for non standard job also */
3157: then
3158: --get the number of serial numbers defaulted and the start quantity of the job
3159:
3160: SELECT count(*)