View: PA_PROJECT_ASSET_LINES_V

Product:	PA - Projects
Description:	10SC Only
Implementation/DBA Data:	APPS.PA_PROJECT_ASSET_LINES_V

View Text

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

Columns