DBA Data[Home] [Help]

APPS.INV_EBI_CHANGE_ORDER_HELPER dependencies on ENG_CHANGE_ORDER_TYPES_VL

Line 2689: FROM eng_change_order_types_vl

2685: BEGIN
2686:
2687: SELECT type_name
2688: INTO l_change_type_code
2689: FROM eng_change_order_types_vl
2690: WHERE change_order_type_id = p_change_type_id
2691: AND change_mgmt_type_code = 'CHANGE_ORDER'
2692: AND type_classification='HEADER';
2693:

Line 4205: ,eng_change_order_types_vl ecot

4201: ,hz_parties hp
4202: ,pa_projects_all ppa
4203: ,pa_proj_elements ppe
4204: ,hr_all_organization_units haou
4205: ,eng_change_order_types_vl ecot
4206: WHERE
4207: eec.change_id = p_change_id AND
4208: eec.change_order_type_id =ecot.change_order_type_id AND
4209: mp.organization_id = eec.organization_id AND