Product: | PA - Projects |
---|---|
Description: | Business view to show information about the classification of expenditure types. |
Implementation/DBA Data: | APPS.PAFV_ASSETS |
SELECT PPA.PROJECT_ASSET_ID
, PPA.ASSET_NUMBER
, PPA.ASSET_NAME
, PPA.ASSET_UNITS
, '_LA:AMORTIZE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PPA.CAPITALIZED_COST
, PPA.CAPITALIZED_DATE
, '_LA:CAPITALIZED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:DEPRECIATE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PPA.ASSET_DESCRIPTION
, PPA.DATE_PLACED_IN_SERVICE
, PPA.ESTIMATED_IN_SERVICE_DATE
, PPA.GROUPED_CIP_COST
, PPA.REVERSAL_DATE
, '_LA:REVERSE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_DF:PA:PA_PROJECT_ASSETS:PPA'
, PPA.PROJECT_ID
, PPR.NAME
, PPR.SEGMENT1
, PPA.ASSET_CATEGORY_ID
, FC.DESCRIPTION
, PPA.ASSIGNED_TO_PERSON_ID
, PAP.FULL_NAME
, PPA.LOCATION_ID
, PPA.BOOK_TYPE_CODE
, PPA.ORG_ID
, T.NAME
, PPA.LAST_UPDATE_DATE
, PPA.LAST_UPDATED_BY
, PPA.CREATION_DATE
, PPA.CREATED_BY
FROM PA_PROJECT_ASSETS_ALL PPA
, PA_PROJECTS_ALL PPR
, FA_CATEGORIES FC
, PER_ALL_PEOPLE_F PAP
, HR_ALL_ORGANIZATION_UNITS_TL T
WHERE PPA.PROJECT_ID = PPR.PROJECT_ID
AND PPA.ASSET_CATEGORY_ID = FC.CATEGORY_ID(+)
AND PPA.ASSIGNED_TO_PERSON_ID = PAP.PERSON_ID(+)
AND TRUNC(SYSDATE) BETWEEN PAP.EFFECTIVE_START_DATE (+)
AND PAP.EFFECTIVE_END_DATE (+)
AND '_SEC:PPA.ORG_ID' IS NOT NULL
AND PPA.ORG_ID=T.ORGANIZATION_ID (+)
AND T.LANGUAGE(+) =USERENV('LANG') WITH READ ONLY