DBA Data[Home] [Help]

APPS.ENG_WORKFLOW_UTIL dependencies on MFG_LOOKUPS

Line 3485: MFG_LOOKUPS ecs,

3481: , l_phase_status_type
3482: FROM ENG_CHANGE_ORDER_TYPES_TL ecot,
3483: -- ENG_CHANGE_PRIORITIES priority,
3484: -- ENG_CHANGE_REASONS reason,
3485: MFG_LOOKUPS ecs,
3486: ENG_CHANGE_STATUSES_VL eclf,
3487: MFG_LOOKUPS mlu,
3488: HR_ORGANIZATION_UNITS hou,
3489: ENG_CHANGE_ORDER_TYPES ecmt,

Line 3487: MFG_LOOKUPS mlu,

3483: -- ENG_CHANGE_PRIORITIES priority,
3484: -- ENG_CHANGE_REASONS reason,
3485: MFG_LOOKUPS ecs,
3486: ENG_CHANGE_STATUSES_VL eclf,
3487: MFG_LOOKUPS mlu,
3488: HR_ORGANIZATION_UNITS hou,
3489: ENG_CHANGE_ORDER_TYPES ecmt,
3490: ENG_CHANGE_ORDER_TYPES_TL ecmt_tl,
3491: -- ENG_CHANGE_ORDER_TYPES_VL ecmt,

Line 3551: MFG_LOOKUPS mlu,

3547: FROM ENG_CHANGE_ORDER_TYPES ecot,
3548: -- ENG_CHANGE_PRIORITIES priority,
3549: -- ENG_CHANGE_REASONS reason,
3550: ENG_CHANGE_STATUSES_TL ecs,
3551: MFG_LOOKUPS mlu,
3552: HR_ORGANIZATION_UNITS hou,
3553: ENG_CHANGE_MGMT_TYPES_TL ecmt,
3554: ENG_ENGINEERING_CHANGES eec
3555: WHERE eec.change_order_type_id = ecot.change_order_type_id

Line 3638: MFG_LOOKUPS mlu,

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
3642: AND dist_stat_flu.lookup_code (+)= ecl.status_code

Line 4011: FROM MFG_LOOKUPS

4007: l_user_id := p_wf_user_id ;
4008:
4009: SELECT meaning
4010: INTO l_approval_status
4011: FROM MFG_LOOKUPS
4012: WHERE lookup_code = p_new_appr_status_type
4013: AND lookup_type = 'ENG_ECN_APPROVAL_STATUS' ;
4014:
4015: -- Comment Out