R12: PAXCARVW - Split Asset Line Performance (Doc ID 2362982.1)

Last updated on JULY 16, 2024

Applies to:

Symptoms

PAXCARVW, Performance issue

SELECT PROJECT_NUMBER,PROJECT_NAME,EXPENSED,CIP_COST,CAPITALIZED_COST,
 TOTAL_COSTS,CAPITALIZABLE_COST,PROJECT_ID,PROJECT_ORGANIZATION,
 PROJECT_STATUS_CODE,PROJECT_TYPE,INTERFACE_COMPLETE_ASSET_FLAG,
 INTERFACE_ASSET_COST_CODE,ASSET_ALLOCATION_METHOD,CAPITAL_EVENT_PROCESSING,
 CAPITAL_COST_TYPE_CODE,BURDEN_AMT_DISPLAY_METHOD,TOTAL_BURDEN_FLAG,ROW_ID,
 LAST_UPDATE_DATE,CREATION_DATE,LAST_UPDATED_BY,CREATED_BY,LAST_UPDATE_LOGIN,
 UPDATE_ALLOWED,VIEW_LABOR_COSTS_ALLOWED
FROM
PA_CAPITAL_PROJECTS_V WHERE (PROJECT_NUMBER=:1) order by project_number

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.