CJM_PROGRAMS_VL
Details
-
Schema: FUSION
-
Object owner: CJM
-
Object type: VIEW
Columns
Name |
---|
PROGRAM_HEADER_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE PROGRAM_CODE PROGRAM_TYPE_ID PROGRAM_TYPE_CODE OWNER_ID USER_STATUS_ID VENDOR_ID VENDOR_SITE_ID CONTACT_ID AUTHORIZATION_NUMBER QUOTE_NUMBER OVERRIDE_PROGRAM STATUS_CODE STATUS_CHANGE_DATE DISCOUNT_APPLIED_TO_CODE CURRENCY_CODE COMMITTED_AMOUNT ACCOUNT_CLOSED_FLAG VOLUME_PROGRAM_TYPE RETROACTIVE CALCULATION_METHOD_CODE ENABLE_BENEFICIARY BENEFICIARY_TYPE_CODE BENEFICIARY_VALUE_CODE HEADER_DYNAMIC_MATRIX_ID COMMON_DYNAMIC_MATRIX_ID HEADER_MATRIX_RULE_ID COMMON_MATRIX_RULE_ID SOLD_BY_SALES_METHOD_CODE BU_ID PROGRAM_ACTIVATION_DATE START_DATE END_DATE PRICING_DATE_TYPE_CODE PRICING_DATE_FROM PRICING_DATE_TO DISPLAY_ON_ORDER_FLAG REQUEST_ONLY_FLAG GRACE_PERIOD_IN_DAYS LAST_RUN_DATE LAST_PERIOD_END_DATE INITIATED_BY_CODE CUSTOMER_TYPE_CODE CUSTOMER_ID LUMPSUM_AMOUNT LUMPSUM_DISTRIB_TYPE_CODE ESTIMATED_AMOUNT ACCOUNTED_ESTIMATED_AMOUNT ACCOUNTED_LUMPSUM_AMOUNT EXCHANGE_RATE_TYPE EXCHANGE_RATE_DATE EXCHANGE_RATE COMMENTS_FOR_APPROVERS SUBMITTED_BY SUBMITTED_DATE APPROVED_DATE REJECTED_DATE ELIGIBLE_FOR_ALL_CUSTOMERS ATTRIBUTE_CATEGORY ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR20 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP5 CUSTOMER_ATTRIBUTE_CATEGORY CUSTOMER_ATTRIBUTE_CHAR1 CUSTOMER_ATTRIBUTE_CHAR2 CUSTOMER_ATTRIBUTE_CHAR3 CUSTOMER_ATTRIBUTE_CHAR4 CUSTOMER_ATTRIBUTE_CHAR5 CUSTOMER_ATTRIBUTE_CHAR6 CUSTOMER_ATTRIBUTE_CHAR7 CUSTOMER_ATTRIBUTE_CHAR8 CUSTOMER_ATTRIBUTE_CHAR9 CUSTOMER_ATTRIBUTE_CHAR10 CUSTOMER_ATTRIBUTE_CHAR11 CUSTOMER_ATTRIBUTE_CHAR12 CUSTOMER_ATTRIBUTE_CHAR13 CUSTOMER_ATTRIBUTE_CHAR14 CUSTOMER_ATTRIBUTE_CHAR15 CUSTOMER_ATTRIBUTE_CHAR16 CUSTOMER_ATTRIBUTE_CHAR17 CUSTOMER_ATTRIBUTE_CHAR18 CUSTOMER_ATTRIBUTE_CHAR19 CUSTOMER_ATTRIBUTE_CHAR20 CUSTOMER_ATTRIBUTE_NUMBER1 CUSTOMER_ATTRIBUTE_NUMBER2 CUSTOMER_ATTRIBUTE_NUMBER3 CUSTOMER_ATTRIBUTE_NUMBER4 CUSTOMER_ATTRIBUTE_NUMBER5 CUSTOMER_ATTRIBUTE_NUMBER6 CUSTOMER_ATTRIBUTE_NUMBER7 CUSTOMER_ATTRIBUTE_NUMBER8 CUSTOMER_ATTRIBUTE_NUMBER9 CUSTOMER_ATTRIBUTE_NUMBER10 CUSTOMER_ATTRIBUTE_DATE1 CUSTOMER_ATTRIBUTE_DATE2 CUSTOMER_ATTRIBUTE_DATE3 CUSTOMER_ATTRIBUTE_DATE4 CUSTOMER_ATTRIBUTE_DATE5 CUSTOMER_ATTRIBUTE_TIMESTAMP1 CUSTOMER_ATTRIBUTE_TIMESTAMP2 CUSTOMER_ATTRIBUTE_TIMESTAMP3 CUSTOMER_ATTRIBUTE_TIMESTAMP4 CUSTOMER_ATTRIBUTE_TIMESTAMP5 NAME DESCRIPTION |
Query
SQL_Statement |
---|
SELECT B.PROGRAM_HEADER_ID, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.REQUEST_ID, B.JOB_DEFINITION_NAME, B.JOB_DEFINITION_PACKAGE, B.PROGRAM_CODE, B.PROGRAM_TYPE_ID, B.PROGRAM_TYPE_CODE, B.OWNER_ID, B.USER_STATUS_ID, B.VENDOR_ID, B.VENDOR_SITE_ID, B.CONTACT_ID, B.AUTHORIZATION_NUMBER, B.QUOTE_NUMBER, B.OVERRIDE_PROGRAM, B.STATUS_CODE, B.STATUS_CHANGE_DATE, B.DISCOUNT_APPLIED_TO_CODE, B.CURRENCY_CODE, B.COMMITTED_AMOUNT, B.ACCOUNT_CLOSED_FLAG, B.VOLUME_PROGRAM_TYPE, B.RETROACTIVE, B.CALCULATION_METHOD_CODE, B.ENABLE_BENEFICIARY, B.BENEFICIARY_TYPE_CODE, B.BENEFICIARY_VALUE_CODE, B.HEADER_DYNAMIC_MATRIX_ID, B.COMMON_DYNAMIC_MATRIX_ID, B.HEADER_MATRIX_RULE_ID, B.COMMON_MATRIX_RULE_ID, B.SOLD_BY_SALES_METHOD_CODE, B.BU_ID, B.PROGRAM_ACTIVATION_DATE, B.START_DATE, B.END_DATE, B.PRICING_DATE_TYPE_CODE, B.PRICING_DATE_FROM, B.PRICING_DATE_TO, B.DISPLAY_ON_ORDER_FLAG, B.REQUEST_ONLY_FLAG, B.GRACE_PERIOD_IN_DAYS, B.LAST_RUN_DATE, B.LAST_PERIOD_END_DATE, B.INITIATED_BY_CODE, B.CUSTOMER_TYPE_CODE, B.CUSTOMER_ID, B.LUMPSUM_AMOUNT, B.LUMPSUM_DISTRIB_TYPE_CODE, B.ESTIMATED_AMOUNT, B.ACCOUNTED_ESTIMATED_AMOUNT, B.ACCOUNTED_LUMPSUM_AMOUNT, B.EXCHANGE_RATE_TYPE, B.EXCHANGE_RATE_DATE, B.EXCHANGE_RATE, B.COMMENTS_FOR_APPROVERS, B.SUBMITTED_BY, B.SUBMITTED_DATE, B.APPROVED_DATE, B.REJECTED_DATE, B.ELIGIBLE_FOR_ALL_CUSTOMERS, B.ATTRIBUTE_CATEGORY, B.ATTRIBUTE_CHAR1, B.ATTRIBUTE_CHAR2, B.ATTRIBUTE_CHAR3, B.ATTRIBUTE_CHAR4, B.ATTRIBUTE_CHAR5, B.ATTRIBUTE_CHAR6, B.ATTRIBUTE_CHAR7, B.ATTRIBUTE_CHAR8, B.ATTRIBUTE_CHAR9, B.ATTRIBUTE_CHAR10, B.ATTRIBUTE_CHAR11, B.ATTRIBUTE_CHAR12, B.ATTRIBUTE_CHAR13, B.ATTRIBUTE_CHAR14, B.ATTRIBUTE_CHAR15, B.ATTRIBUTE_CHAR16, B.ATTRIBUTE_CHAR17, B.ATTRIBUTE_CHAR18, B.ATTRIBUTE_CHAR19, B.ATTRIBUTE_CHAR20, B.ATTRIBUTE_NUMBER1, B.ATTRIBUTE_NUMBER2, B.ATTRIBUTE_NUMBER3, B.ATTRIBUTE_NUMBER4, B.ATTRIBUTE_NUMBER5, B.ATTRIBUTE_NUMBER6, B.ATTRIBUTE_NUMBER7, B.ATTRIBUTE_NUMBER8, B.ATTRIBUTE_NUMBER9, B.ATTRIBUTE_NUMBER10, B.ATTRIBUTE_DATE1, B.ATTRIBUTE_DATE2, B.ATTRIBUTE_DATE3, B.ATTRIBUTE_DATE4, B.ATTRIBUTE_DATE5, B.ATTRIBUTE_TIMESTAMP1, B.ATTRIBUTE_TIMESTAMP2, B.ATTRIBUTE_TIMESTAMP3, B.ATTRIBUTE_TIMESTAMP4, B.ATTRIBUTE_TIMESTAMP5, B.CUSTOMER_ATTRIBUTE_CATEGORY, B.CUSTOMER_ATTRIBUTE_CHAR1, B.CUSTOMER_ATTRIBUTE_CHAR2, B.CUSTOMER_ATTRIBUTE_CHAR3, B.CUSTOMER_ATTRIBUTE_CHAR4, B.CUSTOMER_ATTRIBUTE_CHAR5, B.CUSTOMER_ATTRIBUTE_CHAR6, B.CUSTOMER_ATTRIBUTE_CHAR7, B.CUSTOMER_ATTRIBUTE_CHAR8, B.CUSTOMER_ATTRIBUTE_CHAR9, B.CUSTOMER_ATTRIBUTE_CHAR10, B.CUSTOMER_ATTRIBUTE_CHAR11, B.CUSTOMER_ATTRIBUTE_CHAR12, B.CUSTOMER_ATTRIBUTE_CHAR13, B.CUSTOMER_ATTRIBUTE_CHAR14, B.CUSTOMER_ATTRIBUTE_CHAR15, B.CUSTOMER_ATTRIBUTE_CHAR16, B.CUSTOMER_ATTRIBUTE_CHAR17, B.CUSTOMER_ATTRIBUTE_CHAR18, B.CUSTOMER_ATTRIBUTE_CHAR19, B.CUSTOMER_ATTRIBUTE_CHAR20, B.CUSTOMER_ATTRIBUTE_NUMBER1, B.CUSTOMER_ATTRIBUTE_NUMBER2, B.CUSTOMER_ATTRIBUTE_NUMBER3, B.CUSTOMER_ATTRIBUTE_NUMBER4, B.CUSTOMER_ATTRIBUTE_NUMBER5, B.CUSTOMER_ATTRIBUTE_NUMBER6, B.CUSTOMER_ATTRIBUTE_NUMBER7, B.CUSTOMER_ATTRIBUTE_NUMBER8, B.CUSTOMER_ATTRIBUTE_NUMBER9, B.CUSTOMER_ATTRIBUTE_NUMBER10, B.CUSTOMER_ATTRIBUTE_DATE1, B.CUSTOMER_ATTRIBUTE_DATE2, B.CUSTOMER_ATTRIBUTE_DATE3, B.CUSTOMER_ATTRIBUTE_DATE4, B.CUSTOMER_ATTRIBUTE_DATE5, B.CUSTOMER_ATTRIBUTE_TIMESTAMP1, B.CUSTOMER_ATTRIBUTE_TIMESTAMP2, B.CUSTOMER_ATTRIBUTE_TIMESTAMP3, B.CUSTOMER_ATTRIBUTE_TIMESTAMP4, B.CUSTOMER_ATTRIBUTE_TIMESTAMP5, TL.NAME, TL.DESCRIPTION FROM CJM_PROGRAMS_ALL_B B, CJM_PROGRAMS_ALL_TL TL WHERE B.PROGRAM_HEADER_ID = TL.PROGRAM_HEADER_ID AND TL.LANGUAGE = USERENV('LANG') |