VIEW: APPS.ENG_ENG_CHANGES_INTERFACE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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