3632: , x_line_approval_status
3633: , l_assignee_id
3634: , l_list_dist_status
3635: , l_route_type_code
3636: FROM FND_LOOKUPS dist_stat_flu,
3637: FND_LOOKUPS flu,
3638: MFG_LOOKUPS mlu,
3639: ENG_CHANGE_ROUTES line_wf,
3640: ENG_CHANGE_LINES_VL ecl
3633: , l_assignee_id
3634: , l_list_dist_status
3635: , l_route_type_code
3636: FROM FND_LOOKUPS dist_stat_flu,
3637: FND_LOOKUPS flu,
3638: MFG_LOOKUPS mlu,
3639: ENG_CHANGE_ROUTES line_wf,
3640: ENG_CHANGE_LINES_VL ecl
3641: WHERE line_wf.route_id (+)= ecl.route_id
3947: SELECT Step.step_seq_num
3948: , TRUNC(Step.required_date) required_date
3949: , ConditionTypeLookup.meaning condition_type
3950: , Step.instruction
3951: FROM FND_LOOKUPS ConditionTypeLookup ,
3952: ENG_CHANGE_ROUTE_STEPS_VL Step
3953: WHERE ConditionTypeLookup.lookup_code = Step.condition_type_code
3954: AND ConditionTypeLookup.lookup_type = 'ENG_CHANGE_ROUTE_CONDITIONS'
3955: AND Step.step_id = p_route_step_id ;