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_CHANGES_INTERFACE_V

Product:	ENG - Engineering
Description:	Mass change orders
Implementation/DBA Data:	APPS.ENG_ENG_CHANGES_INTERFACE_V

View Text

SELECT EECI.ROWID ROW_ID
, ORG2.ORGANIZATION_CODE
, ORG1.NAME
, EECI.CHANGE_NOTICE
, EECI.ORGANIZATION_ID
, EECI.LAST_UPDATE_DATE
, EECI.LAST_UPDATED_BY
, EECI.CREATION_DATE
, EECI.CREATED_BY
, EECI.LAST_UPDATE_LOGIN
, EECI.DESCRIPTION
, EECI.REQUEST_ID
, EECI.PROGRAM_APPLICATION_ID
, EECI.PROGRAM_ID
, EECI.PROGRAM_UPDATE_DATE
, EECI.CHANGE_ORDER_TYPE_ID
, EECI.RESPONSIBLE_ORGANIZATION_ID
, EECI.CO_CREATED
, ECT.TYPE_NAME CHANGE_ORDER_TYPE
, ECT.DESCRIPTION TYPE_DESCRIPTION
, ECT.ASSEMBLY_TYPE
FROM ENG_ENG_CHANGES_INTERFACE EECI
, ENG_CHANGE_ORDER_TYPES_VL ECT
, HR_ALL_ORGANIZATION_UNITS_TL ORG1
, MTL_PARAMETERS ORG2
WHERE EECI.IMPLEMENTATION_DATE IS NULL
AND EECI.CANCELLATION_DATE IS NULL
AND EECI.CHANGE_ORDER_TYPE_ID = ECT.CHANGE_ORDER_TYPE_ID
AND ORG1.LANGUAGE = USERENV('LANG')
AND EECI.ORGANIZATION_ID = ORG1.ORGANIZATION_ID
AND EECI.ORGANIZATION_ID = ORG2.ORGANIZATION_ID

Columns

Name
ROW_ID
ORGANIZATION_CODE
ORGANIZATION_NAME
CHANGE_NOTICE
ORGANIZATION_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
DESCRIPTION
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
CHANGE_ORDER_TYPE_ID
RESPONSIBLE_ORGANIZATION_ID
CO_CREATED
CHANGE_ORDER_TYPE
TYPE_DESCRIPTION
ASSEMBLY_TYPE