VIEW: APPS.PA_CUST_REV_DIST_LINES_EI_V

Source

View Text - Preformatted

SELECT RDL.ROWID , RDL.EXPENDITURE_ITEM_ID , RDL.LINE_NUM , RDL.CREATION_DATE , RDL.CREATED_BY , RDL.PROJECT_ID , RDL.DRAFT_REVENUE_NUM , RDL.DRAFT_REVENUE_ITEM_LINE_NUM , RDL.AMOUNT , RDL.CODE_COMBINATION_ID , RDL.BILL_AMOUNT , RDL.FUNCTION_CODE , RDL.FUNCTION_TRANSACTION_CODE , RDL.REQUEST_ID , RDL.PROGRAM_APPLICATION_ID , RDL.PROGRAM_ID , RDL.PROGRAM_UPDATE_DATE , RDL.BATCH_NAME , RDL.ADDITIONAL_REVENUE_FLAG , RDL.INVOICE_ELIGIBLE_FLAG , RDL.DRAFT_INVOICE_NUM , RDL.DRAFT_INVOICE_ITEM_LINE_NUM , RDL.REVERSED_FLAG , RDL.LINE_NUM_REVERSED , RDL.REV_IND_COMPILED_SET_ID , RDL.INV_IND_COMPILED_SET_ID , RDL.RAW_COST , RDL.ORG_ID , RDL.OUTPUT_VAT_TAX_ID , RDL.OUTPUT_TAX_CLASSIFICATION_CODE , RDL.OUTPUT_TAX_EXEMPT_FLAG , RDL.OUTPUT_TAX_EXEMPT_REASON_CODE , RDL.OUTPUT_TAX_EXEMPT_NUMBER , RDL.PRC_GENERATED_FLAG , RDL.BILL_TRANS_CURRENCY_CODE , RDL.BILL_TRANS_AMOUNT , RDL.BILL_TRANS_BILL_AMOUNT , RDL.BILL_RATE , RDL.REVPROC_CURRENCY_CODE , RDL.REVPROC_RATE_TYPE , RDL.REVPROC_RATE_DATE , RDL.REVPROC_EXCHANGE_RATE , RDL.INVPROC_CURRENCY_CODE , RDL.INVPROC_RATE_TYPE , RDL.INVPROC_RATE_DATE , RDL.INVPROC_EXCHANGE_RATE , RDL.PROJECT_CURRENCY_CODE , RDL.PROJECT_REVENUE_AMOUNT , RDL.PROJECT_REV_RATE_TYPE , RDL.PROJECT_REV_RATE_DATE , RDL.PROJECT_REV_EXCHANGE_RATE , RDL.PROJECT_BILL_AMOUNT , RDL.PROJECT_INV_RATE_TYPE , RDL.PROJECT_INV_RATE_DATE , RDL.PROJECT_INV_EXCHANGE_RATE , RDL.PROJFUNC_CURRENCY_CODE , RDL.PROJFUNC_REVENUE_AMOUNT , RDL.PROJFUNC_REV_RATE_TYPE , RDL.PROJFUNC_REV_RATE_DATE , RDL.PROJFUNC_REV_EXCHANGE_RATE , RDL.PROJFUNC_BILL_AMOUNT , RDL.PROJFUNC_INV_RATE_TYPE , RDL.PROJFUNC_INV_RATE_DATE , RDL.PROJFUNC_INV_EXCHANGE_RATE , RDL.FUNDING_CURRENCY_CODE , RDL.FUNDING_REVENUE_AMOUNT , RDL.FUNDING_REV_RATE_TYPE , RDL.FUNDING_REV_RATE_DATE , RDL.FUNDING_REV_EXCHANGE_RATE , RDL.FUNDING_BILL_AMOUNT , RDL.FUNDING_INV_RATE_TYPE , RDL.FUNDING_INV_RATE_DATE , RDL.FUNDING_INV_EXCHANGE_RATE , RDL.LABOR_MULTIPLIER , RDL.DISCOUNT_PERCENTAGE , RDL.AMOUNT_CALCULATION_CODE , RDL.BILL_MARKUP_PERCENTAGE , RDL.RATE_SOURCE_ID , RDL.INV_GEN_REJECTION_CODE , RDL.RETN_DRAFT_INVOICE_NUM , RDL.RETN_DRAFT_INVOICE_LINE_NUM , RDL.RETAINED_AMOUNT , RDL.RETENTION_RULE_ID , RDL.RATE_DISC_REASON_CODE , NULL , NULL FROM PA_CUST_REV_DIST_LINES_ALL RDL

View Text - HTML Formatted

