View: ENGFV_ENGINEERING_CHNG_ORDERS

Product:	ENG - Engineering
Description:
Implementation/DBA Data:	APPS.ENGFV_ENGINEERING_CHNG_ORDERS

View Text

SELECT EN.CHANGE_NOTICE ECO_NAME
, PA1.ORGANIZATION_CODE
, AL1.NAME ORGANIZATION_NAME
, EN.DESCRIPTION
, EN.INITIATION_DATE ECO_CREATION_DATE
, EN.IMPLEMENTATION_DATE
, EN.CANCELLATION_DATE
, EN.CANCELLATION_COMMENTS
, EN.PRIORITY_CODE
, EN.REASON_CODE
, EN.ESTIMATED_ENG_COST ENG_IMPLEMENTATION_COSTS
, EN.ESTIMATED_MFG_COST MFG_IMPLEMENTAION_COSTS
, EN.APPROVAL_DATE
, EN.APPROVAL_REQUEST_DATE
, '_LA:EN.APPROVAL_STATUS_TYPE:MFG_LOOKUPS:ENG_ECN_APPROVAL_STATUS:MEANING'
, '_LA:EN.STATUS_TYPE:MFG_LOOKUPS:ECG_ECN_STATUS:MEANING'
, PR.NAME PROJECT_NAME
, TA.TASK_NUMBER TASK_NAME
, P.FULL_NAME REQUESTOR_NAME
, EC.APPROVAL_LIST_NAME
, AL2.NAME ECO_RESPONSIBLE_ORGANIZATION
, CH.TYPE_NAME CHANGE_TYPE_CODE
, '_DF:ENG:ENG_ECN_APPROVERS:EN'
, EN.ORGANIZATION_ID
, EN.REQUESTOR_ID
, EN.APPROVAL_LIST_ID
, EN.CHANGE_ORDER_TYPE_ID
, EN.RESPONSIBLE_ORGANIZATION_ID
, EN.PROJECT_ID
, EN.TASK_ID
, EN.CREATION_DATE CREATED_ON
, EN.CREATED_BY
, EN.LAST_UPDATE_DATE UPDATED_ON
, EN.LAST_UPDATED_BY UPDATED_BY
FROM ENG_CHANGE_ORDER_TYPES_TL CH
, HR_ALL_ORGANIZATION_UNITS AL2
, HR_ALL_ORGANIZATION_UNITS AL1
, PA_PROJECTS_ALL PR
, PA_TASKS TA
, ENG_ECN_APPROVAL_LISTS EC
, MTL_PARAMETERS PA1
, HZ_PARTIES HZ
, PER_PEOPLE_F P
, ENG_ENGINEERING_CHANGES EN
WHERE EN.ORGANIZATION_ID = AL1.ORGANIZATION_ID
AND EN.ORGANIZATION_ID = PA1.ORGANIZATION_ID
AND EN.REQUESTOR_ID = HZ.PARTY_ID (+)
AND P.PARTY_ID (+)= HZ.PARTY_ID
AND ( ( P.PARTY_ID IS NULL ) OR ( (P.PARTY_ID IS NOT NULL)
AND (SYSDATE BETWEEN P.EFFECTIVE_START_DATE
AND NVL(P.EFFECTIVE_END_DATE
, SYSDATE) ) ) )
AND EN.APPROVAL_LIST_ID = EC.APPROVAL_LIST_ID (+)
AND EN.CHANGE_ORDER_TYPE_ID = CH.CHANGE_ORDER_TYPE_ID
AND CH.LANGUAGE = USERENV('LANG')
AND EN.RESPONSIBLE_ORGANIZATION_ID = AL2.ORGANIZATION_ID (+)
AND EN.PROJECT_ID = PR.PROJECT_ID (+)
AND EN.TASK_ID = TA.TASK_ID (+)
AND '_SEC:EN.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns