View: PA_PROJECT_ASSET_LINES_MRC_V

View Text

SELECT PA.ROWID PPAL_ROWID
, PA.PROJECT_ASSET_LINE_ID
, PA.DESCRIPTION
, PA.PROJECT_ASSET_ID
, DECODE(PPA.ASSET_NAME
, NULL
, PL3.MEANING
, PPA.ASSET_NAME) ASSET_NAME
, PA.PROJECT_ID
, PP.SEGMENT1 PROJECT_NAME
, PA.TASK_ID
, PT.TASK_NUMBER
, PT.TASK_NAME
, PA.CIP_CCID
, PA.ASSET_COST_CCID
, PA.ORIGINAL_ASSET_COST
, PA.CURRENT_ASSET_COST
, MC.ORIGINAL_ASSET_COST
, MC.CURRENT_ASSET_COST
, SB.CURRENCY_CODE
, MC.SET_OF_BOOKS_ID
, PA.PROJECT_ASSET_LINE_DETAIL_ID
, PA.ASSET_CATEGORY_ID
, PA.GL_DATE
, PA.TRANSFER_STATUS_CODE
, PL.MEANING TRANSFER_STATUS_M
, PA.TRANSFER_REJECTION_REASON
, PL2.MEANING TRANSFER_REJECTION_REASON_M
, PA.LAST_UPDATE_DATE
, PA.LAST_UPDATED_BY
, PA.CREATED_BY
, PA.CREATION_DATE
, PA.LAST_UPDATE_LOGIN
, PA.REV_PROJ_ASSET_LINE_ID
, PPA.ASSET_CATEGORY_ID ASSET_ASSET_CATEGORY_ID
, PPA.LOCATION_ID ASSET_LOCATION_ID
, PPA.ASSET_KEY_CCID
, PA.LINE_TYPE
, PA.CAPITAL_EVENT_ID
, PA.FA_PERIOD_NAME
, PA.RET_ADJUSTMENT_TXN_ID
, PA.RETIREMENT_COST_TYPE
, PP.ORG_ID
FROM PA_PROJECT_ASSET_LINES_ALL PA
, PA_MC_PRJ_AST_LINES_ALL MC
, GL_SETS_OF_BOOKS SB
, PA_PROJECTS PP
, PA_PROJECT_ASSETS_ALL PPA
, PA_TASKS PT
, PA_LOOKUPS PL
, PA_LOOKUPS PL2
, PA_LOOKUPS PL3
WHERE PA.PROJECT_ID = PP.PROJECT_ID
AND PA.TASK_ID = PT.TASK_ID (+)
AND PA.PROJECT_ASSET_ID = PPA.PROJECT_ASSET_ID (+)
AND MC.PROJECT_ASSET_LINE_ID = PA.PROJECT_ASSET_LINE_ID
AND MC.SET_OF_BOOKS_ID = SB.SET_OF_BOOKS_ID
AND PL2.LOOKUP_TYPE (+) = DECODE(PA.PROJECT_ID
, -1
, ' '
, 'TRANSFER REJECTION REASON')
AND PL2.LOOKUP_CODE (+) = PA.TRANSFER_REJECTION_REASON
AND PL.LOOKUP_TYPE = DECODE(PA.PROJECT_ID
, -1
, ' '
, 'TRANSFER STATUS' )
AND PL.LOOKUP_CODE||'' = PA.TRANSFER_STATUS_CODE
AND PL3.LOOKUP_TYPE = DECODE(PA.PROJECT_ID
, -1
, ' '
, 'UNASSIGNED ASSET')
AND PL3.LOOKUP_CODE||'' = 'UNASSIGNED'

Columns