DBA Data[Home] [Help]

APPS.ENG_ECO_PUB dependencies on ENG_CHANGE_ORDER_TYPES_VL

Line 934: FROM eng_change_order_types_vl ecotv_in

930:
931: /* Cursor to fetch the change type name for change order based seeded category */
932: CURSOR c_change_order_cat_type IS
933: SELECT ecotv_in.type_name
934: FROM eng_change_order_types_vl ecotv_in
935: WHERE ecotv_in.change_mgmt_type_code = 'CHANGE_ORDER'
936: AND ecotv_in.type_classification='CATEGORY';
937:
938: -- End changes for Bug 3542172

Line 947: FROM eng_change_order_types_vl ecotv1, eng_change_order_types_vl ecotv2

943: SELECT ecotv1.change_order_type_id change_mgmt_type_id,
944: ecotv2.change_order_type_id,
945: ecotv2.auto_numbering_method,
946: ecotv1.auto_numbering_method change_mgmt_method
947: FROM eng_change_order_types_vl ecotv1, eng_change_order_types_vl ecotv2
948: WHERE ecotv1.type_name = cp_change_type_name
949: AND ecotv1.TYPE_CLASSIFICATION= 'CATEGORY'
950: AND ecotv1.change_mgmt_type_code = ecotv2.change_mgmt_type_code
951: AND ecotv2.type_name = p_CHANGE_ORDER_TYPE