OKS Views (134)

OKS - Service Contracts — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
`OKS_ACTION_TIMES_V`	View for OKS Action Times
`OKS_ACTION_TIME_TYPES_V`	View for OKS Action Time Types
`OKS_APPROVED_CONTRACTS_V`	View for Approved Contracts
`OKS_AUTH_HEADERS_HV`
`OKS_AUTH_HEADERS_V`
`OKS_AUTH_LINES_HV`
`OKS_AUTH_LINES_V`
`OKS_AUTH_SHOWALL_PROD_V`
`OKS_BCL_PR_V`	View for table OKS_BCL_PR
`OKS_BILLING_DTLS_V`	Service contracts billing details view.
`OKS_BILLING_HISTORY_V`	View used in Spredtable to display Billing History
`OKS_BILLING_HIST_LINES_V`	View for Service Contracts Billing History Lines
`OKS_BILLING_HIST_V`	View for Service Contracts Billing History
`OKS_BILLING_PROFILES_V`	View for table OKS_BILLING_PROFILES_B
`OKS_BILLPRST_SRVLINE_V`
`OKS_BILLPRST_SRVSUBLINE_V`
`OKS_BILLPRST_SUBSCRLINE_V`
`OKS_BILLPRST_USGDRILL_V`
`OKS_BILLPRST_USGSUBLINE_V`
`OKS_BILLRATE_SCHEDULES_V`	This view displays the bill rate and it's schedules for a service activity billing type defined in Coverage.
`OKS_BILL_CONT_LINES_V`	View for table OKS_BILL_CONT_LINES
`OKS_BILL_SUBLINE_DTLS_V`	View for table OKS_BILL_SUB_LINE_DTLS
`OKS_BILL_SUB_LINES_V`	Bill sub-lines view for Service Contracts
`OKS_BILL_TRANSACTIONS_V`	View for table OKC_CONTRACT_BILLINGS
`OKS_BILL_TXN_LINES_V`	View for table OKS_BILL_TXN_LINES
`OKS_BSD_PR_V`	View for table OKS_BSD_PR
`OKS_BSL_PR_V`	Bill sub-lines view for Service Contracts
`OKS_BTL_PR_V`	View for table OKS_BTL_PR
`OKS_BTN_PR_V`	View for table OKS_BTN_PR
`OKS_BUS_PROCESSES_HV`	History View for Coverage Business Process
`OKS_BUS_PROCESSES_V`	This view is to list all Business Processes that are applicable for a Service / Template Coverage.
`OKS_CONTACT_POINTS_V`	This View is used to Show all the Contact points for the Contact Entered in the Service Authoring Form.
`OKS_CONTACT_V`	Contacts View for Contract details Form
`OKS_CONTRACTS_V`	contracts view for contract details form
`OKS_CONTRACT_DTLS_V`	Service contracts invoice details view.
`OKS_CONTRACT_MODIFIER_V`	View Is Used For Quote Printing LOV to display distinct Contract Number Modifier
`OKS_CONTRACT_NUMBER_V`	View Is Used For Quote Printing LOV to display distinct Contract Numbers
`OKS_CONTRACT_PARTIES_V`	View Is Used For Quote Printing LOV to display distinct Party Names
`OKS_CONT_HEADERS_V`	This view is created for the object type OKS_K_HEADER used for the update level attribute in Mass change
`OKS_COUNTERS_V`	Counters View for Service Contracts
`OKS_COVDLEVEL_DETAILS_V`	This view is used to show the service details of a contract. This included all covered levels.
`OKS_COVERAGES_HV`	History View for Coverage
`OKS_COVERAGES_V`	This view lists all actual Coverages. In order to have a Coverage information for a specific service, the condition on SERVICE_CLE_ID must b
`OKS_COVERAGE_TEMPLTS_V`	List of Coverage Templates.
`OKS_COVERAGE_TIMES_V`	View for OKS Coverage Times
`OKS_COVERAGE_TIMEZONES_V`	View for OKS Coverage Time Zones
`OKS_COVERED_LEVEL_V`	Covered level view for Contract details form
`OKS_COV_ACTION_TIMES_V`	This view lists the action times defined for business processes in a coverage. This will be used by the Coverage UI.
`OKS_COV_TYPES_V`	View for coverage types.
`OKS_CUST_PRODUCTS_V`	This View is Used to Show the Product details in Service Authoring Form. (This is showed at Covered Level For Covered Product)
`OKS_DOCUMENT_VERSIONS_V`	This view is used to provide achived versions of a contract
`OKS_ENT_BILL_RATES_V`	Billing Rates View For Service Contracts
`OKS_ENT_BILL_TYPES_V`	Billing Type View For Service Contracts
`OKS_ENT_COVD_LEVELS_V`	View Lists all Coverage Leveles with Coverage level Identifier and Service Line Identifier
`OKS_ENT_COVERAGES_V`	View all Coverages attcahed to a Contract Line
`OKS_ENT_COVER_TIMES_V`	List if actual coverages attached to a contract line.
`OKS_ENT_HDR_SUMMARY_V`	This holds all the service contracts summary and party information.
`OKS_ENT_HEADERS_V`	View of all contracts
`OKS_ENT_K_STATUS_V`	Lists all Statuses of the Contract
`OKS_ENT_LINE_DETAILS_V`	This is view is supposed to be called only by passing service_line_id as bind variable.
`OKS_ENT_PARTY_CONT_V`	Lists all Party Contacts
`OKS_ENT_REACT_TIME_H_V`	Lists all Reaction time header informations.
`OKS_ENT_REACT_TIME_L_V`	Lists all Reaction time detail informations.
`OKS_ENT_TXN_GROUPS_V`	List of transaction groups covered under coverage.
`OKS_EVENTS_V`	View for Service Contracts Events
`OKS_EXPIRED_CONTRACTS_V`	View for Expired COntracts
`OKS_HEADERS_V`	View is Used for Contracts Quote Printing
`OKS_HEADER_DETAILS_V`	Service contracts header details view
`OKS_INSTANCE_HISTORY_V`
`OKS_INST_HIST_DETAILS_V`
`OKS_INST_HIST_V`
`OKS_INTERACTION_HIST_V`	View on top oks_interaction_history
`OKS_INV_RVW_V`	View for Invoice reporting
`OKS_ITEM_SPLIT_V`	Used to store the details of the item before and after split
`OKS_K_CATEGORIES_V`	This view is created for the object type OKS_K_CATEGORY used for the update level attribute in Mass change.
`OKS_K_DEFAULTS_V`	This table is used to hold default values used when renewing a service contract or when creating a service contract from an order.The defaul
`OKS_K_DETAIL_V`	view for contracts detail form
`OKS_K_GROUPS_V`	This view is created for the object type OKS_K_GROUP used for the update level attribute in Mass change.
`OKS_K_HEADERS_HV`	Service Contracts Header Attributes History
`OKS_K_HEADERS_V`	Service Contracts Header Attributes
`OKS_K_LINES_HV`	Service Contracts Line Attributes History
`OKS_K_LINES_V`	Service Contracts Line Attributes
`OKS_K_ORDER_CONTACTS_V`	view for Order contacts
`OKS_K_ORDER_DETAILS_V`	view for Contract details
`OKS_K_SALES_CREDITS_V`	view for service sales credits
`OKS_LEVEL_ELEMENTS_V`	This View Is used to Store Billing Schedule Infomation for Lines
`OKS_LINES_V`	View is Used for Contracts Quote Printing
`OKS_LINE_DETAILS_V`
`OKS_MASSCHANGE_CRITERIA_V`	This view is used in Masschange UI to avoid the co mplexity in coding and querying purposes
`OKS_MSCHG_OPERATIONS_DTLS_V`	This is the view for OKS_MSCHG_OPERATIONS_DTLS
`OKS_NOTE_SOURCES_V`	View for Service Contract Note Sources.
`OKS_ORDER_V`	view for contract details
`OKS_PARTIES_V`	View for Selecing Parties in reports
`OKS_PMA_V`	This view displays all the activities (rules) selected in contracts. This view is only to be used for the forms UI development.
`OKS_PML_V`	This view will be used by the PM schedule form to display PM schedule stream level information.
`OKS_PM_ACTIVITIES_V`	PM Activities View
`OKS_PM_PROGRAM_V`	This view will be used by the PM schedule form to display PM program rule information.
`OKS_PM_SCHEDULES_V`	This view will be used by the PM schedule form to display PM schedules.
`OKS_PM_STREAM_LEVELS_V`
`OKS_PRICE_BREAKS_HIST_V`	View used in Billing form to display the Details of usage billing
`OKS_PRICE_BREAKS_V`	Service Contracts Price Breaks View
`OKS_PRODUCTS_V`	View is Used for Contracts Quote Printing
`OKS_PRODUCT_DETAILS_V`	This View is Used to show the product details with installation details and the pricing attributes
`OKS_PROD_DETAILS_V`	Service contracts product details view.
`OKS_QUALIFIERS_V`	Used for Pricing Qualifier setup for Service Authoring
`OKS_REACTION_TIMES_HV`	History View for Coverage Reaction Times
`OKS_REACTION_TIMES_V`	View for Reaction Times for Service Coverage
`OKS_REPNAME_V`	This View is Used for Service Contracts Summary Report
`OKS_REPORT_TEMPLATES_V`	This view is used to show the xslt report templates for electronic renewal.
`OKS_REPROCESSING_V`
`OKS_REP_V`	View To Display Sales Reps in Parameters
`OKS_RESOURCES_HV`	History View for Coverage Resources
`OKS_RESOURCES_V`	View for Preferred Resources for Service Contracts Coverages
`OKS_RESOURCE_GROUPS_V`	View for Resource Groups for Service Contracts Coverages
`OKS_REV_DISTRIBUTIONS_V`	View based on the table OKS_REV_DISTRIBUTIONS
`OKS_RULES_V`	This View is used to define an Object meta data in Jtf.
`OKS_SERVICE_COV_TEMPLTS_V`	THIS VIEW DISPLAYS ALL THE COVERAGE TEMPLATES USED IN OKS
`OKS_SERV_AVAILS_V`	View based on OKS_SERV_AVAILS table
`OKS_SERV_AVAIL_EXCEPTS_V`	View for table OKS_SERVICE_AVAILABILITIES
`OKS_SERV_CUSTEXC_V`	View for Service Availability Exceptions and Parties
`OKS_SERV_HDR_V`	View for Service Items
`OKS_SERV_PRODEXC_V`	View for Service Product exceptions
`OKS_STREAM_LEVELS_V`	Billing Stream Levels
`OKS_STREAM_V`	This View is used to define an Object meta data in Jtf.
`OKS_STRM_TYPE_V`	Specifies what the stream is for. A stream may be a + or - cashflow.
`OKS_SUBSCR_ELEMENTS_V`	View for the table subscription elements
`OKS_SUBSCR_HEADER_V`	View for the table subscription header
`OKS_SUBSCR_PATTERNS_V`	View for the table subscription patterns
`OKS_TEMPLATE_COUNTERS_V`	View for Service Contracts Counter Templates
`OKS_TEMPLATE_SET_V`	View on top of oks_template_set
`OKS_TIMEVALUES_V`	This View is used to define an Object meta data in Jtf.
`OKS_TIME_CODE_UNITS_V`	This View is used to define an Object meta data in Jtf.
`OKS_USAGE_COUNTERS_V`	View for Usage Counters for Service Contracts
`OKS_USAGE_ITEM_V`	View for Usage LOV