DBA Data[Home] [Help]

APPS.ENG_VAL_TO_ID dependencies on ENG_CHANGE_ORDER_TYPES_VL

Line 695: FROM eng_change_order_types_VL --11.5.10 changes

691:
692:
693: SELECT change_mgmt_type_code
694: INTO l_result
695: FROM eng_change_order_types_VL --11.5.10 changes
696: WHERE trim(type_name) = trim(p_change_management_type)
697: and type_classification='CATEGORY' and NVL(DISABLE_DATE,SYSDATE+1) > SYSDATE
698: and START_DATE <=SYSDATE;
699:

Line 893: FROM eng_change_order_types_vl

889:
890:
891: SELECT change_order_type_id, disable_date, object_id
892: INTO x_change_order_id, x_disable_date, x_object_id
893: FROM eng_change_order_types_vl
894: WHERE type_name = p_change_order_type
895: AND change_mgmt_type_code = p_change_mgmt_type
896: AND type_classification='HEADER';
897:

Line 935: FROM eng_change_order_types_vl

931: BEGIN
932:
933: SELECT change_order_type_id, disable_date, object_id
934: INTO x_change_order_id, x_disable_date, x_object_id
935: FROM eng_change_order_types_vl
936: WHERE type_name = p_change_order_type
937: AND change_mgmt_type_code = p_change_mgmt_type
938: AND type_classification='LINE';
939:

Line 971: FROM eng_change_order_types_vl

967: BEGIN
968:
969: SELECT change_mgmt_type_code
970: INTO x_change_mgmt_type_code
971: FROM eng_change_order_types_vl
972: WHERE type_name = p_change_mgmt_type_name
973: and type_classification='CATEGORY'
974: and NVL(DISABLE_DATE,SYSDATE+1) > SYSDATE
975: and START_DATE <=SYSDATE; --11.5.10