You are browsing the archive for OKS.

Service Contracts Tables

Oracle Service Contracts Tables:

  • OKS_ACTION_TIMES
  • OKS_ACTION_TIME_TYPES
  • OKS_BCL_PR
  • OKS_BILLING_HIST_INT_ALL
  • OKS_BILLING_PROFILES_B
  • OKS_BILLING_PROFILES_TL
  • OKS_BILLRATE_SCHEDULES
  • OKS_BILL_CONT_LINES
  • OKS_BILL_SUB_LINES
  • OKS_BILL_SUB_LINE_DTLS
  • OKS_BILL_TRANSACTIONS
  • OKS_BILL_TXN_LINES
  • OKS_BSD_PR
  • OKS_BSL_PR
  • OKS_BTL_PR
  • OKS_BTN_PR
  • OKS_CON_COV_LEVELS_INT_ALL
  • OKS_CON_ERRORS_INT_ALL
  • OKS_CON_HEADERS_INT_ALL
  • OKS_CON_LINES_INT_ALL
  • OKS_COVERAGES_INT_ALL
  • OKS_COVERAGE_TIMES
  • OKS_COVERAGE_TIMEZONES
  • OKS_COV_BILL_RATES_INT_ALL
  • OKS_COV_BILL_TYPES_INT_ALL
  • OKS_COV_TXN_GROUPS_INT_ALL
  • OKS_COV_TYPES_B
  • OKS_COV_TYPES_TL
  • OKS_INSTANCE_CONTRACTS_TEMP
  • OKS_INSTANCE_HISTORY
  • OKS_INSTANCE_K_DTLS_TEMP
  • OKS_INST_HIST_DETAILS
  • OKS_INTERACTION_HISTORY
  • OKS_ITEM_SPLIT
  • OKS_JTF_RES_TEMP
  • OKS_K_DEFAULTS
  • OKS_K_HEADERS_B
  • OKS_K_HEADERS_BH
  • OKS_K_LINES_B
  • OKS_K_LINES_BH
  • OKS_K_LINES_TL
  • OKS_K_LINES_TLH
  • OKS_K_ORDER_CONTACTS
  • OKS_K_ORDER_DETAILS
  • OKS_K_RES_TEMP
  • OKS_K_SALES_CREDITS
  • OKS_LEVEL_ELEMENTS
  • OKS_MSCHG_OPERATIONS_DTLS
  • OKS_PM_ACTIVITIES
  • OKS_PM_SCHEDULES
  • OKS_PM_STREAM_LEVELS
  • OKS_PROCESS_CONTROL
  • OKS_QUALIFIERS
  • OKS_REPORT_TEMPLATES
  • OKS_REPROCESSING
  • OKS_REV_DISTRIBUTIONS
  • OKS_RULES_DFF
  • OKS_SERV_AVAILS
  • OKS_SERV_AVAIL_EXCEPTS
  • OKS_STATUS_FORECAST
  • OKS_STREAM_LEVELS_B
  • OKS_STRM_TYPE
  • OKS_SUBSCR_ELEMENTS
  • OKS_SUBSCR_HEADER_B
  • OKS_SUBSCR_HEADER_TL
  • OKS_SUBSCR_PATTERNS
  • OKS_TEMPLATE_SET

Views in Service Contracts Module

List of views in Oracle Service Contracts Module

