View: PA_BILLING_ORIG_EVENTS_V

Product:	PA - Projects
Description:	PA_BILLING_ORIG_EVENTS_V is a run time view for use in billing extensions that shows event info.
Implementation/DBA Data:	APPS.PA_BILLING_ORIG_EVENTS_V

View Text

SELECT EV.PROJECT_ID
, EV.TASK_ID
, EV.EVENT_NUM
, EV.EVENT_TYPE
, EV.REVENUE_AMOUNT
, EV.BILL_AMOUNT
, EV.BILLING_ASSIGNMENT_ID
, EV.ORGANIZATION_ID
, EV.COMPLETION_DATE
, EV.BILL_TRANS_CURRENCY_CODE
, EV.BILL_TRANS_BILL_AMOUNT
, EV.BILL_TRANS_REV_AMOUNT
, EV.PROJECT_CURRENCY_CODE
, EV.PROJECT_RATE_TYPE
, EV.PROJECT_RATE_DATE
, EV.PROJECT_EXCHANGE_RATE
, EV.PROJECT_INV_RATE_DATE
, EV.PROJECT_INV_EXCHANGE_RATE
, EV.PROJECT_BILL_AMOUNT
, EV.PROJECT_REV_RATE_DATE
, EV.PROJECT_REV_EXCHANGE_RATE
, EV.PROJECT_REVENUE_AMOUNT
, EV.PROJFUNC_CURRENCY_CODE
, EV.PROJFUNC_RATE_TYPE
, EV.PROJFUNC_RATE_DATE
, EV.PROJFUNC_EXCHANGE_RATE
, EV.PROJFUNC_INV_RATE_DATE
, EV.PROJFUNC_INV_EXCHANGE_RATE
, EV.PROJFUNC_BILL_AMOUNT
, EV.PROJFUNC_REV_RATE_DATE
, EV.PROJFUNC_REV_EXCHANGE_RATE
, EV.PROJFUNC_REVENUE_AMOUNT
, EV.FUNDING_RATE_TYPE
, EV.FUNDING_RATE_DATE
, EV.FUNDING_EXCHANGE_RATE
, EV.INVPROC_CURRENCY_CODE
, EV.INVPROC_RATE_TYPE
, EV.INVPROC_RATE_DATE
, EV.INVPROC_EXCHANGE_RATE
, EV.REVPROC_CURRENCY_CODE
, EV.REVPROC_RATE_TYPE
, EV.REVPROC_RATE_DATE
, EV.REVPROC_EXCHANGE_RATE
, EV.INV_GEN_REJECTION_CODE
FROM PA_EVENTS EV
, PA_DRAFT_INVOICE_ITEMS DII
, PA_DRAFT_INVOICES DI
WHERE EV.PROJECT_ID = DII.PROJECT_ID
AND NVL(EV.TASK_ID
, -1) = NVL(DII.EVENT_TASK_ID
, -1)
AND EV.EVENT_NUM = DII.EVENT_NUM
AND EV.BILLING_ASSIGNMENT_ID IS NOT NULL
AND DII.PROJECT_ID = DI.PROJECT_ID
AND DII.DRAFT_INVOICE_NUM = DI.DRAFT_INVOICE_NUM_CREDITED
AND DI.PROJECT_ID = NVL(PA_BILLING.GETPROJID
, DI.PROJECT_ID)
AND DI.REQUEST_ID = NVL(PA_BILLING.GETREQID
, DI.REQUEST_ID)
AND NVL(DII.TASK_ID
, -1) = NVL(PA_BILLING.GETTASKID
, NVL(DII.TASK_ID
, -1)) GROUP BY EV.PROJECT_ID
, EV.TASK_ID
, EV.EVENT_NUM
, EV.EVENT_TYPE
, EV.REVENUE_AMOUNT
, EV.BILL_AMOUNT
, EV.BILLING_ASSIGNMENT_ID
, EV.ORGANIZATION_ID
, EV.COMPLETION_DATE
, EV.BILL_TRANS_CURRENCY_CODE
, EV.BILL_TRANS_BILL_AMOUNT
, EV.BILL_TRANS_REV_AMOUNT
, EV.PROJECT_CURRENCY_CODE
, EV.PROJECT_RATE_TYPE
, EV.PROJECT_RATE_DATE
, EV.PROJECT_EXCHANGE_RATE
, EV.PROJECT_INV_RATE_DATE
, EV.PROJECT_INV_EXCHANGE_RATE
, EV.PROJECT_BILL_AMOUNT
, EV.PROJECT_REV_RATE_DATE
, EV.PROJECT_REV_EXCHANGE_RATE
, EV.PROJECT_REVENUE_AMOUNT
, EV.PROJFUNC_CURRENCY_CODE
, EV.PROJFUNC_RATE_TYPE
, EV.PROJFUNC_RATE_DATE
, EV.PROJFUNC_EXCHANGE_RATE
, EV.PROJFUNC_INV_RATE_DATE
, EV.PROJFUNC_INV_EXCHANGE_RATE
, EV.PROJFUNC_BILL_AMOUNT
, EV.PROJFUNC_REV_RATE_DATE
, EV.PROJFUNC_REV_EXCHANGE_RATE
, EV.PROJFUNC_REVENUE_AMOUNT
, EV.FUNDING_RATE_TYPE
, EV.FUNDING_RATE_DATE
, EV.FUNDING_EXCHANGE_RATE
, EV.INVPROC_CURRENCY_CODE
, EV.INVPROC_RATE_TYPE
, EV.INVPROC_RATE_DATE
, EV.INVPROC_EXCHANGE_RATE
, EV.REVPROC_CURRENCY_CODE
, EV.REVPROC_RATE_TYPE
, EV.REVPROC_RATE_DATE
, EV.REVPROC_EXCHANGE_RATE
, EV.INV_GEN_REJECTION_CODE

Columns