VIEW: APPS.PA_PROJECT_ASSET_LINES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'