Product: | PA - Projects |
---|---|
Description: | Single currency view for pa_budget_lines |
Implementation/DBA Data: | Not implemented in this database |
SELECT PA.RESOURCE_ASSIGNMENT_ID
, PA.START_DATE
, PA.LAST_UPDATE_DATE
, PA.LAST_UPDATED_BY
, PA.CREATION_DATE
, PA.CREATED_BY
, PA.LAST_UPDATE_LOGIN
, PA.END_DATE
, PA.PERIOD_NAME
, PA.QUANTITY
, MC.RAW_COST
, MC.BURDENED_COST
, MC.REVENUE
, PA.CHANGE_REASON_CODE
, PA.DESCRIPTION
, PA.ATTRIBUTE_CATEGORY
, PA.ATTRIBUTE1
, PA.ATTRIBUTE2
, PA.ATTRIBUTE3
, PA.ATTRIBUTE4
, PA.ATTRIBUTE5
, PA.ATTRIBUTE6
, PA.ATTRIBUTE7
, PA.ATTRIBUTE8
, PA.ATTRIBUTE9
, PA.ATTRIBUTE10
, PA.ATTRIBUTE11
, PA.ATTRIBUTE12
, PA.ATTRIBUTE13
, PA.ATTRIBUTE14
, PA.ATTRIBUTE15
, PA.RAW_COST_SOURCE
, PA.BURDENED_COST_SOURCE
, PA.QUANTITY_SOURCE
, PA.REVENUE_SOURCE
, PA.PM_PRODUCT_CODE
, PA.PM_BUDGET_LINE_REFERENCE
, PA.COST_REJECTION_CODE
, PA.REVENUE_REJECTION_CODE
, PA.BURDEN_REJECTION_CODE
, PA.OTHER_REJECTION_CODE
, PA.CODE_COMBINATION_ID
, PA.CCID_GEN_STATUS_CODE
, PA.CCID_GEN_REJ_MESSAGE
, PA.REQUEST_ID
, PA.BORROWED_REVENUE
, PA.TP_REVENUE_IN
, PA.TP_REVENUE_OUT
, PA.REVENUE_ADJ
, PA.LENT_RESOURCE_COST
, PA.TP_COST_IN
, PA.TP_COST_OUT
, PA.COST_ADJ
, PA.UNASSIGNED_TIME_COST
, PA.UTILIZATION_PERCENT
, PA.UTILIZATION_HOURS
, PA.UTILIZATION_ADJ
, PA.CAPACITY
, PA.HEAD_COUNT
, PA.HEAD_COUNT_ADJ
, MC.REPORTING_CURRENCY_CODE
, MC.COST_RATE_TYPE
, MC.COST_EXCHANGE_RATE
, MC.COST_RATE_DATE_TYPE
, MC.REV_RATE_DATE_TYPE
, PA.PROJECT_CURRENCY_CODE
, PA.PROJECT_COST_RATE_TYPE
, PA.PROJECT_COST_EXCHANGE_RATE
, PA.PROJECT_COST_RATE_DATE_TYPE
, PA.PROJECT_RAW_COST
, PA.PROJECT_BURDENED_COST
, PA.PROJECT_REVENUE
, PA.TXN_RAW_COST
, PA.TXN_BURDENED_COST
, PA.TXN_REVENUE
, PA.TXN_CURRENCY_CODE
, PA.BUCKETING_PERIOD_CODE
, MC.COST_CONVERSION_DATE
, MC.REV_CONVERSION_DATE
, PA.PROJECT_COST_RATE_DATE
, PA.PROJECT_REV_RATE_DATE
, MC.REV_RATE_TYPE
, MC.REV_EXCHANGE_RATE
, PA.PROJECT_REV_RATE_TYPE
, PA.PROJECT_REV_EXCHANGE_RATE
, PA.PROJECT_REV_RATE_DATE_TYPE
, PA.BUDGET_LINE_ID
, PA.BUDGET_VERSION_ID
FROM PA_BUDGET_LINES PA
, PA_MC_BUDGET_LINES MC
WHERE MC.BUDGET_LINE_ID = PA.BUDGET_LINE_ID
AND MC.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -99)