View: PA_PROJECT_ASSETS_V

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

View Text

SELECT PPA.ROWID ROW_ID
, PPA.PROJECT_ASSET_ID
, PPA.PROJECT_ID
, PPA.ASSET_NUMBER
, PPA.ASSET_NAME
, PPA.ASSET_DESCRIPTION
, PPA.LOCATION_ID
, PPA.ASSIGNED_TO_PERSON_ID
, PER.FULL_NAME
, NVL(PER.EMPLOYEE_NUMBER
, PER.NPW_NUMBER)
, PPA.DATE_PLACED_IN_SERVICE
, PPA.ESTIMATED_IN_SERVICE_DATE
, PPA.ASSET_CATEGORY_ID
, PPA.ASSET_KEY_CCID
, PPA.BOOK_TYPE_CODE
, PPA.ASSET_UNITS
, PPA.DEPRECIATE_FLAG
, PPA.AMORTIZE_FLAG
, PPA.COST_ADJUSTMENT_FLAG
, PPA.REVERSE_FLAG
, PPA.REVERSAL_DATE
, PPA.DEPRECIATION_EXPENSE_CCID
, PPA.CAPITALIZED_FLAG
, PPA.CAPITALIZED_DATE
, PPA.CAPITALIZED_COST
, PPA.GROUPED_CIP_COST
, SUM(NVL(NVL(MC.CURRENT_ASSET_COST
, PAL.CURRENT_ASSET_COST)
, 0)) TOTAL_ASSET_COST
, NULL REP_TOTAL_ASSET_COST
, PPA.ATTRIBUTE_CATEGORY
, PPA.ATTRIBUTE1
, PPA.ATTRIBUTE2
, PPA.ATTRIBUTE3
, PPA.ATTRIBUTE4
, PPA.ATTRIBUTE5
, PPA.ATTRIBUTE6
, PPA.ATTRIBUTE7
, PPA.ATTRIBUTE8
, PPA.ATTRIBUTE9
, PPA.ATTRIBUTE10
, PPA.ATTRIBUTE11
, PPA.ATTRIBUTE12
, PPA.ATTRIBUTE13
, PPA.ATTRIBUTE14
, PPA.ATTRIBUTE15
, PPA.LAST_UPDATE_DATE
, PPA.LAST_UPDATED_BY
, PPA.CREATION_DATE
, PPA.CREATED_BY
, PPA.LAST_UPDATE_LOGIN
, PPA.CAPITAL_EVENT_ID
, PPA.PROJECT_ASSET_TYPE
, PPA.FA_PERIOD_NAME
, PPA.PM_PRODUCT_CODE
, PPA.PM_ASSET_REFERENCE
, PPA.ESTIMATED_COST
, PPA.ESTIMATED_ASSET_UNITS
, PPA.PARENT_ASSET_ID
, PPA.MANUFACTURER_NAME
, PPA.MODEL_NUMBER
, PPA.TAG_NUMBER
, PPA.SERIAL_NUMBER
, PPA.RET_TARGET_ASSET_ID
, PPA.FA_ASSET_ID
, PPA.CAPITAL_HOLD_FLAG
, NULL
, PPA.ORG_ID
FROM PA_MC_PRJ_AST_LINES_ALL MC
, PA_PROJECT_ASSET_LINES_BAS PAL
, PA_PROJECT_ASSETS PPA
, PER_PEOPLE_F PER
WHERE PAL.PROJECT_ASSET_ID(+) = PPA.PROJECT_ASSET_ID
AND MC.SET_OF_BOOKS_ID (+) = PA_MC_CURRENCY_PKG.SET_OF_BOOKS
AND MC.PROJECT_ASSET_LINE_ID (+) = DECODE(PA_MC_CURRENCY_PKG.GET_MRC_SOB_TYPE_CODE
, 'R'
, PAL.PROJECT_ASSET_LINE_ID
, NULL)
AND PER.PERSON_ID (+) = PPA.ASSIGNED_TO_PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE (+)
AND PER.EFFECTIVE_END_DATE (+) GROUP BY PPA.ROWID
, PPA.PROJECT_ASSET_ID
, PPA.PROJECT_ID
, PPA.ASSET_NUMBER
, PPA.ASSET_NAME
, PPA.ASSET_DESCRIPTION
, PPA.LOCATION_ID
, PPA.ASSIGNED_TO_PERSON_ID
, PER.FULL_NAME
, NVL(PER.EMPLOYEE_NUMBER
, PER.NPW_NUMBER)
, PPA.DATE_PLACED_IN_SERVICE
, PPA.ESTIMATED_IN_SERVICE_DATE
, PPA.ASSET_CATEGORY_ID
, PPA.ASSET_KEY_CCID
, PPA.BOOK_TYPE_CODE
, PPA.ASSET_UNITS
, PPA.DEPRECIATE_FLAG
, PPA.AMORTIZE_FLAG
, PPA.COST_ADJUSTMENT_FLAG
, PPA.REVERSE_FLAG
, PPA.REVERSAL_DATE
, PPA.DEPRECIATION_EXPENSE_CCID
, PPA.CAPITALIZED_FLAG
, PPA.CAPITALIZED_DATE
, PPA.CAPITALIZED_COST
, PPA.GROUPED_CIP_COST
, PPA.ATTRIBUTE_CATEGORY
, PPA.ATTRIBUTE1
, PPA.ATTRIBUTE2
, PPA.ATTRIBUTE3
, PPA.ATTRIBUTE4
, PPA.ATTRIBUTE5
, PPA.ATTRIBUTE6
, PPA.ATTRIBUTE7
, PPA.ATTRIBUTE8
, PPA.ATTRIBUTE9
, PPA.ATTRIBUTE10
, PPA.ATTRIBUTE11
, PPA.ATTRIBUTE12
, PPA.ATTRIBUTE13
, PPA.ATTRIBUTE14
, PPA.ATTRIBUTE15
, PPA.LAST_UPDATE_DATE
, PPA.LAST_UPDATED_BY
, PPA.CREATION_DATE
, PPA.CREATED_BY
, PPA.LAST_UPDATE_LOGIN
, PPA.CAPITAL_EVENT_ID
, PPA.PROJECT_ASSET_TYPE
, PPA.FA_PERIOD_NAME
, PPA.PM_PRODUCT_CODE
, PPA.PM_ASSET_REFERENCE
, PPA.ESTIMATED_COST
, PPA.ESTIMATED_ASSET_UNITS
, PPA.PARENT_ASSET_ID
, PPA.MANUFACTURER_NAME
, PPA.MODEL_NUMBER
, PPA.TAG_NUMBER
, PPA.SERIAL_NUMBER
, PPA.RET_TARGET_ASSET_ID
, PPA.FA_ASSET_ID
, PPA.CAPITAL_HOLD_FLAG
, PPA.ORG_ID

Columns