View: PA_CI_CRPRJ_LIST_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_CI_CRPRJ_LIST_V

View Text

SELECT CI.PROJECT_ID
, PPA.SEGMENT1
, PPA.NAME
, PPA.LONG_NAME
, PPA.NAME || '(' || PPA.SEGMENT1 || ')'
, PPA.PROJECT_STATUS_CODE
, PPA.START_DATE
, CI.CI_ID
, CI.CI_NUMBER
, CITYPEB.CI_TYPE_ID
, CI.SUMMARY
, CI.DESCRIPTION
, CI.STATUS_CODE
, STATUS.PROJECT_STATUS_NAME
, STATUS.PROJECT_SYSTEM_STATUS_CODE
, NULL
, CI.OWNER_ID
, OWNER.PARTY_NAME
, CI.OBJECT_TYPE
, CI.OBJECT_ID
, DECODE(CI.OBJECT_TYPE
, NULL
, NULL
, PA_PROJ_ELEMENTS_UTILS.GET_ELEMENT_NAME(CI.OBJECT_ID))
, DECODE(CI.OBJECT_TYPE
, NULL
, NULL
, PA_PROJ_ELEMENTS_UTILS.GET_ELEMENT_NUMBER(CI.OBJECT_ID))
, DECODE(CI.OBJECT_TYPE
, NULL
, NULL
, PA_PROJ_ELEMENTS_UTILS.GET_ELEMENT_NAME_NUMBER(CI.OBJECT_ID))
, CI.DATE_REQUIRED
, RESOLUTION.CLASS_CODE
, CI.RESOLUTION
, RESOLUTION.CLASS_CATEGORY
, CI.STATUS_OVERVIEW
, CLASSIFICATION.CLASS_CODE
, REASON.CLASS_CODE
, CI.PRIORITY_CODE
, PRIORITY_LKP.MEANING
, TO_NUMBER(PRIORITY_LKP.PREDEFINED_FLAG)
, CI.PRICE
, CI.PRICE_CURRENCY_CODE
, NULL
, CI.SOURCE_TYPE_CODE
, NULL
, CI.SOURCE_COMMENT
, CI.SOURCE_NUMBER
, CI.SOURCE_DATE_RECEIVED
, CI.SOURCE_ORGANIZATION
, CI.SOURCE_PERSON
, CI.CREATION_DATE
, CI.LAST_UPDATE_DATE
, CI.CREATED_BY
, CI.LAST_UPDATED_BY
, CITYPEB.CI_TYPE_CLASS_CODE
, CITYPETL.NAME
, CITYPETL.SHORT_NAME
, CITYPEB.APPROVAL_REQUIRED_FLAG
, NULL
, CI.DATE_CLOSED
, CI.CLOSED_BY_ID
, NULL
, CI.OPEN_ACTION_NUM
, CI.RECORD_VERSION_NUMBER
, SCI.CREATE_ACTION_FLAG
, SCI.UPDATE_FLAG
, CITYPETL.SHORT_NAME || '(' || CI.CI_NUMBER || ')'
, CI.PROGRESS_STATUS_CODE
, PRO_STATUS.PROJECT_STATUS_NAME
, CI.PROGRESS_AS_OF_DATE
, PRO_STATUS.STATUS_ICON_ACTIVE_IND
, CI.EFFORT_LEVEL_CODE
, NULL
, DECODE(CI.STATUS_CODE
, 'CI_CLOSED'
, NULL
, 'CI_CANCELED'
, NULL
, TRUNC(CI.DATE_REQUIRED) - TRUNC(SYSDATE))
, DECODE(CI.STATUS_CODE
, 'CI_CLOSED'
, NULL
, 'CI_CANCELED'
, NULL
, TRUNC(SYSDATE) - TRUNC(CI.LAST_UPDATE_DATE))
, FP.EST_QUANTITY
, FP.LABOR_QUANTITY
, FP.EST_PROJECT_RAW_COST
, FP.TOTAL_PROJECT_RAW_COST
, FP.EST_PROJECT_BURDENED_COST
, FP.TOTAL_PROJECT_BURDENED_COST
, FP.EST_PROJECT_REVENUE
, FP.TOTAL_PROJECT_REVENUE
, FP.DERIVED_QUANTITY
, FP.DERIVED_COST
, FP.DERIVED_REVENUE
, FP.DERIVED_MARGIN
, FP.DERIVED_MARGIN_PERCENTAGE
, FP.EST_MARGIN
, FP.EST_MARGIN_PERCENTAGE
, FP.PLANNED_MARGIN
, FP.PLANNED_MARGIN_PERCENTAGE
, PPA.PROJECT_CURRENCY_CODE
, NULL
, CI.LAST_MODIFIED_BY_ID
, NULL
, CI.CLASSIFICATION_CODE_ID
, CI.REASON_CODE_ID
, CI.RESOLUTION_CODE_ID
, CI.ATTRIBUTE_CATEGORY
, CI.ATTRIBUTE1
, CI.ATTRIBUTE2
, CI.ATTRIBUTE3
, CI.ATTRIBUTE4
, CI.ATTRIBUTE5
, CI.ATTRIBUTE6
, CI.ATTRIBUTE7
, CI.ATTRIBUTE8
, CI.ATTRIBUTE9
, CI.ATTRIBUTE10
, CI.ATTRIBUTE11
, CI.ATTRIBUTE12
, CI.ATTRIBUTE13
, CI.ATTRIBUTE14
, CI.ATTRIBUTE15
, CI.HIGHLIGHTED_FLAG
FROM PA_FP_CI_AMOUNTS_V FP
, PA_CLASS_CODES REASON
, PA_CLASS_CODES CLASSIFICATION
, PA_LOOKUPS PRIORITY_LKP
, HZ_PARTIES OWNER
, PA_PROJECT_STATUSES PRO_STATUS
, PA_PROJECT_STATUSES STATUS
, PA_PROJECTS_ALL PPA
, PA_CI_TYPES_TL CITYPETL
, PA_CI_TYPES_B CITYPEB
, PA_CI_SECURED_V SCI
, PA_CONTROL_ITEMS CI
, PA_CLASS_CODES RESOLUTION
WHERE CI.CI_TYPE_ID = CITYPEB.CI_TYPE_ID
AND SCI.CI_ID = CI.CI_ID
AND CITYPETL.CI_TYPE_ID = CITYPEB.CI_TYPE_ID
AND CITYPETL.LANGUAGE = USERENV('LANG')
AND PPA.PROJECT_ID = CI.PROJECT_ID
AND STATUS.PROJECT_STATUS_CODE = CI.STATUS_CODE
AND STATUS.STATUS_TYPE = 'CONTROL_ITEM'
AND PRO_STATUS.PROJECT_STATUS_CODE = CI.PROGRESS_STATUS_CODE
AND PRO_STATUS.STATUS_TYPE = 'PROGRESS'
AND OWNER.PARTY_ID = CI.OWNER_ID
AND PRIORITY_LKP.LOOKUP_CODE(+) = CI.PRIORITY_CODE
AND PRIORITY_LKP.LOOKUP_TYPE(+) = 'PA_TASK_PRIORITY_CODE'
AND REASON.CLASS_CODE_ID(+) = CI.REASON_CODE_ID
AND CLASSIFICATION.CLASS_CODE_ID(+) = CI.CLASSIFICATION_CODE_ID
AND FP.CI_ID(+) = CI.CI_ID
AND FP.PROJECT_ID(+) = CI.PROJECT_ID
AND RESOLUTION.CLASS_CODE_ID(+) = CI.RESOLUTION_CODE_ID

Columns