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 515: standard_rate_flag = nvl(cur_row.standard_rate_flag, standard_rate_flag),

511: uom_code = nvl(cur_row.uom_code, uom_code),
512: basis_type = nvl(cur_row.basis_type, basis_type),
513: activity_id = nvl(cur_row.activity_id, activity_id),
514: autocharge_type = nvl(cur_row.autocharge_type, autocharge_type),
515: standard_rate_flag = nvl(cur_row.standard_rate_flag, standard_rate_flag),
516: start_date = nvl(cur_row.start_date, start_date),
517: completion_date = nvl(cur_row.completion_date, completion_date),
518: attribute_category = NVL(cur_row.attribute_category,
519: attribute_category),

Line 718: activity_id, autocharge_type, standard_rate_flag,

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

Line 783: activity_id, autocharge_type, standard_rate_flag,

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

Line 833: standard_rate_flag,

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

Line 881: cur_row.standard_rate_flag,

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

Line 933: activity_id, autocharge_type, standard_rate_flag,

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

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

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

Line 1680: SELECT distinct parent_header_id, operation_seq_num, standard_operation_id,

1676:
1677: CURSOR oper_info ( p_group_id number,
1678: p_wip_entity_id number,
1679: p_organization_id number) IS
1680: SELECT distinct parent_header_id, operation_seq_num, standard_operation_id,
1681: department_id, description , first_unit_start_date,
1682: first_unit_completion_date, last_unit_start_date,
1683: last_unit_completion_date, minimum_transfer_quantity,
1684: count_point_type, backflush_flag,last_update_date,

Line 1810: IF cur_oper.standard_operation_id is not null THEN

1806: l_quantity_in_queue := 0;
1807:
1808: END IF;
1809:
1810: IF cur_oper.standard_operation_id is not null THEN
1811: wip_operations_pkg.add(p_organization_id,
1812: p_wip_entity_id,
1813: cur_oper.operation_seq_num,
1814: cur_oper.standard_operation_id,

Line 1814: cur_oper.standard_operation_id,

1810: IF cur_oper.standard_operation_id is not null THEN
1811: wip_operations_pkg.add(p_organization_id,
1812: p_wip_entity_id,
1813: cur_oper.operation_seq_num,
1814: cur_oper.standard_operation_id,
1815: cur_oper.department_id);
1816: UPDATE WIP_OPERATIONS
1817: SET last_update_date = sysdate,/*BUG 6721823*/
1818: last_updated_by = NVL(cur_oper.last_updated_by,last_updated_by),

Line 1932: standard_operation_id,

1928: request_id,
1929: program_application_id,
1930: program_id,
1931: program_update_date,
1932: standard_operation_id,
1933: department_id,
1934: description,
1935: scheduled_quantity,
1936: quantity_in_queue,

Line 1980: cur_oper.standard_operation_id,

1976: cur_oper.request_id,
1977: cur_oper.program_application_id,
1978: cur_oper.program_id,
1979: cur_oper.program_update_date,
1980: cur_oper.standard_operation_id,
1981: cur_oper.department_id,
1982: cur_oper.description,
1983: l_scheduled_quantity,
1984: l_quantity_in_queue,

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

2095:
2096: CURSOR oper_info ( p_group_id number,
2097: p_wip_entity_id number,
2098: p_organization_id number) IS
2099: SELECT WJDI.parent_header_id, WJDI.operation_seq_num, WJDI.standard_operation_id,
2100: WJDI.department_id, WJDI.description , WJDI.first_unit_start_date,
2101: WJDI.first_unit_completion_date, WJDI.last_unit_start_date,
2102: WJDI.last_unit_completion_date, WJDI.minimum_transfer_quantity,
2103: WJDI.count_point_type, WJDI.backflush_flag,WJDI.last_update_date,

Line 2111: WO.standard_operation_id curr_standard_operation_id

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

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

2139:
2140: FOR cur_oper IN oper_info(p_group_id,p_wip_entity_id,p_organization_id) LOOP
2141:
2142: /* fix for bug#2653621, disable update of std_op_id and its department, same as form */
2143: if (cur_oper.curr_standard_operation_id is not null or cur_oper.standard_operation_id is not null ) then
2144: WIP_JSI_Utils.record_error_text
2145: ( 'Changing of Std Operation ID, and its associated Department ID in an operation is disallowed',
2146: true);
2147: cur_oper.standard_operation_id := null;

Line 2147: cur_oper.standard_operation_id := null;

2143: if (cur_oper.curr_standard_operation_id is not null or cur_oper.standard_operation_id is not null ) then
2144: WIP_JSI_Utils.record_error_text
2145: ( 'Changing of Std Operation ID, and its associated Department ID in an operation is disallowed',
2146: true);
2147: cur_oper.standard_operation_id := null;
2148: cur_oper.department_id := null;
2149: end if;
2150:
2151: --Bug#4675116

Line 2172: standard_operation_id = NVL(cur_oper.standard_operation_id,

2168: program_application_id),
2169: program_id = NVL(cur_oper.program_id,program_id),
2170: program_update_date = NVL(cur_oper.program_update_date,
2171: program_update_date),
2172: standard_operation_id = NVL(cur_oper.standard_operation_id,
2173: standard_operation_id),
2174: department_id = NVL(cur_oper.department_id,department_id),
2175: description = NVL(cur_oper.description,description),
2176: first_unit_start_date = NVL(cur_oper.first_unit_start_date,

Line 2173: standard_operation_id),

2169: program_id = NVL(cur_oper.program_id,program_id),
2170: program_update_date = NVL(cur_oper.program_update_date,
2171: program_update_date),
2172: standard_operation_id = NVL(cur_oper.standard_operation_id,
2173: standard_operation_id),
2174: department_id = NVL(cur_oper.department_id,department_id),
2175: description = NVL(cur_oper.description,description),
2176: first_unit_start_date = NVL(cur_oper.first_unit_start_date,
2177: first_unit_start_date),