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.ENG_CHANGE_LIFECYCLE_UTIL dependencies on ENG_CHANGE_LINES

Line 1286: eng_change_lines line,

1282: SELECT DISTINCT route.route_id wf_route_id
1283: , line.change_line_id
1284: FROM eng_change_routes route,
1285: eng_change_statuses s,
1286: eng_change_lines line,
1287: eng_lifecycle_statuses line_start_after,
1288: eng_lifecycle_statuses new_status,
1289: eng_lifecycle_statuses cur_status
1290: WHERE route.status_code = Eng_Workflow_Util.G_RT_NOT_STARTED

Line 1982: eng_change_lines l

1978: l.change_type_id ,
1979: route.status_code wf_status_code
1980: FROM eng_change_routes route,
1981: eng_change_statuses s,
1982: eng_change_lines l
1983: WHERE s.status_code = l.status_code
1984: AND route.route_id(+) = l.route_id
1985: AND l.change_id = p_change_id ;
1986:

Line 1988: l_status_code eng_change_lines.complete_before_status_code%TYPE;

1984: AND route.route_id(+) = l.route_id
1985: AND l.change_id = p_change_id ;
1986:
1987: l_line_status_type eng_change_statuses.status_type%TYPE;
1988: l_status_code eng_change_lines.complete_before_status_code%TYPE;
1989: l_required_flag eng_change_lines.required_flag%TYPE := NULL;
1990: l_change_type_id NUMBER ;
1991: l_wf_status_code eng_change_routes.status_code%TYPE;
1992:

Line 1989: l_required_flag eng_change_lines.required_flag%TYPE := NULL;

1985: AND l.change_id = p_change_id ;
1986:
1987: l_line_status_type eng_change_statuses.status_type%TYPE;
1988: l_status_code eng_change_lines.complete_before_status_code%TYPE;
1989: l_required_flag eng_change_lines.required_flag%TYPE := NULL;
1990: l_change_type_id NUMBER ;
1991: l_wf_status_code eng_change_routes.status_code%TYPE;
1992:
1993: -- Select all revised items

Line 2001: l_ri_status_code eng_change_lines.status_code%TYPE;

1997: WHERE change_id = p_change_id
1998: FOR UPDATE;
1999:
2000:
2001: l_ri_status_code eng_change_lines.status_code%TYPE;
2002: -- revItem's status_code's sequence_number
2003: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
2004:
2005: l_last_imp_flag VARCHAR2(1) := 'N';

Line 3109: l_ri_status_code eng_change_lines.status_code%TYPE;

3105: SELECT status_code
3106: FROM eng_revised_items
3107: WHERE change_id = p_change_id
3108: FOR UPDATE;
3109: l_ri_status_code eng_change_lines.status_code%TYPE;
3110: -- revItem's status_code's sequence_number
3111: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3112: l_ri_status_type eng_change_statuses.status_type%TYPE;
3113:

Line 3793: l_ri_status_code eng_change_lines.status_code%TYPE;

3789:
3790: l_last_imp_flag VARCHAR2(1) := 'N';
3791:
3792: l_new_status_type eng_change_statuses.status_type%TYPE;
3793: l_ri_status_code eng_change_lines.status_code%TYPE;
3794: l_ri_status_type eng_change_statuses.status_type%TYPE;
3795:
3796: l_chg_notice eng_engineering_changes.change_notice%TYPE;
3797: l_org_id eng_engineering_changes.organization_id%TYPE;

Line 4167: l_ri_status_code eng_change_lines.status_code%TYPE;

4163: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4164:
4165: l_new_status_type eng_change_statuses.status_type%TYPE;
4166:
4167: l_ri_status_code eng_change_lines.status_code%TYPE;
4168: -- revItem's status_code's sequence_number
4169: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4170: l_ri_status_type eng_change_statuses.status_type%TYPE;
4171:

Line 4875: FROM eng_change_lines l,

4871: l_nir_update_flag VARCHAR2(1) := 'F';
4872:
4873: CURSOR c_lines IS
4874: SELECT s.status_type
4875: FROM eng_change_lines l,
4876: eng_change_statuses s
4877: WHERE l.change_id = p_change_id
4878: AND s.status_code = l.status_code;
4879: l_line_status_type eng_change_statuses.status_type%TYPE;