Product: | PA - Projects |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.PABV_PROJECTS |
SELECT PPA.PROJECT_ID
, PPS.PROJECT_STATUS_NAME
, PPA.NAME
, PPA.SEGMENT1
, PPA.DESCRIPTION
, PPA.START_DATE
, PPA.COMPLETION_DATE
, PPA.CLOSED_DATE
, '_LA:WF_STATUS_CODE:PA_LOOKUPS:WF_STATUS_CODE:MEANING'
, '_LA:PM_PRODUCT_CODE:PA_LOOKUPS:PM_PRODUCT_CODE:MEANING'
, PPA.PM_PROJECT_REFERENCE
, '_LA:PUBLIC_SECTOR_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PDR.DISTRIBUTION_RULE
, PDR.MEANING
, '_DF:PA:PA_PROJECTS_DESC_FLEX:PPA'
, '_LA:TEMPLATE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PPA.CARRYING_OUT_ORGANIZATION_ID
, POU.NAME
, PPA.PROJECT_TYPE
, PPT.DESCRIPTION
, PPA.ORG_ID
, T2.NAME
, PPA.LAST_UPDATE_DATE
, PPA.LAST_UPDATED_BY
, PPA.CREATION_DATE
, PPA.CREATED_BY
FROM PA_PROJECTS_ALL PPA
, PA_PROJECT_TYPES_ALL PPT
, HR_ALL_ORGANIZATION_UNITS POU
, HR_ALL_ORGANIZATION_UNITS_TL T2
, PA_DISTRIBUTION_RULES PDR
, PA_PROJECT_STATUSES PPS
WHERE PPA.PROJECT_TYPE = PPT.PROJECT_TYPE
AND NVL(PPA.ORG_ID
, -99) = NVL(PPT.ORG_ID
, -99)
AND PDR.DISTRIBUTION_RULE(+) = PPA.DISTRIBUTION_RULE
AND PPA.PROJECT_STATUS_CODE = PPS.PROJECT_STATUS_CODE
AND PPA.CARRYING_OUT_ORGANIZATION_ID = POU.ORGANIZATION_ID
AND PPA.ORG_ID=T2.ORGANIZATION_ID(+)
AND T2.LANGUAGE(+) = USERENV('LANG')
AND '_SEC:PPA.ORG_ID' IS NOT NULL WITH READ ONLY