VIEW: APPS.PA_DRAFT_REVENUE_ITEMS_V

Source

View Text - Preformatted

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 || ''

View Text - HTML Formatted

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 || ''