OKS_ACTION_TIME_TYPES_HV
OKS_ACTION_TIME_TYPES_V
OKS_ACTION_TIMES_HV
OKS_ACTION_TIMES_V
OKS_APPROVED_CONTRACTS_V
OKS_AUTH_HEADERS_HV
OKS_AUTH_HEADERS_V
OKS_AUTH_LINES_HV
OKS_AUTH_LINES_V
OKS_AUTH_PARTYACCTS_V
OKS_AUTH_SHOWALL_PROD_V
OKS_AUTH_UOM_COVPROD_V
OKS_BATCH_RULES_V
OKS_BCL_PR_V
OKS_BILL_CONT_LINES_V
OKS_BILL_SUB_LINES_V
OKS_BILL_SUBLINE_DTLS_V
OKS_BILL_TRANSACTIONS_V
OKS_BILL_TXN_LINES_V
OKS_BILLING_DTLS_V
OKS_BILLING_HIST_LINES_V
OKS_BILLING_HIST_V
OKS_BILLING_HISTORY_V
OKS_BILLING_PROFILES_B_DFV
OKS_BILLING_PROFILES_V
OKS_BILLPRST_SRVLINE_V
OKS_BILLPRST_SRVSUBLINE_V
OKS_BILLPRST_SUBSCRLINE_V
OKS_BILLPRST_USGDRILL_V
OKS_BILLPRST_USGSUBLINE_V
OKS_BILLRATE_SCHEDULES_HV
OKS_BILLRATE_SCHEDULES_V
OKS_BSD_PR_V
OKS_BSL_PR_V
OKS_BTL_PR_V
OKS_BTN_PR_V
OKS_BUS_PROCESSES_HV
OKS_BUS_PROCESSES_V
OKS_CONT_HEADERS_V
OKS_CONTACT_POINTS_V
OKS_CONTACT_V
OKS_CONTRACT_DTLS_V
OKS_CONTRACT_MODIFIER_V
OKS_CONTRACT_NUMBER_V
OKS_CONTRACT_PARTIES_V
OKS_CONTRACT_UPD_DTLS_V
OKS_CONTRACTS_V
OKS_COUNTERS_V
OKS_COV_ACTION_TIMES_HV
OKS_COV_ACTION_TIMES_V
OKS_COV_TYPES_B_DFV
OKS_COV_TYPES_V
OKS_COVDLEVEL_DETAILS_V
OKS_COVERAGE_TEMPLTS_V
OKS_COVERAGE_TIMES_HV
OKS_COVERAGE_TIMES_V
OKS_COVERAGE_TIMEZONES_HV
OKS_COVERAGE_TIMEZONES_V
OKS_COVERAGES_HV
OKS_COVERAGES_V
OKS_COVERED_LEVEL_V
OKS_COVTIMES_HIST_V
OKS_CUST_PRODUCTS_V
OKS_DOCUMENT_VERSIONS_V
OKS_ENT_BILL_RATES_V
OKS_ENT_BILL_TYPES_V
OKS_ENT_COVD_LEVELS_V
OKS_ENT_COVER_TIMES_V
OKS_ENT_COVERAGES_V
OKS_ENT_HDR_SUMMARY_V
OKS_ENT_HEADERS_V
OKS_ENT_K_STATUS_V
OKS_ENT_LINE_DETAILS_V
OKS_ENT_PARTY_CONT_V
OKS_ENT_REACT_TIME_H_V
OKS_ENT_REACT_TIME_L_V
OKS_ENT_TXN_GROUPS_V
OKS_EVENTS_V
OKS_EXPIRED_CONTRACTS_V
OKS_HEADER_DETAILS_V
OKS_HEADERS_V
OKS_HELP_DESK_V
OKS_INST_HIST_DETAILS_V
OKS_INST_HIST_V
OKS_INSTANCE_HISTORY_V
OKS_INTERACTION_HIST_V
OKS_INV_RVW_V
OKS_K_CATEGORIES_V
OKS_K_COVERAGES_V
OKS_K_DEFAULTS_V
OKS_K_DETAIL_V
OKS_K_GROUPS_V
OKS_K_HEADERS_HV
OKS_K_HEADERS_V
OKS_K_LINES_HV
OKS_K_LINES_V
OKS_K_ORDER_CONTACTS_V
OKS_K_ORDER_DETAILS_V
OKS_K_SALES_CREDITS_V
OKS_LAYOUT_TEMPLATES_V
OKS_LEVEL_ELEMENTS_V
OKS_LINE_DETAILS_V
OKS_LINES_V
OKS_MASSCHANGE_CRITERIA_V
OKS_MSCHG_OPERATIONS_DTLS_V
OKS_NOTE_SOURCES_V
OKS_ORDER_V
OKS_PARTIES_V
OKS_PM_ACTIVITIES_HV
OKS_PM_ACTIVITIES_V
OKS_PM_PROGRAM_V
OKS_PM_SCHEDULES_HV
OKS_PM_SCHEDULES_V
OKS_PM_STREAM_LEVELS_HV
OKS_PM_STREAM_LEVELS_V
OKS_PMA_V
OKS_PML_V
OKS_PRICE_BREAKS_HIST_V
OKS_PRICE_BREAKS_V
OKS_PROD_DETAILS_V
OKS_PRODUCT_DETAILS_V
OKS_PRODUCTS_V
OKS_QUALIFIERS_V
OKS_RA_HCONTACTS_V
OKS_REACTION_TIMES_HV
OKS_REACTION_TIMES_V
OKS_REP_V
OKS_REPNAME_V
OKS_REPORT_TEMPLATES_V
OKS_REPROCESSING_V
OKS_RESOURCE_GROUPS_V
OKS_RESOURCES_HV
OKS_RESOURCES_V
OKS_REV_DISTRIBUTIONS_V
OKS_RULES_DFF_DFV
OKS_RULES_V
OKS_SALES_COMPENSATION_V
OKS_SERV_AVAIL_EXCEPTS_V
OKS_SERV_AVAILS_V
OKS_SERV_CUSTEXC_V
OKS_SERV_HDR_V
OKS_SERV_PRODEXC_V
OKS_SERVICE_COV_TEMPLTS_V
OKS_STREAM_LEVELS_V
OKS_STREAM_V
OKS_STRM_TYPE_V
OKS_SUBSCR_ELEMENTS_V
OKS_SUBSCR_HEADER_V
OKS_SUBSCR_PATTERNS_V
OKS_TEMPLATE_COUNTERS_V
OKS_TEMPLATE_SET_V
OKS_TIME_CODE_UNITS_V
OKS_TIMEVALUES_V
OKS_USAGE_COUNTERS_V
OKS_USAGE_ITEM_V

Service Contracts Descriptive Flex Fields

Oracle Service Contracts module DFF list:

DFF View DFF CODE NAME DFF name
OKS_BILLING_PROFILES_B_DFV OKS_BILLINGPROFILE_FLEX Billing Profile
OKS_RULES_DFF_DFV OKS Rule Developer DF OKS Rule Developer DF
OKS_COV_TYPES_B_DFV OKS_COV_TYPES_FLEX Coverage Types