VIEW: APPS.PAFV_ASSET_LINES

Source

View Text - Preformatted

SELECT ppal.project_asset_line_id , ppal.project_asset_line_detail_id , ppal.original_asset_cost , ppal.current_asset_cost , ppal.description , gl_date , '_LA:transfer_status_code:PA_LOOKUPS:TRANSFER STATUS:MEANING' , transfer_rejection_reason , '_LA:ppal.amortize_flag:FND_LOOKUPS:YES_NO:MEANING' , ppal.project_asset_id , ppaa.asset_name , ppal.task_id,pt.task_number , pt.task_name , ppal.asset_category_id , fc.description , ppal.cip_ccid , ppal.rev_proj_asset_line_id , ppal.org_id , t.name , ppal.LAST_UPDATE_DATE , ppal.LAST_UPDATED_BY , ppal.CREATION_DATE , ppal.CREATED_BY, ppal.invoice_id, ppal.invoice_number FROM pa_project_asset_lines_all ppal , pa_tasks pt , pa_project_assets_all ppaa , fa_categories fc , hr_all_organization_units_tl t WHERE ppal.project_asset_id = ppaa.project_asset_id(+) and ppal.task_id = pt.task_id And ppal.asset_category_id = fc.category_id(+) and '_SEC:ppal.org_id' is not null and ppal.org_id=t.organization_id (+) and t.language(+) = userenv('lang') WITH READ ONLY

View Text - HTML Formatted

SELECT PPAL.PROJECT_ASSET_LINE_ID
, PPAL.PROJECT_ASSET_LINE_DETAIL_ID
, PPAL.ORIGINAL_ASSET_COST
, PPAL.CURRENT_ASSET_COST
, PPAL.DESCRIPTION
, GL_DATE
, '_LA:TRANSFER_STATUS_CODE:PA_LOOKUPS:TRANSFER STATUS:MEANING'
, TRANSFER_REJECTION_REASON
, '_LA:PPAL.AMORTIZE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PPAL.PROJECT_ASSET_ID
, PPAA.ASSET_NAME
, PPAL.TASK_ID
, PT.TASK_NUMBER
, PT.TASK_NAME
, PPAL.ASSET_CATEGORY_ID
, FC.DESCRIPTION
, PPAL.CIP_CCID
, PPAL.REV_PROJ_ASSET_LINE_ID
, PPAL.ORG_ID
, T.NAME
, PPAL.LAST_UPDATE_DATE
, PPAL.LAST_UPDATED_BY
, PPAL.CREATION_DATE
, PPAL.CREATED_BY
, PPAL.INVOICE_ID
, PPAL.INVOICE_NUMBER
FROM PA_PROJECT_ASSET_LINES_ALL PPAL
, PA_TASKS PT
, PA_PROJECT_ASSETS_ALL PPAA
, FA_CATEGORIES FC
, HR_ALL_ORGANIZATION_UNITS_TL T
WHERE PPAL.PROJECT_ASSET_ID = PPAA.PROJECT_ASSET_ID(+)
AND PPAL.TASK_ID = PT.TASK_ID
AND PPAL.ASSET_CATEGORY_ID = FC.CATEGORY_ID(+)
AND '_SEC:PPAL.ORG_ID' IS NOT NULL
AND PPAL.ORG_ID=T.ORGANIZATION_ID (+)
AND T.LANGUAGE(+) = USERENV('LANG') WITH READ ONLY