VIEW: PA.PA_BILLING_EXTENSIONS#

Source

View Text - Preformatted

select BILLING_EXTENSION_ID BILLING_EXTENSION_ID, NAME NAME, PROCEDURE_NAME PROCEDURE_NAME, AMOUNT_REQD_FLAG AMOUNT_REQD_FLAG, PERCENTAGE_REQD_FLAG PERCENTAGE_REQD_FLAG, CALLING_PROCESS CALLING_PROCESS, PRE_PROCESSING_FLAG PRE_PROCESSING_FLAG, POST_PROCESSING_FLAG POST_PROCESSING_FLAG, CALL_AFTER_REG_FLAG CALL_AFTER_REG_FLAG, CALL_AFTER_ADJ_FLAG CALL_AFTER_ADJ_FLAG, PROJECT_SPECIFIC_FLAG PROJECT_SPECIFIC_FLAG, MARK_EXP_ITEMS_FLAG MARK_EXP_ITEMS_FLAG, DESCRIPTION DESCRIPTION, DEFAULT_EVENT_DESCRIPTION DEFAULT_EVENT_DESCRIPTION, PROCESSING_ORDER PROCESSING_ORDER, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, TRX_INDEPENDENT_FLAG TRX_INDEPENDENT_FLAG, DEFAULT_EVENT_TYPE DEFAULT_EVENT_TYPE, CALL_BEFORE_DEL_FLAG CALL_BEFORE_DEL_FLAG, DEFAULT_COST_BUDGET_TYPE_CODE DEFAULT_COST_BUDGET_TYPE_CODE, DEFAULT_REV_BUDGET_TYPE_CODE DEFAULT_REV_BUDGET_TYPE_CODE, CALL_AFTER_CANCEL_INV_FLAG CALL_AFTER_CANCEL_INV_FLAG, CALL_AFTER_WOFF_INV_FLAG CALL_AFTER_WOFF_INV_FLAG, CALL_POST_REG_FLAG CALL_POST_REG_FLAG, PREDEFINED_FLAG PREDEFINED_FLAG, DEFAULT_REV_PLAN_TYPE_ID DEFAULT_REV_PLAN_TYPE_ID, DEFAULT_COST_PLAN_TYPE_ID DEFAULT_COST_PLAN_TYPE_ID, CALL_AFTER_CONCESSION_INV_FLAG CALL_AFTER_CONCESSION_INV_FLAG, ZD_EDITION_NAME ZD_EDITION_NAME from "PA"."PA_BILLING_EXTENSIONS"

View Text - HTML Formatted

SELECT BILLING_EXTENSION_ID BILLING_EXTENSION_ID
, NAME NAME
, PROCEDURE_NAME PROCEDURE_NAME
, AMOUNT_REQD_FLAG AMOUNT_REQD_FLAG
, PERCENTAGE_REQD_FLAG PERCENTAGE_REQD_FLAG
, CALLING_PROCESS CALLING_PROCESS
, PRE_PROCESSING_FLAG PRE_PROCESSING_FLAG
, POST_PROCESSING_FLAG POST_PROCESSING_FLAG
, CALL_AFTER_REG_FLAG CALL_AFTER_REG_FLAG
, CALL_AFTER_ADJ_FLAG CALL_AFTER_ADJ_FLAG
, PROJECT_SPECIFIC_FLAG PROJECT_SPECIFIC_FLAG
, MARK_EXP_ITEMS_FLAG MARK_EXP_ITEMS_FLAG
, DESCRIPTION DESCRIPTION
, DEFAULT_EVENT_DESCRIPTION DEFAULT_EVENT_DESCRIPTION
, PROCESSING_ORDER PROCESSING_ORDER
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, TRX_INDEPENDENT_FLAG TRX_INDEPENDENT_FLAG
, DEFAULT_EVENT_TYPE DEFAULT_EVENT_TYPE
, CALL_BEFORE_DEL_FLAG CALL_BEFORE_DEL_FLAG
, DEFAULT_COST_BUDGET_TYPE_CODE DEFAULT_COST_BUDGET_TYPE_CODE
, DEFAULT_REV_BUDGET_TYPE_CODE DEFAULT_REV_BUDGET_TYPE_CODE
, CALL_AFTER_CANCEL_INV_FLAG CALL_AFTER_CANCEL_INV_FLAG
, CALL_AFTER_WOFF_INV_FLAG CALL_AFTER_WOFF_INV_FLAG
, CALL_POST_REG_FLAG CALL_POST_REG_FLAG
, PREDEFINED_FLAG PREDEFINED_FLAG
, DEFAULT_REV_PLAN_TYPE_ID DEFAULT_REV_PLAN_TYPE_ID
, DEFAULT_COST_PLAN_TYPE_ID DEFAULT_COST_PLAN_TYPE_ID
, CALL_AFTER_CONCESSION_INV_FLAG CALL_AFTER_CONCESSION_INV_FLAG
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "PA"."PA_BILLING_EXTENSIONS"