VIEW: APPS.ENGFV_ENGINEERING_CHNG_ORDERS

Source

View Text - Preformatted

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_ENGINEERING_CHANGES: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

View Text - HTML Formatted

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_ENGINEERING_CHANGES: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