Product: | PA - Projects |
---|---|
Description: | Single-Org |
Implementation/DBA Data: | Not implemented in this database |
SELECT TASK_ID
, EVENT_NUM
, LINE_NUM
, AMOUNT
, CREATION_DATE
, CREATED_BY
, PROJECT_ID
, DRAFT_REVENUE_NUM
, DRAFT_REVENUE_ITEM_LINE_NUM
, CODE_COMBINATION_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, DRAFT_INVOICE_NUM
, DRAFT_INVOICE_ITEM_LINE_NUM
, BATCH_NAME
, LINE_NUM_REVERSED
, REVERSED_FLAG
, ORG_ID
, OUTPUT_VAT_TAX_ID
, OUTPUT_TAX_EXEMPT_FLAG
, OUTPUT_TAX_EXEMPT_REASON_CODE
, OUTPUT_TAX_EXEMPT_NUMBER
, PRC_GENERATED_FLAG
, BILL_TRANS_CURRENCY_CODE
, BILL_TRANS_AMOUNT
, REVPROC_CURRENCY_CODE
, REVPROC_RATE_TYPE
, REVPROC_RATE_DATE
, REVPROC_EXCHANGE_RATE
, INVPROC_CURRENCY_CODE
, INVPROC_RATE_TYPE
, INVPROC_RATE_DATE
, INVPROC_EXCHANGE_RATE
, PROJECT_CURRENCY_CODE
, PROJECT_REV_RATE_TYPE
, PA_MULTI_CURRENCY.GET_USER_CONVERSION_TYPE(PROJECT_REV_RATE_TYPE)
, PROJECT_REV_RATE_DATE
, PROJECT_REV_EXCHANGE_RATE
, PROJECT_REVENUE_AMOUNT
, PROJECT_INV_RATE_TYPE
, PROJECT_INV_RATE_DATE
, PROJECT_INV_EXCHANGE_RATE
, PROJECT_BILL_AMOUNT
, PROJFUNC_CURRENCY_CODE
, PROJFUNC_REV_RATE_TYPE
, PA_MULTI_CURRENCY.GET_USER_CONVERSION_TYPE(PROJFUNC_REV_RATE_TYPE)
, PROJFUNC_REV_RATE_DATE
, PROJFUNC_REV_EXCHANGE_RATE
, PROJFUNC_REVENUE_AMOUNT
, PROJFUNC_INV_RATE_TYPE
, PROJFUNC_INV_RATE_DATE
, PROJFUNC_INV_EXCHANGE_RATE
, PROJFUNC_BILL_AMOUNT
, FUNDING_CURRENCY_CODE
, FUNDING_REV_RATE_TYPE
, PA_MULTI_CURRENCY.GET_USER_CONVERSION_TYPE(FUNDING_REV_RATE_TYPE)
, FUNDING_REV_RATE_DATE
, FUNDING_REV_EXCHANGE_RATE
, FUNDING_REVENUE_AMOUNT
, FUNDING_INV_RATE_TYPE
, FUNDING_INV_RATE_DATE
, FUNDING_INV_EXCHANGE_RATE
, FUNDING_BILL_AMOUNT
, INV_GEN_REJECTION_CODE
, RETENTION_RULE_ID
, RETN_DRAFT_INVOICE_NUM
, RETN_DRAFT_INVOICE_LINE_NUM
, RETAINED_AMOUNT
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM PA_CUST_EVENT_RDL_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)