DBA Data[Home] [Help]

APPS.ENG_VALIDATE_ECO dependencies on ENG_CHANGE_LINES_VL

Line 1189: FROM eng_change_lines_vl

1185:
1186:
1187: CURSOR lines_for_eco( p_change_id NUMBER) IS
1188: SELECT status_code ,sequence_number , name
1189: FROM eng_change_lines_vl
1190: WHERE eng_change_lines_vl.change_id = p_change_id
1191: and sequence_number<> -1;
1192:
1193: CURSOR revised_items_for_eco( p_change_id NUMBER) IS

Line 1190: WHERE eng_change_lines_vl.change_id = p_change_id

1186:
1187: CURSOR lines_for_eco( p_change_id NUMBER) IS
1188: SELECT status_code ,sequence_number , name
1189: FROM eng_change_lines_vl
1190: WHERE eng_change_lines_vl.change_id = p_change_id
1191: and sequence_number<> -1;
1192:
1193: CURSOR revised_items_for_eco( p_change_id NUMBER) IS
1194: SELECT STATUS_TYPE ,scheduled_date