VIEW: APPS.PAFV_ASSETS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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