SELECT RDL.ROWID
, RDL.EXPENDITURE_ITEM_ID
, RDL.LINE_NUM
, RDL.CREATION_DATE
, RDL.CREATED_BY
, RDL.PROJECT_ID
, RDL.DRAFT_REVENUE_NUM
, RDL.DRAFT_REVENUE_ITEM_LINE_NUM
, RDL.AMOUNT
, RDL.CODE_COMBINATION_ID
, RDL.BILL_AMOUNT
, RDL.FUNCTION_CODE
, RDL.FUNCTION_TRANSACTION_CODE
, RDL.REQUEST_ID
, RDL.PROGRAM_APPLICATION_ID
, RDL.PROGRAM_ID
, RDL.PROGRAM_UPDATE_DATE
, RDL.BATCH_NAME
, RDL.ADDITIONAL_REVENUE_FLAG
, RDL.INVOICE_ELIGIBLE_FLAG
, RDL.DRAFT_INVOICE_NUM
, RDL.DRAFT_INVOICE_ITEM_LINE_NUM
, RDL.REVERSED_FLAG
, RDL.LINE_NUM_REVERSED
, RDL.REV_IND_COMPILED_SET_ID
, RDL.INV_IND_COMPILED_SET_ID
, RDL.RAW_COST
, RDL.ORG_ID
, RDL.OUTPUT_VAT_TAX_ID
, RDL.OUTPUT_TAX_CLASSIFICATION_CODE
, RDL.OUTPUT_TAX_EXEMPT_FLAG
, RDL.OUTPUT_TAX_EXEMPT_REASON_CODE
, RDL.OUTPUT_TAX_EXEMPT_NUMBER
, RDL.PRC_GENERATED_FLAG
, RDL.BILL_TRANS_CURRENCY_CODE
, RDL.BILL_TRANS_AMOUNT
, RDL.BILL_TRANS_BILL_AMOUNT
, RDL.BILL_RATE
, RDL.REVPROC_CURRENCY_CODE
, RDL.REVPROC_RATE_TYPE
, RDL.REVPROC_RATE_DATE
, RDL.REVPROC_EXCHANGE_RATE
, RDL.INVPROC_CURRENCY_CODE
, RDL.INVPROC_RATE_TYPE
, RDL.INVPROC_RATE_DATE
, RDL.INVPROC_EXCHANGE_RATE
, RDL.PROJECT_CURRENCY_CODE
, RDL.PROJECT_REVENUE_AMOUNT
, RDL.PROJECT_REV_RATE_TYPE
, RDL.PROJECT_REV_RATE_DATE
, RDL.PROJECT_REV_EXCHANGE_RATE
, RDL.PROJECT_BILL_AMOUNT
, RDL.PROJECT_INV_RATE_TYPE
, RDL.PROJECT_INV_RATE_DATE
, RDL.PROJECT_INV_EXCHANGE_RATE
, RDL.PROJFUNC_CURRENCY_CODE
, RDL.PROJFUNC_REVENUE_AMOUNT
, RDL.PROJFUNC_REV_RATE_TYPE
, RDL.PROJFUNC_REV_RATE_DATE
, RDL.PROJFUNC_REV_EXCHANGE_RATE
, RDL.PROJFUNC_BILL_AMOUNT
, RDL.PROJFUNC_INV_RATE_TYPE
, RDL.PROJFUNC_INV_RATE_DATE
, RDL.PROJFUNC_INV_EXCHANGE_RATE
, RDL.FUNDING_CURRENCY_CODE
, RDL.FUNDING_REVENUE_AMOUNT
, RDL.FUNDING_REV_RATE_TYPE
, RDL.FUNDING_REV_RATE_DATE
, RDL.FUNDING_REV_EXCHANGE_RATE
, RDL.FUNDING_BILL_AMOUNT
, RDL.FUNDING_INV_RATE_TYPE
, RDL.FUNDING_INV_RATE_DATE
, RDL.FUNDING_INV_EXCHANGE_RATE
, RDL.LABOR_MULTIPLIER
, RDL.DISCOUNT_PERCENTAGE
, RDL.AMOUNT_CALCULATION_CODE
, RDL.BILL_MARKUP_PERCENTAGE
, RDL.RATE_SOURCE_ID
, RDL.INV_GEN_REJECTION_CODE
, RDL.RETN_DRAFT_INVOICE_NUM
, RDL.RETN_DRAFT_INVOICE_LINE_NUM
, RDL.RETAINED_AMOUNT
, RDL.RETENTION_RULE_ID
, RDL.RATE_DISC_REASON_CODE
, NULL
, NULL
FROM PA_CUST_REV_DIST_LINES_ALL RDL