1. Tables and Views for SCM
  2. CJM_PROGRAM_TYPES_VL

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')