DBA Data[Home] [Help]

APPS.ENG_VAL_TO_ID dependencies on ENG_CHANGE_ORDER_TYPES_VL

Line 696: FROM eng_change_order_types_VL --11.5.10 changes

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

Line 894: FROM eng_change_order_types_vl

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

Line 936: FROM eng_change_order_types_vl

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

Line 972: FROM eng_change_order_types_vl

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