OKC Views (281)

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

View	Description
`OKCAUDET_RULE_GROUPS_HV`	History view for OKCAUDET_RULE_GROUPS.
`OKCAUDET_RULE_GROUPS_V`	View for detailed information on rule groups and rules for a contract
`OKC_ACTIONS_V`	View on tables OKC_ACTIONS_B and OKC_ACTIONS_TL.
`OKC_ACTION_ATTRIBUTES_V`	View based on tables OKC_ACTION_ATTRIBUTES_B and OKC_ACTION_ATTRIBUTES_TL
`OKC_ACTION_ATT_LOOKUPS_V`	View for table OKC_ACTION_ATT_LOOKUPS
`OKC_ACTION_ATT_VALS_V`	View for table OKC_PUB_EVENT_ATT_VALS
`OKC_ALLOWED_TMPL_USAGES_V`
`OKC_ANCESTRYS_V`	View for table OKC_ANCESTRYS
`OKC_AQERRORS_V`	View for table OKC_AQERRORS
`OKC_AQMSGSTACKS_V`	View for table OKC_AQMSGSTACKS
`OKC_ARTICLES_GLOBAL_V`	The View is based on tables OKC_ARTICLES_ALL and OKC_ARTICLE_VERSIONS. Intended to provide information for searching of standard clauses own
`OKC_ARTICLES_LOCAL_V`	The View based on tables OKC_ARTICLES_ALL, OKC_ARTICLE_VERSIONS and OKC_ARTICLE_ADOPTIONS. Intended to provide information for Searching of
`OKC_ARTICLES_V`	This View is based on tables OKC_ARTICLES_ALL and OKC_ARTICLE_VERSIONS.
`OKC_ARTICLE_TRANS_HV`	History view for OKC_ARTICLE_TRANS.
`OKC_ARTICLE_TRANS_V`	View for table OKC_ARTICLE_TRANSLATIONS
`OKC_ART_NON_STANDARDS_V`	View for table OKC_ARTICLES_B
`OKC_ART_SET_NAMES_V`	View created for backward compatibility based on Folders
`OKC_ART_STANDARDS_V`	View for table OKC_ARTICLES_B
`OKC_ART_UNQ_BATCH_V`	View to get unique Batch Number for OKC_ART_INTERFACE_ALL
`OKC_ASSENTS_LOOKUPS_V`
`OKC_ASSENTS_V`	View for table OKC_ASSENTS
`OKC_BUS_DOC_EVENTS_V`	View definition for OKC_BUS_DOC_EVENTS_B and OKC_BUS_DOC_EVENTS_TL
`OKC_BUS_DOC_EVENTS_VL`	View definition for OKC_BUS_DOC_EVENTS_B and OKC_BUS_DOC_EVENTS_TL
`OKC_BUS_DOC_TYPES_V`	business document types view definition
`OKC_BUS_DOC_TYPES_VL`	business document types view definition
`OKC_BUS_VARIABLES_SEARCH_V`	Variables view definition used in Variables Search
`OKC_BUS_VARIABLES_V`	Variables view definition
`OKC_BUS_VARIABLES_VL`	Variables view definition
`OKC_CGP_GRPINGS_V`
`OKC_CHANGES_V`	View for table OKC_CHANGES_B
`OKC_CHANGE_PARTY_ROLE_V`	View for table OKC_CHANGE_PARTY_ROLE
`OKC_CHANGE_REQUESTS_V`	View for table OKC_CHANGE_REQUESTS_B
`OKC_CLASSES_V`	View for table OKC_CLASSES_B
`OKC_CLASS_OPERATIONS_V`
`OKC_CNL_COUNTER_EXPR_V`	View for table OKC_EVENT_DEF_LINES_B
`OKC_CNL_FUNCTION_EXPR_V`	View for table OKC_EVENT_DEF_LINES_B
`OKC_CNL_GENERAL_EXPR_V`	View for table OKC_EVENT_DEF_LINES_B
`OKC_CONDITION_HEADERS_HV`	History view for OKC_CONDITION_HEADERS.
`OKC_CONDITION_HEADERS_V`	View for table OKC_EVENT_DEFS_B
`OKC_CONDITION_LINES_HV`	History view for OKC_CONDITION_LINES.
`OKC_CONDITION_LINES_V`	View for table OKC_EVENT_DEF_LINES_B
`OKC_CONDITION_OCCURS_V`	View for table OKC_CONDITION_OCCURS
`OKC_CONTACTS_HV`	History view for OKC_CONTACTS.
`OKC_CONTACTS_V`	View for table OKC_CONTACTS
`OKC_CONTACT_SOURCES_V`	View for table OKC_CONTACT_SOURCES
`OKC_CONTRACT_DOCS_DETAILS_VL`	This view lists contract attachments belonging to a business document type.
`OKC_CONT_NUM_DISTINCT_V`	This view lists unique contract numbers only.
`OKC_CONVERSION_ATTRIBS_HV`	History view for OKC_CONVERSION_ATTRIBS.
`OKC_CONVERSION_ATTRIBS_V`	View for conversion rules for a contract.
`OKC_COVER_TIMES_HV`	History view for OKC_COVER_TIMES.
`OKC_COVER_TIMES_V`	View for table OKC_COVER_TIMES
`OKC_CR_K_ACCESSES_V`	View for table OKC_CR_K_ACCESSES
`OKC_DELIVERABLES_EXT_VL`
`OKC_DELIVERABLE_TYPES_VL`	View based on OKC_DELIVERABLE_TYPES_B and OKC_DELIVERABLE_TYPES_TL
`OKC_DEL_RESP_PARTIES_V`	View based on OKC_DEL_RESP_PARTIES_B and OKC_DEL_RESP_PARTIES_TL
`OKC_EBIZ_KHEADERS_V`	Find grid for eBusiness Integration
`OKC_FOLDERS_ALL_VL`	Folders View for all Organizations.
`OKC_FOLDERS_VL`	Org striped Folders View.
`OKC_FUNCTION_EXPR_PARAMS_HV`	History view for OKC_FUNCTION_EXPR_PARAMS.
`OKC_FUNCTION_EXPR_PARAMS_V`	View for table OKC_FUNCTION_EXPRESSION_PARAMS
`OKC_GOVERNANCES_HV`	History view for OKC_GOVERNANCES.
`OKC_GOVERNANCES_V`	View for table OKC_GOVERNANCES
`OKC_GOVERNING_CONTRACT_V`	This view contains the hierarchy of the sales contracts. This view has been obsoleted
`OKC_INCLUDED_OPERATIONS_V`	View for table OKC_INCLUDED_OPERATION
`OKC_ITEM_PARTYS_HV`	History view for OKC_ITEM_PARTYS.
`OKC_ITEM_PARTYS_V`	View for table OKC_ITEM_PARTYS_B
`OKC_KEXP_REPORT_V`	This view is registered as a source for the Discoverer Folder and Workbook 'Expired Contracts' . This view is a multiple table joins, primar
`OKC_KOL_ATTACHMENTS_V`
`OKC_KOL_CONTACTS_V`
`OKC_KOL_CREATE_K_HDR_V`	View for table OKC_CONTRACT_HEADERS_B
`OKC_KOL_CURRENCIES_V`	Displays active currency codes that are enabled for use at your site. Any currency code can be selected for a contract creation.
`OKC_KOL_K_ACCESSES_V`	Displays contracts with their related user and/or group resources, as well as their respective access level.
`OKC_KOL_K_ARTICLES_V`
`OKC_KOL_PARTY_ROLES_V`
`OKC_KOL_SEARCH_KHEADERS_V`	Displays all the contracts, with their respective status, category, primary party name and role, and attached documents. Only contracts belo
`OKC_KOL_STD_ART_LATEST_REL_V`
`OKC_KOL_STD_ART_LIB_V`
`OKC_KSRCH_REPORT_V`
`OKC_K_ACCESSES_HV`	History view for OKC_K_ACCESSES.
`OKC_K_ACCESSES_V`	View for table OKC_ACCESS_SECURITYS
`OKC_K_ARTICLES_HV`	History view for OKC_K_ARTICLES.
`OKC_K_ARTICLES_V`	View for table OKC_ARTICLES_B
`OKC_K_ART_VAR_EXT_VL`
`OKC_K_ATE_V`	View to provide the contract using the std articles
`OKC_K_CPS_PDF_HV`	History view for OKC_K_CPS_PDF.
`OKC_K_CPS_PDF_V`	View for detailed information of contract processes.
`OKC_K_GROUPS_GRPINGS_V`
`OKC_K_GROUPS_V`	View for table OKC_CONTRACT_GROUPS_B
`OKC_K_GRPINGS_V`	View for table OKC_CONTRACT_GROUPINGS
`OKC_K_HDR_AGREEDS_V`	View for table OKC_CONTRACT_HEADERS_B
`OKC_K_HEADERS_ALL_HV`
`OKC_K_HEADERS_ALL_V`
`OKC_K_HEADERS_HV`	History view for OKC_K_HEADERS.
`OKC_K_HEADERS_V`	View for table OKC_CONTRACT_HEADERS_B
`OKC_K_HISTORY_V`	View for table OKC_K_HISTORY_B & _TL
`OKC_K_ITEMS_HV`	History view for OKC_K_ITEMS.
`OKC_K_ITEMS_V`	View for table OKC_CONTRACT_ITEMS
`OKC_K_LINES_HV`	History view for OKC_K_LINES.
`OKC_K_LINES_V`	View for table OKC_CONTRACT_LINES_B
`OKC_K_PARTY_ROLES_HV`	History view for OKC_K_PARTY_ROLES.
`OKC_K_PARTY_ROLES_V`	View for table OKC_CONTRACT_PARTY_ROLES_B
`OKC_K_PROCESSES_HV`	History view for OKC_K_PROCESSES.
`OKC_K_PROCESSES_V`	View for table OKC_CONTRACT_PROCESSES
`OKC_K_REL_OBJS_V`	View for table OKC_K_REL_OBJS
`OKC_K_SALES_AGRMNTS_V`	View for the contracts of category Sales Agreement
`OKC_K_SALES_CREDITS_HV`	view for service sales credits history
`OKC_K_SALES_CREDITS_V`	view for service sales credits
`OKC_K_SEQ_HEADER_V`
`OKC_K_SEQ_LINES_V`
`OKC_K_VERS_NUMBERS_V`	View for table OKC_K_VERS_NUMBERS
`OKC_LAUNCH_COMMGRID_V`
`OKC_LAUNCH_HISTORY_GRID_V`	View for Launchpad History Tab
`OKC_LAUNCH_KGRID_V`	View for Main Launchpad Grid
`OKC_LAUNCH_KHIST_GRID_V`	View for Launchpad overview tab - contract status change history
`OKC_LAUNCH_LGRID_V`	View for Launchpad overview tab - contract lines
`OKC_LAUNCH_TASKGRID_V`	View for Launchpad schedule tab
`OKC_LAUNCH_WFRESP_ATTR_V`
`OKC_LINES_INDEX_V`	Treewalk lines index view
`OKC_LINE_STYLES_V`	View for table OKC_LINE_STYLE_B
`OKC_LINE_STYLE_ROLES_V`	View for table OKC_LINE_STYLE_ROLES
`OKC_LINE_STYLE_SOURCES_V`	View for table OKC_LINE_STYLE_SOURCES
`OKC_LOOKUPS_V`	OKC Lookups view on top of FND_LOOKUP_VALUES
`OKC_LSE_RULE_GROUPS_V`	View for table OKC_LSE_RULE_GROUPS
`OKC_MASSCHANGE_REQ_DTLS_V`
`OKC_NUMBER_SCHEMES_V`	Numbering scheme view
`OKC_NUMBER_SCHEMES_VL`	View name for the numbering scheme VO
`OKC_OPERATIONS_V`	View for table OKC_OPERATIONS_B
`OKC_OPERATION_INSTANCES_V`
`OKC_OPERATION_LINES_V`
`OKC_OUTCOMES_HV`	History view for OKC_OUTCOMES.
`OKC_OUTCOMES_V`	View based on tables OKC_OUTCOMES_B, OKC_OUTCOMES_TL
`OKC_OUTCOME_ARGUMENTS_HV`	History view for OKC_OUTCOME_ARGUMENTS.
`OKC_OUTCOME_ARGUMENTS_V`	View for table OKC_OUTCOME_ARGUMENTS
`OKC_PH_LINE_BREAKS_HV`	View for table OKC_PH_LINE_BREAKS_H - Not Used
`OKC_PH_LINE_BREAKS_V`	View for table OKC_PH_LINE_BREAKS - Not Used
`OKC_PRICE_ADJUSTMENTS_HV`
`OKC_PRICE_ADJUSTMENTS_V`	View for table OKC_PRICE_ADJUSTMENTS
`OKC_PRICE_ADJ_ASSOCS_HV`
`OKC_PRICE_ADJ_ASSOCS_V`	View for table OKC_PRICE_ADJ_ASSOCS
`OKC_PRICE_ADJ_ATTRIBS_HV`
`OKC_PRICE_ADJ_ATTRIBS_V`	View for table OKC_PRICE_ADJ_ATTRIBS
`OKC_PRICE_ATT_VALUES_HV`
`OKC_PRICE_ATT_VALUES_V`	View for table OKC_PRICE_ATT_VALUES
`OKC_PROCESS_DEFS_V`	View based on tables OKC_PROCESS_DEFS_B and OKC_PROCESS_DEFS_TL.
`OKC_PROCESS_DEF_FUNCTION_V`	Subtype view for Process Definitions - Functions
`OKC_PROCESS_DEF_OUTCOME_V`	Subtype view for Process Definitions - Outcomes
`OKC_PROCESS_DEF_PARAMETERS_V`	View based on tables OKC_PROCESS_DEF_PARAMETERS_B and OKC_PROCESS_DEF_PARAMETERS_TL.
`OKC_QA_CHECK_LISTS_V`	View for table OKC_QA_CHECK_LISTS_B
`OKC_QA_LIST_PROCESSES_V`	View for table OKC_QA_LIST_PROCESSES
`OKC_QA_PROCESS_PARMS_V`	View for table OKC_QA_LIST_PROCESS_PARMS
`OKC_QUE_ERROR_CNT_V`
`OKC_QUE_ERROR_TEXT_V`
`OKC_QUE_LSNR_V`
`OKC_QUE_NAMES_V`
`OKC_QUE_OBJECTS_V`
`OKC_QUE_RULES_V`
`OKC_QUE_SUBSCRIBERS_V`
`OKC_QUE_WF_V`
`OKC_REACT_INTERVALS_HV`	History view for OKC_REACT_INTERVALS.
`OKC_REACT_INTERVALS_V`	View for table OKC_REACTION_INTERVALS
`OKC_REL_OBJECTS_V`
`OKC_REL_OBJ_OPP_HEADERS_V`
`OKC_REL_OBJ_OPP_LINES_V`
`OKC_REL_OBJ_ORDER_HEADERS_V`
`OKC_REL_OBJ_ORDER_LINES_V`
`OKC_REL_OBJ_PO_HEADERS_V`
`OKC_REL_OBJ_PO_LINES_V`
`OKC_REL_OBJ_PO_REQ_HEADERS_V`
`OKC_REL_OBJ_PO_REQ_LINES_V`
`OKC_REL_OBJ_QUOTE_HEADERS_V`
`OKC_REL_OBJ_QUOTE_LINES_V`
`OKC_REPORT_HTM_V`	Used in Contract Printing. Keeps html presentation of the contract.
`OKC_REPORT_PRM_V`	Used in Contract Printing. Keeps report parameters definitions.
`OKC_REPORT_SQL_V`	Used in Contract Printing. Keeps query and help text for XSL writer.
`OKC_REPORT_TAG_V`	Used in Contract Printing. Keeps published tags.Prior to 11.5.9 tags published in help tab.
`OKC_REPORT_XML_V`	Used in Contract Printing. Keeps xml copy of the contract produced with XSUtility.
`OKC_REPORT_XSL_V`	Used in Contract Printing. Keeps stylesheet for sql-xml-xsl-html contract printing.
`OKC_REPORT_XST_V`	Used in Contract Printing. Keeps (query, stylesheet) combinations that drive contract printing.
`OKC_REP_CONTACT_ROLES_VL`	VL view on OKC_REP_CONTACT_ROLES_B and OKC_REP_CONTACT_ROLES_TL tables.
`OKC_REP_CONTRACTS_ALL_EXT_VL`
`OKC_REP_CONTRACT_VERS_EXT_VL`
`OKC_REP_DOC_VERSIONS_V`	This view returns repository contract versions
`OKC_REP_RELATIONSHIPS_VL`	VL view on OKC_REP_RELATIONSHIP_B and OKC_REP_RELATIONSHIP_TL tables.
`OKC_RESOLVED_TIMEVALUES_V`	View for table OKC_RESOLVED_TIMEVALUES
`OKC_RESOURCE_GROUPS_V`	View for resource groups of role Contracts
`OKC_RESOURCE_USERS_V`
`OKC_RESP_PARTIES_VL`	View based on OKC_RESP_PARTIES_B and OKC_RESP_PARTIES_TL
`OKC_RG_BLK_HV`
`OKC_RG_BLK_V`
`OKC_RG_DEF_RULES_V`	View for table OKC_RG_DEF_RULES
`OKC_RG_PARTIES_BLK_HV`
`OKC_RG_PARTIES_BLK_V`
`OKC_RG_PARTIES_LOV_V`
`OKC_RG_PARTY_ROLES_HV`	History view for OKC_RG_PARTY_ROLES.
`OKC_RG_PARTY_ROLES_V`	View for table OKC_RG_MODE_PTY_ROLES
`OKC_RG_ROLE_DEFS_V`	View for table OKC_RG_MODE_DEFS_B
`OKC_RISK_EVENTS_VL`	VL view on OKC_RISK_EVENTS_B and OKC_RISK_EVENTS_TL tables.
`OKC_ROLES_V`
`OKC_ROLE_SOURCES_V`	View for table OKC_ROLE_SOURCES
`OKC_RULES1_BLK_HV`
`OKC_RULES1_BLK_V`
`OKC_RULES2_BLK_V`
`OKC_RULES_HV`	History view for OKC_RULES.
`OKC_RULES_V`	View for table OKC_RULES_B
`OKC_RULE_ATTS_BLK_V`
`OKC_RULE_DEFS_V`	This view displays the rule definitions.
`OKC_RULE_DEF_RG_RULE_DEFS_V`
`OKC_RULE_DEF_SOURCES_V`	View for table OKC_RULE_DEF_SOURCES
`OKC_RULE_GROUPS_HV`	History view for OKC_RULE_GROUPS.
`OKC_RULE_GROUPS_V`	View for table OKC_RULE_GROUPS_B
`OKC_SAE_INCMPT_V`	View for incompatible standard articles
`OKC_SALES_TEMPLATES_V`
`OKC_SCS_LINE_STYLE_ROLES_V`	View for roles assigned to linestyles and categories
`OKC_SCS_LSE_RULE_GROUPS_V`	View for rule groups assigned to linestyles and categorie
`OKC_SEARCH_KHEADERS_V`	Find grid for Contract Search Screen
`OKC_SECTIONED_ARTICLES_V`	Used to get articles text from CLOBs
`OKC_SECTIONS_HV`
`OKC_SECTIONS_INDEX_V`	Treewalk sections index provider
`OKC_SECTIONS_V`
`OKC_SECTION_CONTENTS_HV`
`OKC_SECTION_CONTENTS_V`
`OKC_SPAN_V`	View for table OKC_SPAN
`OKC_SRS_REN_CONTRACT_NUM_V`
`OKC_STATUSES_V`	View for table OKC_STATUSES_B
`OKC_STD_ARTICLES_V`	Backward compatible View for table OKC_ARTICLES_ALL
`OKC_STD_ART_CLASSINGS_V`	View for table OKC_STD_ART_CLASSINGS
`OKC_STD_ART_INCMPTS_V`	View for table OKC_STD_ART_INCMPTS
`OKC_STD_ART_LOOKUP_V`	Standard Articles View
`OKC_STD_ART_SET_MEMS_V`	View for table OKC_STD_ART_SET_MEMBERS
`OKC_STD_ART_VERSIONS_V`	View for table OKC_STD_ARTICLE_VERSIONS_B
`OKC_SUBCLASSES_V`	View for table OKC_SUB_CLASSES_B
`OKC_SUBCLASS_RESPS_V`	View for table OKC_RESP_ACCESSES
`OKC_SUBCLASS_RG_DEFS_V`	View for table OKC_SUBCLASS_RULEGROUP_DEFS
`OKC_SUBCLASS_ROLES_V`	View for table OKC_SUBCLASS_ROLES
`OKC_SUBCLASS_TOP_LINE_V`	View for table OKC_SUB_CLASS_TOP_LINE
`OKC_SUBJECT_GROUPS_V`	View for table OKC_SUBJECT_GROUPS
`OKC_TEMPLATE_USAGES_V`
`OKC_TERMS_ADD_VARIABL_V`
`OKC_TERMS_ALTERNATE_ART_V`
`OKC_TERMS_ARTICLES_HV`
`OKC_TERMS_ARTICLES_V`
`OKC_TERMS_ART_DETAILS_V`
`OKC_TERMS_ART_VERSIONS_V`
`OKC_TERMS_DOC_LATEST_ART_V`
`OKC_TERMS_GLOBAL_VAR_V`
`OKC_TERMS_LOCAL_VAR_V`
`OKC_TERMS_PREVIEW_V`
`OKC_TERMS_SECTIONS_HV`
`OKC_TERMS_SECTIONS_V`
`OKC_TERMS_STRUCTURE_V`
`OKC_TERMS_TEMPLATES`
`OKC_TERMS_VAR_VALUES_V`
`OKC_TIMEUNIT_V`
`OKC_TIMEVALUES_HV`	History view for OKC_TIMEVALUES.
`OKC_TIMEVALUES_V`	View for table OKC_TIMEVALUES
`OKC_TIME_CODE_UNITS_V`	View for table OKC_TIME_CODE_UNITS_B
`OKC_TIME_CYCLE_SPAN_V`	View over timevalue and span
`OKC_TIME_CYCLE_V`	View for table OKC_TIMEVALUES
`OKC_TIME_IA_STARTEND_REL_V`	View for Time - Relative Start End
`OKC_TIME_IA_STARTEND_V`	View for table OKC_TIMEVALUES
`OKC_TIME_IA_STARTEND_VAL_V`	View for Time - Absolute Start End
`OKC_TIME_IG_NAMED_V`	View for table OKC_TIMEVALUES
`OKC_TIME_IG_STARTEND_V`	View for table OKC_TIMEVALUES
`OKC_TIME_IG_STARTEND_VAL_V`	View for Time - Generic Start End
`OKC_TIME_RELATED_TO_EVENT_V`	View for event based Time
`OKC_TIME_TPA_RELATIVE_V`	View for table OKC_TIMEVALUES
`OKC_TIME_TPA_VALUE_V`	View for table OKC_TIMEVALUES
`OKC_TIME_TPG_DELIMITED_V`	View for table OKC_TIMEVALUES
`OKC_TIME_TPG_NAMED_V`	View for table OKC_TIMEVALUES
`OKC_USER_BINS_V`	View for Table OKC_USER_BINS
`OKC_USER_HOOK_CALLS_V`	View for table OKC_USER_HOOK_CALLS
`OKC_USER_HOOK_PDF_V`	View for Process Defs and User Hook Calls
`OKC_VAL_LINE_OPERATIONS_V`	View for table OKC_VAL_LINE_OPERATIONS
`OKC_WEB_REPORT_PROF_V`	Used to set OKC_WEB_REPORT profile option
`OKC_XPRT_BUS_VARIABLES_V`	View for contract expert business variables
`OKC_XPRT_QUESTIONS_VL`	Contract Expert questions view.
`OKC_XPRT_RULE_COND_ACTIVE_V`
`OKC_XPRT_RULE_COND_VALS_ACT_V`
`OKC_XPRT_RULE_DEPENDENCIES_V`
`OKC_XPRT_RULE_HDRS_ALL_V`
`OKC_XPRT_RULE_OUTCOMES_ACT_V`