CJM_PROGRAM_TYPES_VL
Details
-
Schema: FUSION
-
Object owner: CJM
-
Object type: VIEW
Columns
Name |
---|
PROGRAM_TYPE_ID PROGRAM_TYPE_CODE OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN USER_STATUS_ID STATUS_CODE SEEDED_FLAG ENABLED_FLAG COST_PRICE_BASIS_ID INCLUDE_ACCRUAL_IN_MARGIN CUSTOMER_PROGRAM PARENT_PROGRAM_TYPE_ID SEEDED_PROGRAM_TYPE_CODE PROGRAM_CODE_PREFIX SOLD_BY_SALES_METHOD_CODE DEFAULT_CURRENCY_CODE APPROVAL_ENABLED_FLAG PRICING_DATE_TYPE_CODE DEFAULT_BUDGET_ID ENFORCE_BUDGET_FUNDING DEFAULT_CUSTOMER_TYPE_CODE DEFAULT_BENEF_TYPE_CODE DISCOUNT_APPLIED_TO_CODE DEFAULT_PROD_CONTEXT_CODE ENABLE_OFFINVOICE_FLAG OFFINVOICE_BASIS_ID OFFINVOICE_DISC_TYPE_CODE ENABLE_ACCRUAL_FLAG ACCRUAL_BASIS_ID ACCRUAL_BASIS_CODE ACCRUAL_DISCOUNT_TYPE_CODE PRICE_TYPE_CODE CHARGE_TYPE_CODE CHARGE_SUBTYPE_CODE DISPLAY_ON_FOM_FLAG REQUEST_ONLY_FLAG OVERRIDE_PROGRAM DEFAULT_CALC_METHOD_CODE DEFAULT_TIER_TYPE_CODE DIFF_RATES_ON_PROD_TIERS_FLAG PROGRAM_TYPE_NAME PROGRAM_TYPE_GUID ENABLE_BENEFICIARY_FLAG DEFAULT_PROD_DISTRIB_TYPE_CODE |
Query
SQL_Statement |
---|
SELECT B.program_type_id, B.program_type_code, B.object_version_number, B.created_by , B.creation_date , B.last_updated_by , B.last_update_date , B.last_update_login , B.user_status_id, B.status_code , B.seeded_flag , B.enabled_flag , B.cost_price_basis_id, B.include_accrual_in_margin, B.customer_program , B.parent_program_type_id , B.seeded_program_type_code , B.program_code_prefix , B.sold_by_sales_method_code , B.default_currency_code , B.approval_enabled_flag , B.pricing_date_type_code , B.default_budget_id , B.enforce_budget_funding , B.default_customer_type_code , B.default_benef_type_code, B.discount_applied_to_code , B.default_prod_context_code , B.enable_offinvoice_flag , B.offinvoice_basis_id, B.offinvoice_disc_type_code , B.enable_accrual_flag , B.accrual_basis_id , B.accrual_basis_code , B.accrual_discount_type_code , B.price_type_code , B.charge_type_code , B.charge_subtype_code , B.display_on_fom_flag , B.request_only_flag, B.override_program, B.DEFAULT_CALC_METHOD_CODE, B.DEFAULT_TIER_TYPE_CODE, B.DIFF_RATES_ON_PROD_TIERS_FLAG, TL.program_type_name, B.PROGRAM_TYPE_GUID, B.ENABLE_BENEFICIARY_FLAG, B.DEFAULT_PROD_DISTRIB_TYPE_CODE FROM CJM_PROGRAM_TYPES_B B, CJM_PROGRAM_TYPES_TL TL WHERE B.PROGRAM_TYPE_ID = TL.PROGRAM_TYPE_ID AND TL.LANGUAGE = USERENV('LANG') |