合約相關表
SELECT Okv.Variable_Value
FROM Okc_Bus_Variables_Tl Obt,
Okc_k_Art_Variables Okv,
Okc_k_Articles_b Oka
WHERE Oka.Id = Okv.Cat_Id
AND Okv.Variable_Code = Obt.Variable_Code
AND Oka.Document_Type = p_Document_Type
AND Oka.Document_Id = p_Document_Id
--and Obt.Variable_Name = p_Variable_Code
AND Obt.LANGUAGE = Userenv('LANG')
AND Okv.Variable_Value IS NOT NULL;
OKC_ACTIONS_B
OKC_ACTIONS_TL
OKC_ACTION_ATTRIBUTES_B
OKC_ACTION_ATTRIBUTES_TL
OKC_ACTION_ATT_LOOKUPS
OKC_ACTION_ATT_VALS
OKC_ALLOWED_TMPL_USAGES
OKC_ANCESTRYS
OKC_APP_FUNCTION_ACCESSES
OKC_AQERRORS
OKC_AQMSGSTACKS
OKC_ARTICLES_ALL
OKC_ARTICLE_ADOPTIONS
OKC_ARTICLE_RELATNS_ALL
OKC_ARTICLE_TRANS
OKC_ARTICLE_TRANS_H
OKC_ARTICLE_VARIABLES
OKC_ARTICLE_VERSIONS
OKC_ART_INTERFACE_ALL
OKC_ART_INT_BATPROCS_ALL
OKC_ART_INT_ERRORS
OKC_ASSENTS
OKC_BUS_DOC_EVENTS_B
OKC_BUS_DOC_EVENTS_TL
OKC_BUS_DOC_TYPES_B
OKC_BUS_DOC_TYPES_TL
OKC_BUS_VARIABLES_B
OKC_BUS_VARIABLES_TL
OKC_CHANGES_B
OKC_CHANGES_TL
OKC_CHANGE_PARTY_ROLE
OKC_CHANGE_REQUESTS_B
OKC_CHANGE_REQUESTS_TL
OKC_CLASSES_B
OKC_CLASSES_TL
OKC_CLASS_OPERATIONS
OKC_CONC_REQUESTS
OKC_CONDITION_HEADERS_B
OKC_CONDITION_HEADERS_BH
OKC_CONDITION_HEADERS_TL
OKC_CONDITION_HEADERS_TLH
OKC_CONDITION_LINES_B
OKC_CONDITION_LINES_BH
OKC_CONDITION_LINES_TL
OKC_CONDITION_LINES_TLH
OKC_CONDITION_OCCURS
OKC_CONTACTS
OKC_CONTACTS_H
OKC_CONTACT_SOURCES
OKC_CONTRACT_DOCS
OKC_CONTRACT_RISKS
OKC_COVER_TIMES
OKC_COVER_TIMES_H
OKC_CR_K_ACCESSES
OKC_DELIVERABLES
OKC_DELIVERABLE_TYPES_B
OKC_DELIVERABLE_TYPES_TL
OKC_DEL_BUS_DOC_COMBXNS
OKC_DEL_MESSAGES
OKC_DEL_RESP_ATTRIBUTES
OKC_DEL_RESP_PARTIES_B
OKC_DEL_RESP_PARTIES_TL
OKC_DEL_STATUS_COMBXNS
OKC_DEL_STATUS_HISTORY
OKC_DOC_QA_LISTS
OKC_EXPRT_IMPORT_REFS
OKC_EXPRT_TEST_T
OKC_FOLDERS_ALL_B
OKC_FOLDERS_ALL_TL
OKC_FOLDER_CONTENTS
OKC_FUNCTION_EXPR_PARAMS
OKC_FUNCTION_EXPR_PARAMS_H
OKC_GOVERNANCES
OKC_GOVERNANCES_H
OKC_INCLUDED_OPERATIONS
OKC_ITEM_PARTYS_B
OKC_ITEM_PARTYS_BH
OKC_ITEM_PARTYS_TL
OKC_ITEM_PARTYS_TLH
OKC_KEXP_REPORT
OKC_K_ACCESSES
OKC_K_ACCESSES_H
OKC_K_ARTICLES_B
OKC_K_ARTICLES_BH
OKC_K_ARTICLES_TL
OKC_K_ARTICLES_TLH
OKC_K_ART_VARIABLES
OKC_K_ART_VARIABLES_H
OKC_K_GROUPS_B
OKC_K_GROUPS_TL
OKC_K_GRPINGS
OKC_K_HEADERS_B
OKC_K_HEADERS_BH
OKC_K_HEADERS_TL
OKC_K_HEADERS_TLH
OKC_K_HISTORY_B
OKC_K_HISTORY_TL
OKC_K_ITEMS
OKC_K_ITEMS_H
OKC_K_LINES_B
OKC_K_LINES_BH
OKC_K_LINES_TL
OKC_K_LINES_TLH
OKC_K_PARTY_ROLES_B
OKC_K_PARTY_ROLES_BH
OKC_K_PARTY_ROLES_TL
OKC_K_PARTY_ROLES_TLH
OKC_K_PROCESSES
OKC_K_PROCESSES_H
OKC_K_REL_OBJS
OKC_K_SALES_CREDITS
OKC_K_SALES_CREDITS_H
OKC_K_SEQ_HEADER
OKC_K_SEQ_LINES
OKC_K_VERS_NUMBERS
OKC_K_VERS_NUMBERS_H
OKC_LINE_STYLES_B
OKC_LINE_STYLES_TL
OKC_LINE_STYLE_ROLES
OKC_LINE_STYLE_SOURCES
OKC_LSE_RULE_GROUPS
OKC_MASSCHANGE_REQ_DTLS
OKC_NUMBER_SCHEMES_B
OKC_NUMBER_SCHEMES_TL
OKC_NUMBER_SCHEME_DTLS
OKC_OPERATIONS_B
OKC_OPERATIONS_TL
OKC_OPERATION_INSTANCES
OKC_OPERATION_LINES
OKC_OUTCOMES_B
OKC_OUTCOMES_BH
OKC_OUTCOMES_TL
OKC_OUTCOMES_TLH
OKC_OUTCOME_ARGUMENTS
OKC_OUTCOME_ARGUMENTS_H
OKC_PH_LINE_BREAKS
OKC_PH_LINE_BREAKS_H
OKC_PRICE_ADJUSTMENTS
OKC_PRICE_ADJUSTMENTS_H
OKC_PRICE_ADJ_ASSOCS
OKC_PRICE_ADJ_ASSOCS_H
OKC_PRICE_ADJ_ATTRIBS
OKC_PRICE_ADJ_ATTRIBS_H
OKC_PRICE_ATT_VALUES
OKC_PRICE_ATT_VALUES_H
OKC_PROCESS_DEFS_B
OKC_PROCESS_DEFS_TL
OKC_PROCESS_DEF_PARMS_B
OKC_PROCESS_DEF_PARMS_TL
OKC_QA_CHECK_LISTS_B
OKC_QA_CHECK_LISTS_TL
OKC_QA_ERRORS_T
OKC_QA_LIST_PROCESSES
OKC_QA_PROCESS_PARMS
OKC_QP_UPGRADE
OKC_REACT_INTERVALS
OKC_REACT_INTERVALS_H
OKC_REPORT_HTM
OKC_REPORT_PRM_B
OKC_REPORT_PRM_TL
OKC_REPORT_SQL_B
OKC_REPORT_SQL_TL
OKC_REPORT_TAG_B
OKC_REPORT_TAG_TL
OKC_REPORT_XML
OKC_REPORT_XSL_B
OKC_REPORT_XSL_TL
OKC_REPORT_XST
OKC_REP_BOOKMARKS
OKC_REP_CONTACT_ROLES_B
OKC_REP_CONTACT_ROLES_TL
OKC_REP_CONTRACTS_ALL
OKC_REP_CONTRACT_ACCESS
OKC_REP_CONTRACT_PARTIES
OKC_REP_CONTRACT_RELS
OKC_REP_CONTRACT_VERS
OKC_REP_CON_ARROVALS
OKC_REP_CON_STATUS_HIST
OKC_REP_INTENT_PARTY
OKC_REP_PARTY_CONTACTS
OKC_REP_RELATIONSHIPS_B
OKC_REP_RELATIONSHIPS_TL
OKC_RESOLVED_TIMEVALUES
OKC_RG_DEF_RULES
OKC_RG_PARTY_ROLES
OKC_RG_PARTY_ROLES_H
OKC_RG_ROLE_DEFS
OKC_RISK_EVENTS_B
OKC_RISK_EVENTS_TL
OKC_ROLES_B
OKC_ROLES_TL
OKC_ROLE_SOURCES
OKC_RULES_B
OKC_RULES_BH
OKC_RULES_TL
OKC_RULES_TLH
OKC_RULE_DEFS_B
OKC_RULE_DEFS_TL
OKC_RULE_DEF_SOURCES
OKC_RULE_GROUPS_B
OKC_RULE_GROUPS_BH
OKC_RULE_GROUPS_TL
OKC_RULE_GROUPS_TLH
OKC_SECTIONS_B
OKC_SECTIONS_BH
OKC_SECTIONS_TL
OKC_SECTIONS_TLH
OKC_SECTION_CONTENTS
OKC_SECTION_CONTENTS_H
OKC_SPAN
OKC_STATUSES_B
OKC_STATUSES_TL
OKC_STD_ARTICLES_B
OKC_STD_ARTICLES_TL
OKC_STD_ART_CLASSINGS
OKC_STD_ART_INCMPTS
OKC_STD_ART_SET_MEMS
OKC_STD_ART_VERSIONS_B
OKC_STD_ART_VERSIONS_TL
OKC_SUBCLASSES_B
OKC_SUBCLASSES_TL
OKC_SUBCLASS_RESPS
OKC_SUBCLASS_RG_DEFS
OKC_SUBCLASS_ROLES
OKC_SUBCLASS_TOP_LINE
OKC_SUBJECT_GROUPS
OKC_TEMPLATE_USAGES
OKC_TEMPLATE_USAGES_H
OKC_TEMP_QA_RESULTS
OKC_TERMS_TEMPLATES_ALL
OKC_TIMEVALUES
OKC_TIMEVALUES_B
OKC_TIMEVALUES_BH
OKC_TIMEVALUES_H
OKC_TIMEVALUES_TL
OKC_TIMEVALUES_TLH
OKC_TIME_CODE_UNITS_B
OKC_TIME_CODE_UNITS_TL
OKC_TMPL_DRAFT_CLAUSES
OKC_USER_BINS
OKC_USER_HOOK_CALLS
OKC_USER_HOOK_CALLS_H
OKC_VAL_LINE_OPERATIONS
OKC_VARIABLE_DOC_TYPES
OKC_XPRT_QUESTIONS_B
OKC_XPRT_QUESTIONS_TL
OKC_XPRT_QUESTION_ORDERS
OKC_XPRT_RULE_CONDITIONS
OKC_XPRT_RULE_COND_VALS
OKC_XPRT_RULE_HDRS_ALL
OKC_XPRT_RULE_OUTCOMES
OKC_XPRT_TEMPLATE_RULES
