VIEW: APPS.PA_BILLING_ORIG_EVENTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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