VIEW: APPS.PA_PROJECT_ASSETS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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