View: PA_DRAFT_REVENUE_ITEMS_V

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

View Text

SELECT R.ROWID
, R.LINE_NUM
, T.TASK_NUMBER
, T.TASK_NAME
, R.REVENUE_SOURCE
, LK1.MEANING
, R.AMOUNT
, R.PROJECT_ID
, R.DRAFT_REVENUE_NUM
, R.REVENUE_CATEGORY_CODE
, LK2.MEANING
, R.TASK_ID
, R.LAST_UPDATE_DATE
, R.LAST_UPDATED_BY
, R.LAST_UPDATE_LOGIN
, R.CREATION_DATE
, R.CREATED_BY
, R.PROGRAM_APPLICATION_ID
, R.PROGRAM_ID
, R.PROGRAM_UPDATE_DATE
, R.REQUEST_ID
, R.PROJFUNC_CURRENCY_CODE
, R.PROJFUNC_REVENUE_AMOUNT
, R.PROJECT_CURRENCY_CODE
, R.PROJECT_REVENUE_AMOUNT
, R.FUNDING_CURRENCY_CODE
, R.FUNDING_REVENUE_AMOUNT
, R.REVPROC_CURRENCY_CODE
, ERDL.FUNDING_REV_RATE_TYPE
, ERDL.FUNDING_REV_RATE_DATE
, ERDL.FUNDING_REV_EXCHANGE_RATE
, DECODE(NVL(R.REVTRANS_CURRENCY_CODE
, 'NONE')
, 'NONE'
, R.AMOUNT
, NVL(R.REVTRANS_AMOUNT
, 0))
, NVL(R.REVTRANS_CURRENCY_CODE
, R.REVPROC_CURRENCY_CODE)
, ERDL.REVPROC_REVTRANS_RATE_TYPE
, ERDL.REVPROC_REVTRANS_RATE_DATE
, ERDL.REVPROC_REVTRANS_EX_RATE
FROM PA_DRAFT_REVENUE_ITEMS R
, PA_TASKS T
, PA_LOOKUPS LK1
, PA_LOOKUPS LK2
, PA_CUST_EVENT_REV_DIST_LINES ERDL
WHERE R.PROJECT_ID = ERDL.PROJECT_ID(+)
AND R.DRAFT_REVENUE_NUM = ERDL.DRAFT_REVENUE_NUM(+)
AND R.LINE_NUM = ERDL.DRAFT_REVENUE_ITEM_LINE_NUM(+)
AND R.TASK_ID = T.TASK_ID (+)
AND LK1.LOOKUP_TYPE (+) = DECODE(R.REVENUE_SOURCE
, NULL
, NULL
, 'REVENUE SOURCE')
AND LK1.LOOKUP_CODE (+) = R.REVENUE_SOURCE || ''
AND LK2.LOOKUP_TYPE (+) = DECODE(R.REVENUE_CATEGORY_CODE
, NULL
, NULL
, 'REVENUE CATEGORY')
AND LK2.LOOKUP_CODE (+) = R.REVENUE_CATEGORY_CODE || ''

Columns