DBA Data[Home] [Help]

APPS.ENG_WORKFLOW_UTIL dependencies on FND_LOOKUPS

Line 3636: FROM FND_LOOKUPS dist_stat_flu,

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

Line 3637: FND_LOOKUPS flu,

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

Line 3951: FROM FND_LOOKUPS ConditionTypeLookup ,

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 ;