eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: ENG.ENG_CHANGE_LINES_INTERFACE#

Source

View Text - Preformatted


select ECO_NAME ECO_NAME, ORGANIZATION_CODE ORGANIZATION_CODE, CHANGE_TYPE_CODE CHANGE_TYPE_CODE, NAME NAME, DESCRIPTION DESCRIPTION, SEQUENCE_NUMBER SEQUENCE_NUMBER, OBJECT_DISPLAY_NAME OBJECT_DISPLAY_NAME, PK1_NAME PK1_NAME, PK2_NAME PK2_NAME, PK3_NAME PK3_NAME, PK4_NAME PK4_NAME, PK5_NAME PK5_NAME, RETURN_STATUS RETURN_STATUS, TRANSACTION_TYPE TRANSACTION_TYPE, TRANSACTION_ID TRANSACTION_ID, CHANGE_MGMT_TYPE_NAME CHANGE_MGMT_TYPE_NAME, ORGANIZATION_ID ORGANIZATION_ID, ENG_CHANGES_IFCE_KEY ENG_CHANGES_IFCE_KEY, PROCESS_FLAG PROCESS_FLAG, STATUS_NAME STATUS_NAME, ASSIGNEE_NAME ASSIGNEE_NAME, NEED_BY_DATE NEED_BY_DATE, SCHEDULED_DATE SCHEDULED_DATE, IMPLEMENTATION_DATE IMPLEMENTATION_DATE, CANCELATION_DATE CANCELATION_DATE, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE, COMPLETE_BEFORE_STATUS_CODE COMPLETE_BEFORE_STATUS_CODE, START_AFTER_STATUS_CODE START_AFTER_STATUS_CODE, TYPE_CLASSIFICATION TYPE_CLASSIFICATION from "ENG"."ENG_CHANGE_LINES_INTERFACE"

View Text - HTML Formatted

SELECT ECO_NAME ECO_NAME
, ORGANIZATION_CODE ORGANIZATION_CODE
, CHANGE_TYPE_CODE CHANGE_TYPE_CODE
, NAME NAME
, DESCRIPTION DESCRIPTION
, SEQUENCE_NUMBER SEQUENCE_NUMBER
, OBJECT_DISPLAY_NAME OBJECT_DISPLAY_NAME
, PK1_NAME PK1_NAME
, PK2_NAME PK2_NAME
, PK3_NAME PK3_NAME
, PK4_NAME PK4_NAME
, PK5_NAME PK5_NAME
, RETURN_STATUS RETURN_STATUS
, TRANSACTION_TYPE TRANSACTION_TYPE
, TRANSACTION_ID TRANSACTION_ID
, CHANGE_MGMT_TYPE_NAME CHANGE_MGMT_TYPE_NAME
, ORGANIZATION_ID ORGANIZATION_ID
, ENG_CHANGES_IFCE_KEY ENG_CHANGES_IFCE_KEY
, PROCESS_FLAG PROCESS_FLAG
, STATUS_NAME STATUS_NAME
, ASSIGNEE_NAME ASSIGNEE_NAME
, NEED_BY_DATE NEED_BY_DATE
, SCHEDULED_DATE SCHEDULED_DATE
, IMPLEMENTATION_DATE IMPLEMENTATION_DATE
, CANCELATION_DATE CANCELATION_DATE
, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE
, COMPLETE_BEFORE_STATUS_CODE COMPLETE_BEFORE_STATUS_CODE
, START_AFTER_STATUS_CODE START_AFTER_STATUS_CODE
, TYPE_CLASSIFICATION TYPE_CLASSIFICATION
FROM "ENG"."ENG_CHANGE_LINES_INTERFACE"