VIEW: APPS.PA_CUST_EVENT_REV_DIST_LINES_V

Source

View Text - Preformatted

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_CLASSIFICATION_CODE , 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 ,NVL(REVTRANS_AMOUNT,0) ,REVTRANS_CURRENCY_CODE ,REVPROC_REVTRANS_RATE_TYPE ,PA_MULTI_CURRENCY.GET_USER_CONVERSION_TYPE(REVPROC_REVTRANS_RATE_TYPE) ,REVPROC_REVTRANS_RATE_DATE ,REVPROC_REVTRANS_EX_RATE FROM pa_cust_event_rev_dist_lines

View Text - HTML Formatted

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_CLASSIFICATION_CODE
, 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
, NVL(REVTRANS_AMOUNT
, 0)
, REVTRANS_CURRENCY_CODE
, REVPROC_REVTRANS_RATE_TYPE
, PA_MULTI_CURRENCY.GET_USER_CONVERSION_TYPE(REVPROC_REVTRANS_RATE_TYPE)
, REVPROC_REVTRANS_RATE_DATE
, REVPROC_REVTRANS_EX_RATE
FROM PA_CUST_EVENT_REV_DIST_LINES