Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - OKS Tables and Views

TABLE - OKS.OKS_ACTION_TIMES
TABLE - OKS.OKS_ACTION_TIME_TYPES
TABLE - OKS.OKS_BCL_PR
TABLE - OKS.OKS_BILLING_HIST_INT_ALL
TABLE - OKS.OKS_BILLING_PROFILES_B
TABLE - OKS.OKS_BILLING_PROFILES_TL
TABLE - OKS.OKS_BILLRATE_SCHEDULES
TABLE - OKS.OKS_BILL_CONT_LINES
TABLE - OKS.OKS_BILL_SUB_LINES
TABLE - OKS.OKS_BILL_SUB_LINE_DTLS
TABLE - OKS.OKS_BILL_TRANSACTIONS
TABLE - OKS.OKS_BILL_TXN_LINES
TABLE - OKS.OKS_BSD_PR
TABLE - OKS.OKS_BSL_PR
TABLE - OKS.OKS_BTL_PR
TABLE - OKS.OKS_BTN_PR
TABLE - OKS.OKS_CON_COV_LEVELS_INT_ALL
TABLE - OKS.OKS_CON_ERRORS_INT_ALL
TABLE - OKS.OKS_CON_HEADERS_INT_ALL
TABLE - OKS.OKS_CON_LINES_INT_ALL
TABLE - OKS.OKS_COVERAGES_INT_ALL
TABLE - OKS.OKS_COVERAGE_TIMES
TABLE - OKS.OKS_COVERAGE_TIMEZONES
TABLE - OKS.OKS_COVERED_ACCOUNT_STG_TEMP
TABLE - OKS.OKS_COVERED_INSTANCE_STG_TEMP
TABLE - OKS.OKS_COVERED_ITEM_STG_TEMP
TABLE - OKS.OKS_COVERED_PARTY_STG_TEMP
TABLE - OKS.OKS_COVERED_SITE_STG_TEMP
TABLE - OKS.OKS_COVERED_SYSTEM_STG_TEMP
TABLE - OKS.OKS_COV_BILL_RATES_INT_ALL
TABLE - OKS.OKS_COV_BILL_TYPES_INT_ALL
TABLE - OKS.OKS_COV_TXN_GROUPS_INT_ALL
TABLE - OKS.OKS_COV_TYPES_B
TABLE - OKS.OKS_COV_TYPES_TL
TABLE - OKS.OKS_DA_INTERFACE_B
TABLE - OKS.OKS_INSTANCE_CONTRACTS_TEMP
TABLE - OKS.OKS_INSTANCE_HISTORY
TABLE - OKS.OKS_INSTANCE_K_DTLS_TEMP
TABLE - OKS.OKS_INST_HIST_DETAILS
TABLE - OKS.OKS_INTERACTION_HISTORY
TABLE - OKS.OKS_INT_COVERED_LEVEL_STG_TEMP
TABLE - OKS.OKS_INT_ERROR_STG_TEMP
TABLE - OKS.OKS_INT_HEADER_STG_TEMP
TABLE - OKS.OKS_INT_LINE_STG_TEMP
TABLE - OKS.OKS_INT_SALES_CREDIT_STG_TEMP
TABLE - OKS.OKS_INT_USAGE_COUNTER_STG_TEMP
TABLE - OKS.OKS_JTF_RES_TEMP
TABLE - OKS.OKS_K_DEFAULTS
TABLE - OKS.OKS_K_HEADERS_B
TABLE - OKS.OKS_K_HEADERS_BH
TABLE - OKS.OKS_K_LINES_B
TABLE - OKS.OKS_K_LINES_BH
TABLE - OKS.OKS_K_LINES_TL
TABLE - OKS.OKS_K_LINES_TLH
TABLE - OKS.OKS_K_ORDER_CONTACTS
TABLE - OKS.OKS_K_ORDER_DETAILS
TABLE - OKS.OKS_K_RES_TEMP
TABLE - OKS.OKS_K_SALES_CREDITS
TABLE - OKS.OKS_LEVEL_ELEMENTS
TABLE - OKS.OKS_MSCHG_OPERATIONS_DTLS
TABLE - OKS.OKS_PM_ACTIVITIES
TABLE - OKS.OKS_PM_SCHEDULES
TABLE - OKS.OKS_PM_STREAM_LEVELS
TABLE - OKS.OKS_PROCESS_CONTROL
TABLE - OKS.OKS_QUALIFIERS
TABLE - OKS.OKS_REPORT_TEMPLATES
TABLE - OKS.OKS_REPROCESSING
TABLE - OKS.OKS_REV_DISTRIBUTIONS
TABLE - OKS.OKS_RULES_DFF
TABLE - OKS.OKS_SERV_AVAILS
TABLE - OKS.OKS_SERV_AVAIL_EXCEPTS
TABLE - OKS.OKS_STATUS_FORECAST
TABLE - OKS.OKS_STREAM_LEVELS_B
TABLE - OKS.OKS_STRM_TYPE
TABLE - OKS.OKS_SUBSCR_ELEMENTS
TABLE - OKS.OKS_SUBSCR_HEADER_B
TABLE - OKS.OKS_SUBSCR_HEADER_TL
TABLE - OKS.OKS_SUBSCR_PATTERNS
TABLE - OKS.OKS_TEMPLATE_SET
TABLE - OKS.OKS_USG_QP_CALL_TBL
VIEW - APPS.OKS_ACTION_TIMES_V
VIEW - APPS.OKS_ACTION_TIME_TYPES_V
VIEW - APPS.OKS_APPROVED_CONTRACTS_V
VIEW - APPS.OKS_AUTH_HEADERS_HV
VIEW - APPS.OKS_AUTH_HEADERS_V
VIEW - APPS.OKS_AUTH_LINES_HV
VIEW - APPS.OKS_AUTH_LINES_V
VIEW - APPS.OKS_AUTH_SHOWALL_PROD_V
VIEW - APPS.OKS_BCL_PR_V
VIEW - APPS.OKS_BILLING_DTLS_V
VIEW - APPS.OKS_BILLING_HISTORY_V
VIEW - APPS.OKS_BILLING_HIST_LINES_V
VIEW - APPS.OKS_BILLING_HIST_V
VIEW - APPS.OKS_BILLING_PROFILES_V
VIEW - APPS.OKS_BILLPRST_SRVLINE_V
VIEW - APPS.OKS_BILLPRST_SRVSUBLINE_V
VIEW - APPS.OKS_BILLPRST_SUBSCRLINE_V
VIEW - APPS.OKS_BILLPRST_USGDRILL_V
VIEW - APPS.OKS_BILLPRST_USGSUBLINE_V
VIEW - APPS.OKS_BILLRATE_SCHEDULES_V
VIEW - APPS.OKS_BILL_CONT_LINES_V
VIEW - APPS.OKS_BILL_SUBLINE_DTLS_V
VIEW - APPS.OKS_BILL_SUB_LINES_V
VIEW - APPS.OKS_BILL_TRANSACTIONS_V
VIEW - APPS.OKS_BILL_TXN_LINES_V
VIEW - APPS.OKS_BSD_PR_V
VIEW - APPS.OKS_BSL_PR_V
VIEW - APPS.OKS_BTL_PR_V
VIEW - APPS.OKS_BTN_PR_V
VIEW - APPS.OKS_BUS_PROCESSES_HV
VIEW - APPS.OKS_BUS_PROCESSES_V
VIEW - APPS.OKS_CONTACT_POINTS_V
VIEW - APPS.OKS_CONTACT_V
VIEW - APPS.OKS_CONTRACTS_V
VIEW - APPS.OKS_CONTRACT_DTLS_V
VIEW - APPS.OKS_CONTRACT_MODIFIER_V
VIEW - APPS.OKS_CONTRACT_NUMBER_V
VIEW - APPS.OKS_CONTRACT_PARTIES_V
VIEW - APPS.OKS_CONT_HEADERS_V
VIEW - APPS.OKS_COUNTERS_V
VIEW - APPS.OKS_COVDLEVEL_DETAILS_V
VIEW - APPS.OKS_COVERAGES_HV
VIEW - APPS.OKS_COVERAGES_V
VIEW - APPS.OKS_COVERAGE_TEMPLTS_V
VIEW - APPS.OKS_COVERAGE_TIMES_V
VIEW - APPS.OKS_COVERAGE_TIMEZONES_V
VIEW - APPS.OKS_COVERED_LEVEL_V
VIEW - APPS.OKS_COV_ACTION_TIMES_V
VIEW - APPS.OKS_COV_TYPES_V
VIEW - APPS.OKS_CUST_PRODUCTS_V
VIEW - APPS.OKS_DOCUMENT_VERSIONS_V
VIEW - APPS.OKS_ENT_BILL_RATES_V
VIEW - APPS.OKS_ENT_BILL_TYPES_V
VIEW - APPS.OKS_ENT_COVD_LEVELS_V
VIEW - APPS.OKS_ENT_COVERAGES_V
VIEW - APPS.OKS_ENT_COVER_TIMES_V
VIEW - APPS.OKS_ENT_HDR_SUMMARY_V
VIEW - APPS.OKS_ENT_HEADERS_V
VIEW - APPS.OKS_ENT_K_STATUS_V
VIEW - APPS.OKS_ENT_LINE_DETAILS_V
VIEW - APPS.OKS_ENT_PARTY_CONT_V
VIEW - APPS.OKS_ENT_REACT_TIME_H_V
VIEW - APPS.OKS_ENT_REACT_TIME_L_V
VIEW - APPS.OKS_ENT_TXN_GROUPS_V
VIEW - APPS.OKS_EVENTS_V
VIEW - APPS.OKS_EXPIRED_CONTRACTS_V
VIEW - APPS.OKS_HEADERS_V
VIEW - APPS.OKS_HEADER_DETAILS_V
VIEW - APPS.OKS_INSTANCE_HISTORY_V
VIEW - APPS.OKS_INST_HIST_DETAILS_V
VIEW - APPS.OKS_INST_HIST_V
VIEW - APPS.OKS_INTERACTION_HIST_V
VIEW - APPS.OKS_INV_RVW_V
VIEW - APPS.OKS_K_CATEGORIES_V
VIEW - APPS.OKS_K_DEFAULTS_V
VIEW - APPS.OKS_K_DETAIL_V
VIEW - APPS.OKS_K_GROUPS_V
VIEW - APPS.OKS_K_HEADERS_HV
VIEW - APPS.OKS_K_HEADERS_V
VIEW - APPS.OKS_K_LINES_HV
VIEW - APPS.OKS_K_LINES_V
VIEW - APPS.OKS_K_ORDER_CONTACTS_V
VIEW - APPS.OKS_K_ORDER_DETAILS_V
VIEW - APPS.OKS_K_SALES_CREDITS_V
VIEW - APPS.OKS_LEVEL_ELEMENTS_V
VIEW - APPS.OKS_LINES_V
VIEW - APPS.OKS_LINE_DETAILS_V
VIEW - APPS.OKS_MASSCHANGE_CRITERIA_V
VIEW - APPS.OKS_MSCHG_OPERATIONS_DTLS_V
VIEW - APPS.OKS_NOTE_SOURCES_V
VIEW - APPS.OKS_ORDER_V
VIEW - APPS.OKS_PARTIES_V
VIEW - APPS.OKS_PMA_V
VIEW - APPS.OKS_PML_V
VIEW - APPS.OKS_PM_ACTIVITIES_V
VIEW - APPS.OKS_PM_PROGRAM_V
VIEW - APPS.OKS_PM_SCHEDULES_V
VIEW - APPS.OKS_PM_STREAM_LEVELS_V
VIEW - APPS.OKS_PRICE_BREAKS_HIST_V
VIEW - APPS.OKS_PRICE_BREAKS_V
VIEW - APPS.OKS_PRODUCTS_V
VIEW - APPS.OKS_PRODUCT_DETAILS_V
VIEW - APPS.OKS_PROD_DETAILS_V
VIEW - APPS.OKS_QUALIFIERS_V
VIEW - APPS.OKS_REACTION_TIMES_HV
VIEW - APPS.OKS_REACTION_TIMES_V
VIEW - APPS.OKS_REPNAME_V
VIEW - APPS.OKS_REPORT_TEMPLATES_V
VIEW - APPS.OKS_REPROCESSING_V
VIEW - APPS.OKS_REP_V
VIEW - APPS.OKS_RESOURCES_HV
VIEW - APPS.OKS_RESOURCES_V
VIEW - APPS.OKS_RESOURCE_GROUPS_V
VIEW - APPS.OKS_REV_DISTRIBUTIONS_V
VIEW - APPS.OKS_RULES_V
VIEW - APPS.OKS_SERVICE_COV_TEMPLTS_V
VIEW - APPS.OKS_SERV_AVAILS_V
VIEW - APPS.OKS_SERV_AVAIL_EXCEPTS_V
VIEW - APPS.OKS_SERV_CUSTEXC_V
VIEW - APPS.OKS_SERV_HDR_V
VIEW - APPS.OKS_SERV_PRODEXC_V
VIEW - APPS.OKS_STREAM_LEVELS_V
VIEW - APPS.OKS_STREAM_V
VIEW - APPS.OKS_STRM_TYPE_V
VIEW - APPS.OKS_SUBSCR_ELEMENTS_V
VIEW - APPS.OKS_SUBSCR_HEADER_V
VIEW - APPS.OKS_SUBSCR_PATTERNS_V
VIEW - APPS.OKS_TEMPLATE_COUNTERS_V
VIEW - APPS.OKS_TEMPLATE_SET_V
VIEW - APPS.OKS_TIMEVALUES_V
VIEW - APPS.OKS_TIME_CODE_UNITS_V
VIEW - APPS.OKS_USAGE_COUNTERS_V
VIEW - APPS.OKS_USAGE_ITEM_V

Table: OKS_ACTION_TIMES

Description: This table is suggested to store Reaction/Resolution times.
Primary Key: OKS_AT_PK
  1. ID

[top of page]

OKS.OKS_ACTION_TIMES does not reference any database object

OKS.OKS_ACTION_TIMES is referenced by following:

OKS
VIEW - OKS_ACTION_TIMES#

[top of page]

Table: OKS_ACTION_TIME_TYPES

Description: This table is suggested keeping in view the proposed feature to enable user defined time types in future. Action_type_code can be user defined in future. For now, it will be populated with 'RCN' for reaction times and 'RSN' for resolution t
Primary Key: OKS_ATT_PK
  1. ID

[top of page]

OKS.OKS_ACTION_TIME_TYPES does not reference any database object

OKS.OKS_ACTION_TIME_TYPES is referenced by following:

OKS
VIEW - OKS_ACTION_TIME_TYPES#

[top of page]

Table: OKS_BCL_PR

Description: Records which are sent to AR.
Primary Key: OKS_BCL_PR_PK
  1. ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OKS_BCL_PR.BTN_ID OKS_BTN_PR
OKS_BCL_PR.CLE_ID OKC_K_LINES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
OKS_BSL_PR.BCL_ID OKS_BCL_PR
OKS_BTL_PR.BCL_ID OKS_BCL_PR

[top of page]

OKS.OKS_BCL_PR does not reference any database object

OKS.OKS_BCL_PR is referenced by following:

OKS
VIEW - OKS_BCL_PR#

[top of page]

Table: OKS_BILLING_HIST_INT_ALL

Description: This Interface table is used to import Billing History Information for the Contract lines and covered level lines.

[top of page]

OKS.OKS_BILLING_HIST_INT_ALL does not reference any database object

OKS.OKS_BILLING_HIST_INT_ALL is referenced by following:

OKS
VIEW - OKS_BILLING_HIST_INT_ALL#

[top of page]

Table: OKS_BILLING_PROFILES_B

Description: Contains profile information for a customer.
Primary Key: OKS_BILLING_PROFILES_B_PK
  1. ID

[top of page]

OKS.OKS_BILLING_PROFILES_B does not reference any database object

OKS.OKS_BILLING_PROFILES_B is referenced by following:

OKS
VIEW - OKS_BILLING_PROFILES_B#

[top of page]

Table: OKS_BILLING_PROFILES_TL

Description: Translation Table for table OKS_BILLING_PROFILES
Primary Key: OKS_BILLING_PROFILES_TL_PK
  1. ID
  2. LANGUAGE

[top of page]

OKS.OKS_BILLING_PROFILES_TL does not reference any database object

OKS.OKS_BILLING_PROFILES_TL is referenced by following:

OKS
VIEW - OKS_BILLING_PROFILES_TL#

[top of page]

Table: OKS_BILLRATE_SCHEDULES

Description: This table stores the bill rate and it's schedules for a service activity billing type defined in Coverage.
Primary Key: OKS_BILLRATE_SCHEDULES_PK
  1. ID

[top of page]

OKS.OKS_BILLRATE_SCHEDULES does not reference any database object

OKS.OKS_BILLRATE_SCHEDULES is referenced by following:

OKS
VIEW - OKS_BILLRATE_SCHEDULES#

[top of page]

Table: OKS_BILL_CONT_LINES

Description: Records which are sent to AR.
Primary Key: OKS_BILL_CONT_LINES_PK
  1. ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OKS_BILL_CONT_LINES.BTN_ID OKS_BILL_TRANSACTIONS
OKS_BILL_CONT_LINES.CLE_ID OKC_K_LINES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
OKS_BILL_SUB_LINES.BCL_ID OKS_BILL_CONT_LINES
OKS_BILL_TXN_LINES.BCL_ID OKS_BILL_CONT_LINES
OKC_PRICE_ADJUSTMENTS_H.BCL_ID OKS_BILL_CONT_LINES
OKC_PRICE_ADJ_ASSOCS_H.BCL_ID OKS_BILL_CONT_LINES
OKC_PRICE_ADJ_ASSOCS.BCL_ID OKS_BILL_CONT_LINES
OKC_PRICE_ADJUSTMENTS.BCL_ID OKS_BILL_CONT_LINES
OKL_TXD_AR_LN_DTLS_B.BCL_ID OKS_BILL_CONT_LINES

[top of page]

OKS.OKS_BILL_CONT_LINES does not reference any database object

OKS.OKS_BILL_CONT_LINES is referenced by following:

OKS
VIEW - OKS_BILL_CONT_LINES#

[top of page]

Table: OKS_BILL_SUB_LINES

Description: Related to a lower level contract line eg. coverage level or product.
Primary Key: OKS_BILL_SUB_LINES_PK
  1. ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OKS_BILL_SUB_LINES.BCL_ID OKS_BILL_CONT_LINES
OKS_BILL_SUB_LINES.CLE_ID OKC_K_LINES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
OKS_BILL_SUB_LINE_DTLS.BSL_ID_AVERAGED OKS_BILL_SUB_LINES
OKS_BILL_SUB_LINE_DTLS.BSL_ID OKS_BILL_SUB_LINES
OKS_BILL_TXN_LINES.BSL_ID OKS_BILL_SUB_LINES
OKC_PRICE_ADJUSTMENTS_H.BSL_ID OKS_BILL_SUB_LINES
OKC_PRICE_ADJ_ASSOCS_H.BSL_ID OKS_BILL_SUB_LINES
OKC_PRICE_ADJ_ASSOCS.BSL_ID OKS_BILL_SUB_LINES
OKC_PRICE_ADJUSTMENTS.BSL_ID OKS_BILL_SUB_LINES
OKL_TXD_AR_LN_DTLS_B.BSL_ID OKS_BILL_SUB_LINES

[top of page]

OKS.OKS_BILL_SUB_LINES does not reference any database object

OKS.OKS_BILL_SUB_LINES is referenced by following:

OKS
VIEW - OKS_BILL_SUB_LINES#

[top of page]

Table: OKS_BILL_SUB_LINE_DTLS

Description: The detail of quantities and monetary amounts either regular or adjustment.
Primary Key: OKS_BILL_SUB_LINE_DTLS_PK
  1. ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OKS_BILL_SUB_LINE_DTLS.BSD_ID_APPLIED OKS_BILL_SUB_LINE_DTLS
OKS_BILL_SUB_LINE_DTLS.BSD_ID OKS_BILL_SUB_LINE_DTLS
OKS_BILL_SUB_LINE_DTLS.BSL_ID_AVERAGED OKS_BILL_SUB_LINES
OKS_BILL_SUB_LINE_DTLS.BSL_ID OKS_BILL_SUB_LINES
Foreign Keys to this table:
Foreign Key Column Foreign Table
OKS_BILL_SUB_LINE_DTLS.BSD_ID_APPLIED OKS_BILL_SUB_LINE_DTLS
OKS_BILL_SUB_LINE_DTLS.BSD_ID OKS_BILL_SUB_LINE_DTLS

[top of page]

OKS.OKS_BILL_SUB_LINE_DTLS does not reference any database object

OKS.OKS_BILL_SUB_LINE_DTLS is referenced by following:

OKS
VIEW - OKS_BILL_SUB_LINE_DTLS#

[top of page]

Table: OKS_BILL_TRANSACTIONS

Description: The transaction (invoice, credit etc.) which is eventually received from AR.
Primary Key: OKS_BILL_TRANSACTIONS_PK
  1. ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
OKS_BILL_CONT_LINES.BTN_ID OKS_BILL_TRANSACTIONS
OKS_BILL_TXN_LINES.BTN_ID OKS_BILL_TRANSACTIONS

[top of page]

OKS.OKS_BILL_TRANSACTIONS does not reference any database object

OKS.OKS_BILL_TRANSACTIONS is referenced by following:

OKS
VIEW - OKS_BILL_TRANSACTIONS#

[top of page]

Table: OKS_BILL_TXN_LINES

Description: Holds the actual transaction amount and tax returned from AR.
Primary Key: OKS_BILL_TXN_LINES_PK
  1. ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OKS_BILL_TXN_LINES.BCL_ID OKS_BILL_CONT_LINES
OKS_BILL_TXN_LINES.BSL_ID OKS_BILL_SUB_LINES
OKS_BILL_TXN_LINES.BTN_ID OKS_BILL_TRANSACTIONS

[top of page]

OKS.OKS_BILL_TXN_LINES does not reference any database object

OKS.OKS_BILL_TXN_LINES is referenced by following:

OKS
VIEW - OKS_BILL_TXN_LINES#

[top of page]

Table: OKS_BSD_PR

Description: The detail of quantities and monetary amounts either regular or adjustment.
Primary Key: OKS_BSD_PR_PK
  1. ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OKS_BSD_PR.BSD_ID_APPLIED OKS_BSD_PR
OKS_BSD_PR.BSD_ID OKS_BSD_PR
OKS_BSD_PR.BSL_ID_AVERAGED OKS_BSL_PR
OKS_BSD_PR.BSL_ID OKS_BSL_PR
Foreign Keys to this table:
Foreign Key Column Foreign Table
OKS_BSD_PR.BSD_ID_APPLIED OKS_BSD_PR
OKS_BSD_PR.BSD_ID OKS_BSD_PR

[top of page]

OKS.OKS_BSD_PR does not reference any database object

OKS.OKS_BSD_PR is referenced by following:

OKS
VIEW - OKS_BSD_PR#

[top of page]

Table: OKS_BSL_PR

Description: Related to a lower level contract line eg. coverage level or product.
Primary Key: OKS_BSL_PR_PK
  1. ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OKS_BSL_PR.BCL_ID OKS_BCL_PR
OKS_BSL_PR.CLE_ID OKC_K_LINES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
OKS_BSD_PR.BSL_ID_AVERAGED OKS_BSL_PR
OKS_BSD_PR.BSL_ID OKS_BSL_PR
OKS_BTL_PR.BSL_ID OKS_BSL_PR

[top of page]

OKS.OKS_BSL_PR does not reference any database object

OKS.OKS_BSL_PR is referenced by following:

OKS
VIEW - OKS_BSL_PR#

[top of page]

Table: OKS_BTL_PR

Description: Holds the actual transaction amount and tax returned from AR.
Primary Key: OKS_BTL_PR_PK
  1. ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OKS_BTL_PR.BCL_ID OKS_BCL_PR
OKS_BTL_PR.BSL_ID OKS_BSL_PR
OKS_BTL_PR.BTN_ID OKS_BTN_PR

[top of page]

OKS.OKS_BTL_PR does not reference any database object

OKS.OKS_BTL_PR is referenced by following:

OKS
VIEW - OKS_BTL_PR#

[top of page]

Table: OKS_BTN_PR

Description: The transaction (invoice, credit etc.) which is eventually received from AR.
Primary Key: OKS_BTN_PR_PK
  1. ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
OKS_BCL_PR.BTN_ID OKS_BTN_PR
OKS_BTL_PR.BTN_ID OKS_BTN_PR

[top of page]

OKS.OKS_BTN_PR does not reference any database object

OKS.OKS_BTN_PR is referenced by following:

OKS
VIEW - OKS_BTN_PR#

[top of page]

Table: OKS_CON_COV_LEVELS_INT_ALL

Description: This Interface table is used to import covered levels information from legacy/source system to Oracle Contracts for Service applications.

[top of page]

OKS.OKS_CON_COV_LEVELS_INT_ALL does not reference any database object

OKS.OKS_CON_COV_LEVELS_INT_ALL is referenced by following:

OKS
VIEW - OKS_CON_COV_LEVELS_INT_ALL#

[top of page]

Table: OKS_CON_ERRORS_INT_ALL

Description: This table would be using in logging errors during Service Contracts Import.

[top of page]

OKS.OKS_CON_ERRORS_INT_ALL does not reference any database object

OKS.OKS_CON_ERRORS_INT_ALL is referenced by following:

OKS
VIEW - OKS_CON_ERRORS_INT_ALL#

[top of page]

Table: OKS_CON_HEADERS_INT_ALL

Description: This is the interface table for importing Service Contracts Header information.

[top of page]

OKS.OKS_CON_HEADERS_INT_ALL does not reference any database object

OKS.OKS_CON_HEADERS_INT_ALL is referenced by following:

OKS
VIEW - OKS_CON_HEADERS_INT_ALL#

[top of page]

Table: OKS_CON_LINES_INT_ALL

Description: This Interface table is used to import contract lines information to Oracle Contracts for Service application (OKS) as Contract Lines.

[top of page]

OKS.OKS_CON_LINES_INT_ALL does not reference any database object

OKS.OKS_CON_LINES_INT_ALL is referenced by following:

OKS
VIEW - OKS_CON_LINES_INT_ALL#

[top of page]

Table: OKS_COVERAGES_INT_ALL

Description: This interface table is meant to import all the Coverage information to Oracle Contracts for Service module.

[top of page]

OKS.OKS_COVERAGES_INT_ALL does not reference any database object

OKS.OKS_COVERAGES_INT_ALL is referenced by following:

OKS
VIEW - OKS_COVERAGES_INT_ALL#

[top of page]

Table: OKS_COVERAGE_TIMES

Description: This table is suggested to store coverage times for a specific coverage time zone which reference a business process line
Primary Key: OKS_CT_PK
  1. ID

[top of page]

OKS.OKS_COVERAGE_TIMES does not reference any database object

OKS.OKS_COVERAGE_TIMES is referenced by following:

OKS
VIEW - OKS_COVERAGE_TIMES#

[top of page]

Table: OKS_COVERAGE_TIMEZONES

Description: This table is suggested to store coverage time zones for a business process line
Primary Key: OKS_CTZ_PK
  1. ID

[top of page]

OKS.OKS_COVERAGE_TIMEZONES does not reference any database object

OKS.OKS_COVERAGE_TIMEZONES is referenced by following:

OKS
VIEW - OKS_COVERAGE_TIMEZONES#

[top of page]

Table: OKS_COVERED_ACCOUNT_STG_TEMP

Description:

[top of page]

OKS.OKS_COVERED_ACCOUNT_STG_TEMP does not reference any database object

OKS.OKS_COVERED_ACCOUNT_STG_TEMP is referenced by following:

OKS
VIEW - OKS_COVERED_ACCOUNT_STG_TEMP#

[top of page]

Table: OKS_COVERED_INSTANCE_STG_TEMP

Description:

[top of page]

OKS.OKS_COVERED_INSTANCE_STG_TEMP does not reference any database object

OKS.OKS_COVERED_INSTANCE_STG_TEMP is referenced by following:

OKS
VIEW - OKS_COVERED_INSTANCE_STG_TEMP#

[top of page]

Table: OKS_COVERED_ITEM_STG_TEMP

Description:

[top of page]

OKS.OKS_COVERED_ITEM_STG_TEMP does not reference any database object

OKS.OKS_COVERED_ITEM_STG_TEMP is referenced by following:

OKS
VIEW - OKS_COVERED_ITEM_STG_TEMP#

[top of page]

Table: OKS_COVERED_PARTY_STG_TEMP

Description:

[top of page]

OKS.OKS_COVERED_PARTY_STG_TEMP does not reference any database object

OKS.OKS_COVERED_PARTY_STG_TEMP is referenced by following:

OKS
VIEW - OKS_COVERED_PARTY_STG_TEMP#

[top of page]

Table: OKS_COVERED_SITE_STG_TEMP

Description:

[top of page]

OKS.OKS_COVERED_SITE_STG_TEMP does not reference any database object

OKS.OKS_COVERED_SITE_STG_TEMP is referenced by following:

OKS
VIEW - OKS_COVERED_SITE_STG_TEMP#

[top of page]

Table: OKS_COVERED_SYSTEM_STG_TEMP

Description:

[top of page]

OKS.OKS_COVERED_SYSTEM_STG_TEMP does not reference any database object

OKS.OKS_COVERED_SYSTEM_STG_TEMP is referenced by following:

OKS
VIEW - OKS_COVERED_SYSTEM_STG_TEMP#

[top of page]

Table: OKS_COV_BILL_RATES_INT_ALL

Description: This Interface table would be used to import Coverage Billing rates (Labor) information to OKS.

[top of page]

OKS.OKS_COV_BILL_RATES_INT_ALL does not reference any database object

OKS.OKS_COV_BILL_RATES_INT_ALL is referenced by following:

OKS
VIEW - OKS_COV_BILL_RATES_INT_ALL#

[top of page]

Table: OKS_COV_BILL_TYPES_INT_ALL

Description: This Interface table would be used to import Coverage Billing types for each business process to OKS.

[top of page]

OKS.OKS_COV_BILL_TYPES_INT_ALL does not reference any database object

OKS.OKS_COV_BILL_TYPES_INT_ALL is referenced by following:

OKS
VIEW - OKS_COV_BILL_TYPES_INT_ALL#

[top of page]

Table: OKS_COV_TXN_GROUPS_INT_ALL

Description: This Interface table would be used to import Business processes , their coverage times, reaction times and resolution times attached to the coverage of the Contract line to OKS module.

[top of page]

OKS.OKS_COV_TXN_GROUPS_INT_ALL does not reference any database object

OKS.OKS_COV_TXN_GROUPS_INT_ALL is referenced by following:

OKS
VIEW - OKS_COV_TXN_GROUPS_INT_ALL#

[top of page]

Table: OKS_COV_TYPES_B

Description: Contains the coverage type code and importance of each coverage type.
Primary Key: OKS_COV_TYPES_B_PK
  1. CODE

[top of page]

OKS.OKS_COV_TYPES_B does not reference any database object

OKS.OKS_COV_TYPES_B is referenced by following:

OKS
VIEW - OKS_COV_TYPES_B#

[top of page]

Table: OKS_COV_TYPES_TL

Description: Translatable columns from OKS_COV_TYPES_B, as per MLS standards.
Primary Key: OKS_COV_TYPES_TL_PK
  1. CODE
  2. LANGUAGE

[top of page]

OKS.OKS_COV_TYPES_TL does not reference any database object

OKS.OKS_COV_TYPES_TL is referenced by following:

OKS
VIEW - OKS_COV_TYPES_TL#

[top of page]

Table: OKS_DA_INTERFACE_B

Description:

[top of page]

OKS.OKS_DA_INTERFACE_B does not reference any database object

OKS.OKS_DA_INTERFACE_B is referenced by following:

OKS
VIEW - OKS_DA_INTERFACE_B#

[top of page]

Table: OKS_INSTANCE_CONTRACTS_TEMP

Description:

[top of page]

OKS.OKS_INSTANCE_CONTRACTS_TEMP does not reference any database object

OKS.OKS_INSTANCE_CONTRACTS_TEMP is referenced by following:

OKS
VIEW - OKS_INSTANCE_CONTRACTS_TEMP#

[top of page]

Table: OKS_INSTANCE_HISTORY

Description:
Primary Key: OKS_INSTANCE_HISTORY_PK
  1. ID

[top of page]

OKS.OKS_INSTANCE_HISTORY does not reference any database object

OKS.OKS_INSTANCE_HISTORY is referenced by following:

OKS
VIEW - OKS_INSTANCE_HISTORY#

[top of page]

Table: OKS_INSTANCE_K_DTLS_TEMP

Description:

[top of page]

OKS.OKS_INSTANCE_K_DTLS_TEMP does not reference any database object

OKS.OKS_INSTANCE_K_DTLS_TEMP is referenced by following:

APPS
SYNONYM - OKS_INSTANCE_K_DTLS_TEMP

[top of page]

Table: OKS_INST_HIST_DETAILS

Description:
Primary Key: OKS_INST_HIST_DETAILS_PK
  1. ID

[top of page]

OKS.OKS_INST_HIST_DETAILS does not reference any database object

OKS.OKS_INST_HIST_DETAILS is referenced by following:

OKS
VIEW - OKS_INST_HIST_DETAILS#

[top of page]

Table: OKS_INTERACTION_HISTORY

Description: Interaction history table for auto renewal.
Primary Key: OKS_INTERACTION_HISTORY_PK
  1. ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OKS_INTERACTION_HISTORY.CHR_ID OKC_K_HEADERS_B

[top of page]

OKS.OKS_INTERACTION_HISTORY does not reference any database object

OKS.OKS_INTERACTION_HISTORY is referenced by following:

OKS
VIEW - OKS_INTERACTION_HISTORY#

[top of page]

Table: OKS_INT_COVERED_LEVEL_STG_TEMP

Description:

[top of page]

OKS.OKS_INT_COVERED_LEVEL_STG_TEMP does not reference any database object

OKS.OKS_INT_COVERED_LEVEL_STG_TEMP is referenced by following:

OKS
VIEW - OKS_INT_COVERED_LEVEL_STG_TEM#

[top of page]

Table: OKS_INT_ERROR_STG_TEMP

Description:

[top of page]

OKS.OKS_INT_ERROR_STG_TEMP does not reference any database object

OKS.OKS_INT_ERROR_STG_TEMP is referenced by following:

OKS
VIEW - OKS_INT_ERROR_STG_TEMP#

[top of page]

Table: OKS_INT_HEADER_STG_TEMP

Description:

[top of page]

OKS.OKS_INT_HEADER_STG_TEMP does not reference any database object

OKS.OKS_INT_HEADER_STG_TEMP is referenced by following:

OKS
VIEW - OKS_INT_HEADER_STG_TEMP#

[top of page]

Table: OKS_INT_LINE_STG_TEMP

Description:

[top of page]

OKS.OKS_INT_LINE_STG_TEMP does not reference any database object

OKS.OKS_INT_LINE_STG_TEMP is referenced by following:

OKS
VIEW - OKS_INT_LINE_STG_TEMP#

[top of page]

Table: OKS_INT_SALES_CREDIT_STG_TEMP

Description:

[top of page]

OKS.OKS_INT_SALES_CREDIT_STG_TEMP does not reference any database object

OKS.OKS_INT_SALES_CREDIT_STG_TEMP is referenced by following:

OKS
VIEW - OKS_INT_SALES_CREDIT_STG_TEMP#

[top of page]

Table: OKS_INT_USAGE_COUNTER_STG_TEMP

Description:

[top of page]

OKS.OKS_INT_USAGE_COUNTER_STG_TEMP does not reference any database object

OKS.OKS_INT_USAGE_COUNTER_STG_TEMP is referenced by following:

OKS
VIEW - OKS_INT_USAGE_COUNTER_STG_TEM#

[top of page]

Table: OKS_JTF_RES_TEMP

Description:

[top of page]

OKS.OKS_JTF_RES_TEMP does not reference any database object

OKS.OKS_JTF_RES_TEMP is referenced by following:

APPS
SYNONYM - OKS_JTF_RES_TEMP

[top of page]

Table: OKS_K_DEFAULTS

Description: This table is used to hold default values used when renewing a service contract or when creating a service contract from an order.The defaults can either be a "Master" default, where CDT_TYPE = 'MDT', or a "Segmented" default, where CDT_TYP
Primary Key: OKS_K_DEFAULTS_PK
  1. ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OKS_K_DEFAULTS.CGP_NEW_ID OKC_K_GROUPS_B
OKS_K_DEFAULTS.CGP_RENEW_ID OKC_K_GROUPS_B
OKS_K_DEFAULTS.JTOT_OBJECT_CODE JTF_OBJECTS_B
OKS_K_DEFAULTS.PDF_ID OKC_PROCESS_DEFS_B
OKS_K_DEFAULTS.QCL_ID OKC_QA_CHECK_LISTS_B

[top of page]

OKS.OKS_K_DEFAULTS does not reference any database object

OKS.OKS_K_DEFAULTS is referenced by following:

OKS
VIEW - OKS_K_DEFAULTS#

[top of page]

Table: OKS_K_HEADERS_B

Description: Service Contracts Header Attributes
Primary Key: OKS_K_HEADERS_B_PK
  1. ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OKS_K_HEADERS_B.CHR_ID OKC_K_HEADERS_B

[top of page]

OKS.OKS_K_HEADERS_B does not reference any database object

OKS.OKS_K_HEADERS_B is referenced by following:

OKS
VIEW - OKS_K_HEADERS_B#

[top of page]

Table: OKS_K_HEADERS_BH

Description: Service Contracts Header Attributes History
Primary Key: OKS_K_HEADERS_BH_PK
  1. ID
  2. MAJOR_VERSION

[top of page]

OKS.OKS_K_HEADERS_BH does not reference any database object

OKS.OKS_K_HEADERS_BH is referenced by following:

OKS
VIEW - OKS_K_HEADERS_BH#

[top of page]

Table: OKS_K_LINES_B

Description: Service Contracts Line Attributes
Primary Key: OKS_K_LINES_B_PK
  1. ID

[top of page]

OKS.OKS_K_LINES_B does not reference any database object

OKS.OKS_K_LINES_B is referenced by following:

OKS
VIEW - OKS_K_LINES_B#

[top of page]

Table: OKS_K_LINES_BH

Description: Service Contracts Line Attributes History
Primary Key: OKS_K_LINES_BH_PK
  1. ID
  2. MAJOR_VERSION

[top of page]

OKS.OKS_K_LINES_BH does not reference any database object

OKS.OKS_K_LINES_BH is referenced by following:

OKS
VIEW - OKS_K_LINES_BH#

[top of page]

Table: OKS_K_LINES_TL

Description: Service Contracts Line Text Attributes
Primary Key: OKS_K_LINES_TL_PK
  1. ID
  2. LANGUAGE

[top of page]

OKS.OKS_K_LINES_TL does not reference any database object

OKS.OKS_K_LINES_TL is referenced by following:

OKS
VIEW - OKS_K_LINES_TL#

[top of page]

Table: OKS_K_LINES_TLH

Description: Service Contracts Line Text Attributes History
Primary Key: OKS_K_LINES_TLH_PK
  1. ID
  2. MAJOR_VERSION
  3. LANGUAGE

[top of page]

OKS.OKS_K_LINES_TLH does not reference any database object

OKS.OKS_K_LINES_TLH is referenced by following:

OKS
VIEW - OKS_K_LINES_TLH#

[top of page]

Table: OKS_K_ORDER_CONTACTS

Description: table for Order Contacts
Primary Key: OKS_K_ORDER_CONTACTS_PK
  1. ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OKS_K_ORDER_CONTACTS.COD_ID OKS_K_ORDER_DETAILS
OKS_K_ORDER_CONTACTS.JTOT_OBJECT_CODE JTF_OBJECTS_B
OKS_K_ORDER_CONTACTS.COD_ID OKS_K_ORDER_DETAILS
OKS_K_ORDER_CONTACTS.JTOT_OBJECT_CODE JTF_OBJECTS_B

[top of page]

OKS.OKS_K_ORDER_CONTACTS does not reference any database object

OKS.OKS_K_ORDER_CONTACTS is referenced by following:

OKS
VIEW - OKS_K_ORDER_CONTACTS#

[top of page]

Table: OKS_K_ORDER_DETAILS

Description: This table captures service contract details when a service is ordered in Order Management.
Primary Key: OKS_K_ORDER_DETAILS_PK
  1. ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OKS_K_ORDER_DETAILS.CHR_ID OKC_K_HEADERS_B
OKS_K_ORDER_DETAILS.LINK_CHR_ID OKC_K_HEADERS_B
OKS_K_ORDER_DETAILS.LINK_CLE_ID OKC_K_LINES_B
OKS_K_ORDER_DETAILS.CLE_ID OKC_K_LINES_B
OKS_K_ORDER_DETAILS.COD_ID OKS_K_ORDER_DETAILS
OKS_K_ORDER_DETAILS.CHR_ID OKC_K_HEADERS_B
OKS_K_ORDER_DETAILS.LINK_CHR_ID OKC_K_HEADERS_B
OKS_K_ORDER_DETAILS.LINK_CLE_ID OKC_K_LINES_B
OKS_K_ORDER_DETAILS.CLE_ID OKC_K_LINES_B
OKS_K_ORDER_DETAILS.COD_ID OKS_K_ORDER_DETAILS
Foreign Keys to this table:
Foreign Key Column Foreign Table
OKS_K_ORDER_CONTACTS.COD_ID OKS_K_ORDER_DETAILS
OKS_K_ORDER_DETAILS.COD_ID OKS_K_ORDER_DETAILS
OKS_K_ORDER_CONTACTS.COD_ID OKS_K_ORDER_DETAILS
OKS_K_ORDER_DETAILS.COD_ID OKS_K_ORDER_DETAILS

[top of page]

OKS.OKS_K_ORDER_DETAILS does not reference any database object

OKS.OKS_K_ORDER_DETAILS is referenced by following:

OKS
VIEW - OKS_K_ORDER_DETAILS#

[top of page]

Table: OKS_K_RES_TEMP

Description:

[top of page]

OKS.OKS_K_RES_TEMP does not reference any database object

OKS.OKS_K_RES_TEMP is referenced by following:

APPS
SYNONYM - OKS_K_RES_TEMP

[top of page]

Table: OKS_K_SALES_CREDITS

Description: Records sales credits for the sale of services in a service contract.
Primary Key: OKS_K_SAELS_CREDITS_PK
  1. ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OKS_K_SALES_CREDITS.CHR_ID OKC_K_HEADERS_B
OKS_K_SALES_CREDITS.CLE_ID OKC_K_LINES_B
OKS_K_SALES_CREDITS.CTC_ID OKC_CONTACTS

[top of page]

OKS.OKS_K_SALES_CREDITS does not reference any database object

OKS.OKS_K_SALES_CREDITS is referenced by following:

OKS
VIEW - OKS_K_SALES_CREDITS#

[top of page]

Table: OKS_LEVEL_ELEMENTS

Description: each individual period within a level
Primary Key: OKS_LEVEL_ELEMENTS_PK
  1. ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OKS_LEVEL_ELEMENTS.RUL_ID OKC_RULES_B

[top of page]

OKS.OKS_LEVEL_ELEMENTS does not reference any database object

OKS.OKS_LEVEL_ELEMENTS is referenced by following:

OKS
VIEW - OKS_LEVEL_ELEMENTS#

[top of page]

Table: OKS_MSCHG_OPERATIONS_DTLS

Description: This table stores masschage related information.
Primary Key: OKS_MSCHG_OPERATIONS_DTLS_PK
  1. ID

[top of page]

OKS.OKS_MSCHG_OPERATIONS_DTLS does not reference any database object

OKS.OKS_MSCHG_OPERATIONS_DTLS is referenced by following:

OKS
VIEW - OKS_MSCHG_OPERATIONS_DTLS#

[top of page]

Table: OKS_PM_ACTIVITIES

Description: Preventive Maintenance Activities
Primary Key: OKS_PM_ACTIVITIES_PK
  1. ID

[top of page]

OKS.OKS_PM_ACTIVITIES does not reference any database object

OKS.OKS_PM_ACTIVITIES is referenced by following:

OKS
VIEW - OKS_PM_ACTIVITIES#

[top of page]

Table: OKS_PM_SCHEDULES

Description: This table will store the schedule details of PM program attached to a coverage.
Primary Key: OKS_PM_SCHEDULES_PK
  1. ID

[top of page]

OKS.OKS_PM_SCHEDULES does not reference any database object

OKS.OKS_PM_SCHEDULES is referenced by following:

OKS
VIEW - OKS_PM_SCHEDULES#

[top of page]

Table: OKS_PM_STREAM_LEVELS

Description: PM Stream Levels
Primary Key: OKS_PM_STREAM_LEVELS_PK
  1. ID

[top of page]

OKS.OKS_PM_STREAM_LEVELS does not reference any database object

OKS.OKS_PM_STREAM_LEVELS is referenced by following:

OKS
VIEW - OKS_PM_STREAM_LEVELS#

[top of page]

Table: OKS_PROCESS_CONTROL

Description: This table is used to store the statistics of a sql file. ie, If a sql file need to be run only once when applying the patch then it will check the statistics of the file in this table

[top of page]

OKS.OKS_PROCESS_CONTROL does not reference any database object

OKS.OKS_PROCESS_CONTROL is referenced by following:

OKS
VIEW - OKS_PROCESS_CONTROL#

[top of page]

Table: OKS_QUALIFIERS

Description: Used for Pricing Qualifier setup for Service Authoring
Primary Key: OKS_QUALIFIERS_PK
  1. QUALIFIER_ID

[top of page]

OKS.OKS_QUALIFIERS does not reference any database object

OKS.OKS_QUALIFIERS is referenced by following:

OKS
VIEW - OKS_QUALIFIERS#

[top of page]

Table: OKS_REPORT_TEMPLATES

Description: Stores the reports for each template set.
Primary Key: OKS_REPORT_TEMP_PK
  1. ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OKS_REPORT_TEMPLATES.TEMPLATE_SET_ID OKS_TEMPLATE_SET

[top of page]

OKS.OKS_REPORT_TEMPLATES does not reference any database object

OKS.OKS_REPORT_TEMPLATES is referenced by following:

OKS
VIEW - OKS_REPORT_TEMPLATES#

[top of page]

Table: OKS_REPROCESSING

Description:
Primary Key: OKS_REPROCESSING_PK
  1. ID

[top of page]

OKS.OKS_REPROCESSING does not reference any database object

OKS.OKS_REPROCESSING is referenced by following:

OKS
VIEW - OKS_REPROCESSING#

[top of page]

Table: OKS_REV_DISTRIBUTIONS

Description: Database table used for storing revenue distribution information for service contract lines.
Primary Key: OKS_REV_DISTRIBUTIONS_PK
  1. ID

[top of page]

OKS.OKS_REV_DISTRIBUTIONS does not reference any database object

OKS.OKS_REV_DISTRIBUTIONS is referenced by following:

OKS
VIEW - OKS_REV_DISTRIBUTIONS#

[top of page]

Table: OKS_RULES_DFF

Description: Contracts Rule Definitions table- rules striped
Primary Key: OKS_RULES_B_PK
  1. ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OKS_RULES_DFF.JTOT_OBJECT1_CODE JTF_OBJECTS_B
OKS_RULES_DFF.JTOT_OBJECT2_CODE JTF_OBJECTS_B
OKS_RULES_DFF.JTOT_OBJECT3_CODE JTF_OBJECTS_B
OKS_RULES_DFF.RGP_ID OKC_RULE_GROUPS_B

[top of page]

OKS.OKS_RULES_DFF does not reference any database object

OKS.OKS_RULES_DFF is referenced by following:

OKS
VIEW - OKS_RULES_DFF#

[top of page]

Table: OKS_SERV_AVAILS

Description: Stores availability information for a service.
Primary Key: OKS_SERV_AVAILS_PK
  1. ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OKS_SERV_AVAILS.JTOT_OBJECT1_CODE JTF_OBJECTS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
OKS_SERV_AVAIL_EXCEPTS.SAV_ID OKS_SERV_AVAILS

[top of page]

OKS.OKS_SERV_AVAILS does not reference any database object

OKS.OKS_SERV_AVAILS is referenced by following:

OKS
VIEW - OKS_SERV_AVAILS#

[top of page]

Table: OKS_SERV_AVAIL_EXCEPTS

Description: Exception information for a service availabilities.
Primary Key: OKS_SERV_AVAIL_EXCEPTS_PK
  1. ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OKS_SERV_AVAIL_EXCEPTS.JTOT_OBJECT1_CODE JTF_OBJECTS_B
OKS_SERV_AVAIL_EXCEPTS.SAV_ID OKS_SERV_AVAILS

[top of page]

OKS.OKS_SERV_AVAIL_EXCEPTS does not reference any database object

OKS.OKS_SERV_AVAIL_EXCEPTS is referenced by following:

OKS
VIEW - OKS_SERV_AVAIL_EXCEPTS#

[top of page]

Table: OKS_STATUS_FORECAST

Description: For storing service forecast details

[top of page]

OKS.OKS_STATUS_FORECAST does not reference any database object

OKS.OKS_STATUS_FORECAST is referenced by following:

OKS
VIEW - OKS_STATUS_FORECAST#

[top of page]

Table: OKS_STREAM_LEVELS_B

Description: Service Contracts Billing Stream Levels
Primary Key: OKS_STREAM_LEVELS_B_PK
  1. ID

[top of page]

OKS.OKS_STREAM_LEVELS_B does not reference any database object

OKS.OKS_STREAM_LEVELS_B is referenced by following:

OKS
VIEW - OKS_STREAM_LEVELS_B#

[top of page]

Table: OKS_STRM_TYPE

Description: Specifies what the stream is for A stream may be a + or - cashflow
Primary Key: OKS_STRM_TYPE_PK
  1. ID

[top of page]

OKS.OKS_STRM_TYPE does not reference any database object

OKS.OKS_STRM_TYPE is referenced by following:

OKS
VIEW - OKS_STRM_TYPE#

[top of page]

Table: OKS_SUBSCR_ELEMENTS

Description: Used for Subcription Elements Information
Primary Key: OKS_SUBSCR_ELEMENTS_PK
  1. ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OKS_SUBSCR_ELEMENTS.OSH_ID OKS_SUBSCR_HEADER_B

[top of page]

OKS.OKS_SUBSCR_ELEMENTS does not reference any database object

OKS.OKS_SUBSCR_ELEMENTS is referenced by following:

OKS
VIEW - OKS_SUBSCR_ELEMENTS#

[top of page]

Table: OKS_SUBSCR_HEADER_B

Description: Used for Subcription Header Information
Primary Key: OKS_SUBSCR_HEADER_B_PK
  1. ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OKS_SUBSCR_HEADER_B.CLE_ID OKC_K_LINES_B
OKS_SUBSCR_HEADER_B.INSTANCE_ID CSI_ITEM_INSTANCES
Foreign Keys to this table:
Foreign Key Column Foreign Table
OKS_SUBSCR_PATTERNS.OSH_ID OKS_SUBSCR_HEADER_B
OKS_SUBSCR_ELEMENTS.OSH_ID OKS_SUBSCR_HEADER_B

[top of page]

OKS.OKS_SUBSCR_HEADER_B does not reference any database object

OKS.OKS_SUBSCR_HEADER_B is referenced by following:

OKS
VIEW - OKS_SUBSCR_HEADER_B#

[top of page]

Table: OKS_SUBSCR_HEADER_TL

Description: Translatable columns from OKS_SUBSCR_HEADER_B, as per MLS standards.
Primary Key: OKS_SUBSCR_HEADER_TL_PK
  1. LANGUAGE
  2. ID

[top of page]

OKS.OKS_SUBSCR_HEADER_TL does not reference any database object

OKS.OKS_SUBSCR_HEADER_TL is referenced by following:

OKS
VIEW - OKS_SUBSCR_HEADER_TL#

[top of page]

Table: OKS_SUBSCR_PATTERNS

Description: Used for Subcription PatternsInformation
Primary Key: OKS_SUBSCR_PATTERNS_PK
  1. ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OKS_SUBSCR_PATTERNS.OSH_ID OKS_SUBSCR_HEADER_B

[top of page]

OKS.OKS_SUBSCR_PATTERNS does not reference any database object

OKS.OKS_SUBSCR_PATTERNS is referenced by following:

OKS
VIEW - OKS_SUBSCR_PATTERNS#

[top of page]

Table: OKS_TEMPLATE_SET

Description: Stores the template set information.
Primary Key: OKS_TEMPLATE_SET_PK
  1. ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
OKS_REPORT_TEMPLATES.TEMPLATE_SET_ID OKS_TEMPLATE_SET

[top of page]

OKS.OKS_TEMPLATE_SET does not reference any database object

OKS.OKS_TEMPLATE_SET is referenced by following:

OKS
VIEW - OKS_TEMPLATE_SET#

[top of page]

Table: OKS_USG_QP_CALL_TBL

Description:

[top of page]

OKS.OKS_USG_QP_CALL_TBL does not reference any database object

OKS.OKS_USG_QP_CALL_TBL is referenced by following:

APPS
SYNONYM - OKS_USG_QP_CALL_TBL

[top of page]

View: OKS_ACTION_TIMES_V

[top of page]

APPS.OKS_ACTION_TIMES_V references the following:

APPS
SYNONYM - OKS_ACTION_TIMES

APPS.OKS_ACTION_TIMES_V is not referenced by any database object

[top of page]

View: OKS_ACTION_TIME_TYPES_V

[top of page]

APPS.OKS_ACTION_TIME_TYPES_V references the following:

APPS
SYNONYM - OKS_ACTION_TIME_TYPES

APPS.OKS_ACTION_TIME_TYPES_V is not referenced by any database object

[top of page]

View: OKS_APPROVED_CONTRACTS_V

[top of page]

APPS.OKS_APPROVED_CONTRACTS_V references the following:

APPS
SYNONYM - OKC_K_HEADERS_B
SYNONYM - OKC_K_ITEMS
SYNONYM - OKC_K_LINES_B

APPS.OKS_APPROVED_CONTRACTS_V is not referenced by any database object

[top of page]

View: OKS_AUTH_HEADERS_HV

[top of page]

APPS.OKS_AUTH_HEADERS_HV references the following:

APPS
SYNONYM - OKC_K_HEADERS_BH
SYNONYM - OKC_K_HEADERS_TLH
VIEW - OKC_STATUSES_V
VIEW - OKC_SUBCLASSES_V
PACKAGE - OKC_UTIL
SYNONYM - OKS_K_HEADERS_BH

APPS.OKS_AUTH_HEADERS_HV is not referenced by any database object

[top of page]

View: OKS_AUTH_HEADERS_V

[top of page]

APPS.OKS_AUTH_HEADERS_V references the following:

APPS
SYNONYM - OKC_K_HEADERS_B
SYNONYM - OKC_K_HEADERS_TL
VIEW - OKC_STATUSES_V
VIEW - OKC_SUBCLASSES_V
PACKAGE - OKC_UTIL
SYNONYM - OKS_K_HEADERS_B

APPS.OKS_AUTH_HEADERS_V is not referenced by any database object

[top of page]

View: OKS_AUTH_LINES_HV

[top of page]

APPS.OKS_AUTH_LINES_HV references the following:

APPS
SYNONYM - OKC_K_LINES_BH
SYNONYM - OKC_K_LINES_TLH
SYNONYM - OKS_K_LINES_BH
SYNONYM - OKS_K_LINES_TLH

APPS.OKS_AUTH_LINES_HV is not referenced by any database object

[top of page]

View: OKS_AUTH_LINES_V

[top of page]

APPS.OKS_AUTH_LINES_V references the following:

APPS
SYNONYM - OKC_K_LINES_B
SYNONYM - OKC_K_LINES_TL
SYNONYM - OKS_K_LINES_B
SYNONYM - OKS_K_LINES_TL

APPS.OKS_AUTH_LINES_V is not referenced by any database object

[top of page]

View: OKS_AUTH_SHOWALL_PROD_V

[top of page]

APPS.OKS_AUTH_SHOWALL_PROD_V references the following:

APPS
PACKAGE - ARP_ADDR_LABEL_PKG
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - CSI_I_PRICING_ATTRIBS
VIEW - CSI_SYSTEMS_VL
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - HZ_CUST_ACCOUNTS_ALL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
VIEW - JTF_RS_GROUPS_VL
VIEW - JTF_RS_TEAMS_VL
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - MTL_UNITS_OF_MEASURE_TL
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - OE_ORDER_LINES_ALL
SYNONYM - OKC_K_HEADERS_ALL_B
SYNONYM - OKC_K_ITEMS
SYNONYM - OKC_K_LINES_B
SYNONYM - PER_ALL_PEOPLE_F
VIEW - PO_VENDORS
- OKS_EXTWAR_UTIL_PVT
- PO_VENDOR_SITES_ALL

APPS.OKS_AUTH_SHOWALL_PROD_V is not referenced by any database object

[top of page]

View: OKS_BCL_PR_V

[top of page]

APPS.OKS_BCL_PR_V references the following:

APPS
SYNONYM - OKS_BILL_CONT_LINES

APPS.OKS_BCL_PR_V is not referenced by any database object

[top of page]

View: OKS_BILLING_DTLS_V

[top of page]

APPS.OKS_BILLING_DTLS_V references the following:

APPS
SYNONYM - OKS_BILL_CONT_LINES
SYNONYM - OKS_BILL_SUB_LINES
SYNONYM - OKS_BILL_TRANSACTIONS
SYNONYM - OKS_BILL_TXN_LINES
APPS.OKS_BILLING_DTLS_V is referenced by following:

APPS
VIEW - OKS_CONTRACT_DTLS_V

[top of page]

View: OKS_BILLING_HISTORY_V

[top of page]

APPS.OKS_BILLING_HISTORY_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - OKC_K_HEADERS_B
SYNONYM - OKC_K_LINES_B
SYNONYM - OKC_K_REL_OBJS
SYNONYM - OKS_BILL_CONT_LINES
SYNONYM - OKS_BILL_SUB_LINES
SYNONYM - OKS_BILL_SUB_LINE_DTLS
SYNONYM - OKS_BILL_TXN_LINES
SYNONYM - RA_CUSTOMER_TRX_ALL
SYNONYM - RA_CUSTOMER_TRX_LINES_ALL

APPS.OKS_BILLING_HISTORY_V is not referenced by any database object

[top of page]

View: OKS_BILLING_HIST_LINES_V

[top of page]

APPS.OKS_BILLING_HIST_LINES_V references the following:

APPS
VIEW - OKC_K_LINES_V
VIEW - OKC_LINE_STYLES_V
SYNONYM - OKS_BILL_SUB_LINES
SYNONYM - OKS_BILL_SUB_LINE_DTLS

APPS.OKS_BILLING_HIST_LINES_V is not referenced by any database object

[top of page]

View: OKS_BILLING_HIST_V

[top of page]

APPS.OKS_BILLING_HIST_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - OKS_BILL_CONT_LINES
SYNONYM - OKS_BILL_SUB_LINES
SYNONYM - OKS_BILL_TRANSACTIONS
SYNONYM - OKS_BILL_TXN_LINES

APPS.OKS_BILLING_HIST_V is not referenced by any database object

[top of page]

View: OKS_BILLING_PROFILES_V

[top of page]

APPS.OKS_BILLING_PROFILES_V references the following:

APPS
SYNONYM - OKS_BILLING_PROFILES_B
SYNONYM - OKS_BILLING_PROFILES_TL

APPS.OKS_BILLING_PROFILES_V is not referenced by any database object

[top of page]

View: OKS_BILLPRST_SRVLINE_V

[top of page]

APPS.OKS_BILLPRST_SRVLINE_V references the following:

APPS
SYNONYM - OKC_K_HEADERS_B
SYNONYM - OKC_K_ITEMS
SYNONYM - OKC_K_LINES_B
VIEW - OKC_K_LINES_V
VIEW - OKC_LINE_STYLES_V
SYNONYM - OKS_BILL_CONT_LINES
VIEW - OKX_SYSTEM_ITEMS_V
- OKS_K_LINES_V

APPS.OKS_BILLPRST_SRVLINE_V is not referenced by any database object

[top of page]

View: OKS_BILLPRST_SRVSUBLINE_V

[top of page]

APPS.OKS_BILLPRST_SRVSUBLINE_V references the following:

APPS
PACKAGE - ARP_ADDR_LABEL_PKG
PACKAGE - CSICUMPI_PUB
VIEW - CS_CUSTOMER_PRODUCTS
SYNONYM - OKC_K_HEADERS_B
SYNONYM - OKC_K_ITEMS
VIEW - OKC_K_LINES_V
VIEW - OKC_LINE_STYLES_V
SYNONYM - OKS_BILL_SUB_LINES
SYNONYM - OKS_BILL_TXN_LINES
VIEW - OKX_SYSTEMS_V
VIEW - OKX_SYSTEM_ITEMS_V
- OKX_CUST_SITE_USES_V
- OKX_PARTIES_V
- OKX_CUSTOMER_ACCOUNTS_V
- OKS_K_LINES_V

APPS.OKS_BILLPRST_SRVSUBLINE_V is not referenced by any database object

[top of page]

View: OKS_BILLPRST_SUBSCRLINE_V

[top of page]

APPS.OKS_BILLPRST_SUBSCRLINE_V references the following:

APPS
SYNONYM - OKC_K_HEADERS_B
SYNONYM - OKC_K_ITEMS
VIEW - OKC_K_LINES_V
VIEW - OKC_LINE_STYLES_V
SYNONYM - OKS_BILL_CONT_LINES
VIEW - OKX_SYSTEM_ITEMS_V
- OKS_K_LINES_V

APPS.OKS_BILLPRST_SUBSCRLINE_V is not referenced by any database object

[top of page]

View: OKS_BILLPRST_USGDRILL_V

[top of page]

APPS.OKS_BILLPRST_USGDRILL_V references the following:

APPS
SYNONYM - OKS_BILL_SUB_LINES
SYNONYM - OKS_BILL_SUB_LINE_DTLS

APPS.OKS_BILLPRST_USGDRILL_V is not referenced by any database object

[top of page]

View: OKS_BILLPRST_USGSUBLINE_V

[top of page]

APPS.OKS_BILLPRST_USGSUBLINE_V references the following:

APPS
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - OKC_K_HEADERS_B
SYNONYM - OKC_K_ITEMS
VIEW - OKC_K_LINES_V
PACKAGE - OKS_AUTH_UTIL_PVT
SYNONYM - OKS_BILL_SUB_LINES
SYNONYM - OKS_BILL_TXN_LINES
VIEW - OKX_COUNTERS_V
VIEW - OKX_COUNTER_GROUPS_V
VIEW - OKX_SYSTEM_ITEMS_V
- OKS_K_LINES_V

APPS.OKS_BILLPRST_USGSUBLINE_V is not referenced by any database object

[top of page]

View: OKS_BILLRATE_SCHEDULES_V

[top of page]

APPS.OKS_BILLRATE_SCHEDULES_V references the following:

APPS
SYNONYM - OKS_BILLRATE_SCHEDULES

APPS.OKS_BILLRATE_SCHEDULES_V is not referenced by any database object

[top of page]

View: OKS_BILL_CONT_LINES_V

[top of page]

APPS.OKS_BILL_CONT_LINES_V references the following:

APPS
SYNONYM - OKS_BILL_CONT_LINES

APPS.OKS_BILL_CONT_LINES_V is not referenced by any database object

[top of page]

View: OKS_BILL_SUBLINE_DTLS_V

[top of page]

APPS.OKS_BILL_SUBLINE_DTLS_V references the following:

APPS
SYNONYM - OKS_BILL_SUB_LINE_DTLS

APPS.OKS_BILL_SUBLINE_DTLS_V is not referenced by any database object

[top of page]

View: OKS_BILL_SUB_LINES_V

[top of page]

APPS.OKS_BILL_SUB_LINES_V references the following:

APPS
SYNONYM - OKS_BILL_SUB_LINES

APPS.OKS_BILL_SUB_LINES_V is not referenced by any database object

[top of page]

View: OKS_BILL_TRANSACTIONS_V

[top of page]

APPS.OKS_BILL_TRANSACTIONS_V references the following:

APPS
SYNONYM - OKS_BILL_TRANSACTIONS

APPS.OKS_BILL_TRANSACTIONS_V is not referenced by any database object

[top of page]

View: OKS_BILL_TXN_LINES_V

[top of page]

APPS.OKS_BILL_TXN_LINES_V references the following:

APPS
SYNONYM - OKS_BILL_TXN_LINES

APPS.OKS_BILL_TXN_LINES_V is not referenced by any database object

[top of page]

View: OKS_BSD_PR_V

[top of page]

APPS.OKS_BSD_PR_V references the following:

APPS
SYNONYM - OKS_BILL_SUB_LINE_DTLS

APPS.OKS_BSD_PR_V is not referenced by any database object

[top of page]

View: OKS_BSL_PR_V

[top of page]

APPS.OKS_BSL_PR_V references the following:

APPS
SYNONYM - OKS_BILL_SUB_LINES

APPS.OKS_BSL_PR_V is not referenced by any database object

[top of page]

View: OKS_BTL_PR_V

[top of page]

APPS.OKS_BTL_PR_V references the following:

APPS
SYNONYM - OKS_BILL_TXN_LINES

APPS.OKS_BTL_PR_V is not referenced by any database object

[top of page]

View: OKS_BTN_PR_V

[top of page]

APPS.OKS_BTN_PR_V references the following:

APPS
SYNONYM - OKS_BILL_TRANSACTIONS

APPS.OKS_BTN_PR_V is not referenced by any database object

[top of page]

View: OKS_BUS_PROCESSES_HV

[top of page]

APPS.OKS_BUS_PROCESSES_HV references the following:

APPS
SYNONYM - JTF_OBJECTS_B
SYNONYM - OKC_K_ITEMS_H
SYNONYM - OKC_K_LINES_BH
- OKX_BUS_PROCESSES_V

APPS.OKS_BUS_PROCESSES_HV is not referenced by any database object

[top of page]

View: OKS_BUS_PROCESSES_V

[top of page]

APPS.OKS_BUS_PROCESSES_V references the following:

APPS
SYNONYM - JTF_OBJECTS_B
SYNONYM - OKC_K_ITEMS
SYNONYM - OKC_K_LINES_B
- OKX_BUS_PROCESSES_V

APPS.OKS_BUS_PROCESSES_V is not referenced by any database object

[top of page]

View: OKS_CONTACT_POINTS_V

[top of page]

APPS.OKS_CONTACT_POINTS_V references the following:

- OKX_CONTACT_POINTS_V

APPS.OKS_CONTACT_POINTS_V is not referenced by any database object

[top of page]

View: OKS_CONTACT_V

[top of page]

APPS.OKS_CONTACT_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
VIEW - OKC_CONTACT_SOURCES_V
VIEW - OKS_K_ORDER_CONTACTS_V
- OKX_PARTY_CONTACTS_V

APPS.OKS_CONTACT_V is not referenced by any database object

[top of page]

View: OKS_CONTRACTS_V

[top of page]

APPS.OKS_CONTRACTS_V references the following:

APPS
SYNONYM - OKC_K_HEADERS_B
SYNONYM - OKC_K_LINES_B
SYNONYM - OKC_K_PARTY_ROLES_B
SYNONYM - OKC_STATUSES_B
SYNONYM - OKS_K_HEADERS_B

APPS.OKS_CONTRACTS_V is not referenced by any database object

[top of page]

View: OKS_CONTRACT_DTLS_V

[top of page]

APPS.OKS_CONTRACT_DTLS_V references the following:

APPS
PACKAGE - ARP_ADDR_LABEL_PKG
PACKAGE - CSICUMPI_PUB
PACKAGE - OKC_UTIL
VIEW - OKS_BILLING_DTLS_V
VIEW - OKS_HEADER_DETAILS_V
VIEW - OKS_LINE_DETAILS_V
VIEW - OKS_PROD_DETAILS_V

APPS.OKS_CONTRACT_DTLS_V is not referenced by any database object

[top of page]

View: OKS_CONTRACT_MODIFIER_V

[top of page]

APPS.OKS_CONTRACT_MODIFIER_V references the following:

APPS
SYNONYM - OKC_K_HEADERS_B

APPS.OKS_CONTRACT_MODIFIER_V is not referenced by any database object

[top of page]

View: OKS_CONTRACT_NUMBER_V

[top of page]

APPS.OKS_CONTRACT_NUMBER_V references the following:

APPS
SYNONYM - OKC_K_HEADERS_B
SYNONYM - OKC_K_HEADERS_TL

APPS.OKS_CONTRACT_NUMBER_V is not referenced by any database object

[top of page]

View: OKS_CONTRACT_PARTIES_V

[top of page]

APPS.OKS_CONTRACT_PARTIES_V references the following:

APPS
SYNONYM - HZ_PARTIES

APPS.OKS_CONTRACT_PARTIES_V is not referenced by any database object

[top of page]

View: OKS_CONT_HEADERS_V

[top of page]

APPS.OKS_CONT_HEADERS_V references the following:

APPS
VIEW - OKC_K_HEADERS_V
PACKAGE - OKC_UTIL

APPS.OKS_CONT_HEADERS_V is not referenced by any database object

[top of page]

View: OKS_COUNTERS_V

[top of page]

APPS.OKS_COUNTERS_V references the following:

APPS
PACKAGE - OKS_AUTH_UTIL_PVT
VIEW - OKX_COUNTERS_V
VIEW - OKX_COUNTER_GROUPS_V

APPS.OKS_COUNTERS_V is not referenced by any database object

[top of page]

View: OKS_COVDLEVEL_DETAILS_V

[top of page]

APPS.OKS_COVDLEVEL_DETAILS_V references the following:

APPS
SYNONYM - OKC_K_LINES_B
VIEW - OKC_K_LINES_V
VIEW - OKC_LINE_STYLES_V

APPS.OKS_COVDLEVEL_DETAILS_V is not referenced by any database object

[top of page]

View: OKS_COVERAGES_HV

[top of page]

APPS.OKS_COVERAGES_HV references the following:

APPS
SYNONYM - OKC_K_LINES_BH
SYNONYM - OKC_K_LINES_TLH

APPS.OKS_COVERAGES_HV is not referenced by any database object

[top of page]

View: OKS_COVERAGES_V

[top of page]

APPS.OKS_COVERAGES_V references the following:

APPS
SYNONYM - OKC_K_LINES_B
SYNONYM - OKC_K_LINES_TL

APPS.OKS_COVERAGES_V is not referenced by any database object

[top of page]

View: OKS_COVERAGE_TEMPLTS_V

[top of page]

APPS.OKS_COVERAGE_TEMPLTS_V references the following:

APPS
SYNONYM - OKC_K_LINES_B
SYNONYM - OKC_K_LINES_TL
VIEW - OKS_SUBSCR_HEADER_V
APPS.OKS_COVERAGE_TEMPLTS_V is referenced by following:

APPS
VIEW - OE_AK_SRV_TEMPLATE_V

[top of page]

View: OKS_COVERAGE_TIMES_V

[top of page]

APPS.OKS_COVERAGE_TIMES_V references the following:

APPS
SYNONYM - OKS_COVERAGE_TIMES

APPS.OKS_COVERAGE_TIMES_V is not referenced by any database object

[top of page]

View: OKS_COVERAGE_TIMEZONES_V

[top of page]

APPS.OKS_COVERAGE_TIMEZONES_V references the following:

APPS
SYNONYM - OKS_COVERAGE_TIMEZONES

APPS.OKS_COVERAGE_TIMEZONES_V is not referenced by any database object

[top of page]

View: OKS_COVERED_LEVEL_V

[top of page]

APPS.OKS_COVERED_LEVEL_V references the following:

APPS
SYNONYM - OKC_K_HEADERS_B
SYNONYM - OKC_K_ITEMS
SYNONYM - OKC_K_LINES_B
VIEW - OKX_SYSTEM_ITEMS_V

APPS.OKS_COVERED_LEVEL_V is not referenced by any database object

[top of page]

View: OKS_COV_ACTION_TIMES_V

[top of page]

APPS.OKS_COV_ACTION_TIMES_V references the following:

APPS
SYNONYM - OKC_K_LINES_B
SYNONYM - OKS_ACTION_TIMES
SYNONYM - OKS_ACTION_TIME_TYPES
- OKS_K_LINES_V

APPS.OKS_COV_ACTION_TIMES_V is not referenced by any database object

[top of page]

View: OKS_COV_TYPES_V

[top of page]

APPS.OKS_COV_TYPES_V references the following:

APPS
SYNONYM - OKS_COV_TYPES_B
SYNONYM - OKS_COV_TYPES_TL

APPS.OKS_COV_TYPES_V is not referenced by any database object

[top of page]

View: OKS_CUST_PRODUCTS_V

[top of page]

APPS.OKS_CUST_PRODUCTS_V references the following:

APPS
PACKAGE - ARP_ADDR_LABEL_PKG
PACKAGE - CSICUMPI_PUB
VIEW - OKC_K_ITEMS_V
VIEW - OKC_K_LINES_V
VIEW - OKX_CUSTOMER_PRODUCTS_V
- OKX_PARTY_SITE_USES_V

APPS.OKS_CUST_PRODUCTS_V is not referenced by any database object

[top of page]

View: OKS_DOCUMENT_VERSIONS_V

[top of page]

APPS.OKS_DOCUMENT_VERSIONS_V references the following:

APPS
SYNONYM - OKC_K_HEADERS_B
SYNONYM - OKC_K_HEADERS_BH
SYNONYM - OKC_K_VERS_NUMBERS
VIEW - OKC_SUBCLASSES_V

APPS.OKS_DOCUMENT_VERSIONS_V is not referenced by any database object

[top of page]

View: OKS_ENT_BILL_RATES_V

[top of page]

APPS.OKS_ENT_BILL_RATES_V references the following:

APPS
SYNONYM - OKC_K_LINES_B
SYNONYM - OKS_BILLRATE_SCHEDULES
PACKAGE - OKS_ENT_UTIL_PVT

APPS.OKS_ENT_BILL_RATES_V is not referenced by any database object

[top of page]

View: OKS_ENT_BILL_TYPES_V

[top of page]

APPS.OKS_ENT_BILL_TYPES_V references the following:

APPS
SYNONYM - OKC_K_ITEMS
SYNONYM - OKC_K_LINES_B
SYNONYM - OKS_K_LINES_B
- OKX_TXN_BILLING_TYPES_V

APPS.OKS_ENT_BILL_TYPES_V is not referenced by any database object

[top of page]

View: OKS_ENT_COVD_LEVELS_V

[top of page]

APPS.OKS_ENT_COVD_LEVELS_V references the following:

APPS
SYNONYM - OKC_K_ITEMS
SYNONYM - OKC_K_LINES_B
SYNONYM - OKC_LINE_STYLES_B
SYNONYM - OKC_LINE_STYLES_TL

APPS.OKS_ENT_COVD_LEVELS_V is not referenced by any database object

[top of page]

View: OKS_ENT_COVERAGES_V

[top of page]

APPS.OKS_ENT_COVERAGES_V references the following:

APPS
SYNONYM - OKC_K_HEADERS_ALL_B
SYNONYM - OKC_K_ITEMS
SYNONYM - OKC_K_LINES_B
SYNONYM - OKC_K_LINES_TL
SYNONYM - OKS_COV_TYPES_TL
SYNONYM - OKS_K_LINES_B

APPS.OKS_ENT_COVERAGES_V is not referenced by any database object

[top of page]

View: OKS_ENT_COVER_TIMES_V

[top of page]

APPS.OKS_ENT_COVER_TIMES_V references the following:

APPS
SYNONYM - OKC_K_ITEMS
SYNONYM - OKC_K_LINES_B
SYNONYM - OKS_COVERAGE_TIMES
SYNONYM - OKS_COVERAGE_TIMEZONES
- OKX_TIMEZONES_V
- OKX_BUS_PROCESSES_V

APPS.OKS_ENT_COVER_TIMES_V is not referenced by any database object

[top of page]

View: OKS_ENT_HDR_SUMMARY_V

[top of page]

APPS.OKS_ENT_HDR_SUMMARY_V references the following:

APPS
SYNONYM - OKC_K_HEADERS_ALL_B
SYNONYM - OKC_K_PARTY_ROLES_B
SYNONYM - OKC_SUBCLASSES_B

APPS.OKS_ENT_HDR_SUMMARY_V is not referenced by any database object

[top of page]

View: OKS_ENT_HEADERS_V

[top of page]

APPS.OKS_ENT_HEADERS_V references the following:

APPS
SYNONYM - OKC_K_HEADERS_ALL_B
SYNONYM - OKC_K_HEADERS_TL
SYNONYM - OKC_K_PARTY_ROLES_B
PACKAGE - OKS_ENT_UTIL_PVT
SYNONYM - OKS_K_HEADERS_B

APPS.OKS_ENT_HEADERS_V is not referenced by any database object

[top of page]

View: OKS_ENT_K_STATUS_V

[top of page]

APPS.OKS_ENT_K_STATUS_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - OKC_K_HEADERS_ALL_B

APPS.OKS_ENT_K_STATUS_V is not referenced by any database object

[top of page]

View: OKS_ENT_LINE_DETAILS_V

[top of page]

APPS.OKS_ENT_LINE_DETAILS_V references the following:

APPS
VIEW - MTL_SYSTEM_ITEMS_B_KFV
SYNONYM - OKC_K_HEADERS_ALL_B
SYNONYM - OKC_K_ITEMS
SYNONYM - OKC_K_LINES_B
VIEW - OKC_K_LINES_V
SYNONYM - OKS_K_LINES_B

APPS.OKS_ENT_LINE_DETAILS_V is not referenced by any database object

[top of page]

View: OKS_ENT_PARTY_CONT_V

[top of page]

APPS.OKS_ENT_PARTY_CONT_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - OKC_CONTACTS
SYNONYM - OKC_K_HEADERS_ALL_B
SYNONYM - OKC_K_PARTY_ROLES_B

APPS.OKS_ENT_PARTY_CONT_V is not referenced by any database object

[top of page]

View: OKS_ENT_REACT_TIME_H_V

[top of page]

APPS.OKS_ENT_REACT_TIME_H_V references the following:

APPS
SYNONYM - OKC_K_LINES_B
SYNONYM - OKC_K_LINES_TL
SYNONYM - OKS_ACTION_TIME_TYPES
- OKX_INCIDENT_SEVERITS_V
- OKS_K_LINES_V

APPS.OKS_ENT_REACT_TIME_H_V is not referenced by any database object

[top of page]

View: OKS_ENT_REACT_TIME_L_V

[top of page]

APPS.OKS_ENT_REACT_TIME_L_V references the following:

APPS
SYNONYM - OKS_ACTION_TIMES
SYNONYM - OKS_ACTION_TIME_TYPES

APPS.OKS_ENT_REACT_TIME_L_V is not referenced by any database object

[top of page]

View: OKS_ENT_TXN_GROUPS_V

[top of page]

APPS.OKS_ENT_TXN_GROUPS_V references the following:

APPS
SYNONYM - OKC_K_ITEMS
SYNONYM - OKC_K_LINES_B
PACKAGE - OKS_ENTITLEMENTS_PVT
SYNONYM - OKS_K_LINES_B
- OKX_BUS_PROCESSES_V

APPS.OKS_ENT_TXN_GROUPS_V is not referenced by any database object

[top of page]

View: OKS_EVENTS_V

[top of page]

APPS.OKS_EVENTS_V references the following:

APPS
SYNONYM - OKC_CONDITION_HEADERS_B
SYNONYM - OKC_CONDITION_HEADERS_TL

APPS.OKS_EVENTS_V is not referenced by any database object

[top of page]

View: OKS_EXPIRED_CONTRACTS_V

[top of page]

APPS.OKS_EXPIRED_CONTRACTS_V references the following:

APPS
PACKAGE - CSICUMPI_PUB
SYNONYM - CS_CUSTOMER_PRODUCTS_ALL
SYNONYM - HZ_PARTIES
SYNONYM - OKC_CONTACTS
SYNONYM - OKC_K_HEADERS_B
SYNONYM - OKC_K_ITEMS
SYNONYM - OKC_K_LINES_B
SYNONYM - OKC_K_PARTY_ROLES_B
SYNONYM - OKC_STATUSES_B
- OKS_EXTWAR_UTIL_PVT

APPS.OKS_EXPIRED_CONTRACTS_V is not referenced by any database object

[top of page]

View: OKS_HEADERS_V

[top of page]

APPS.OKS_HEADERS_V references the following:

APPS
PACKAGE - ARP_ADDR_LABEL_PKG
PACKAGE - FND_GLOBAL
SYNONYM - HZ_PARTIES
VIEW - OKC_K_HEADERS_V
VIEW - OKC_K_PARTY_ROLES_V
PACKAGE - OKC_UTIL
- OKX_CUST_SITE_USES_V

APPS.OKS_HEADERS_V is not referenced by any database object

[top of page]

View: OKS_HEADER_DETAILS_V

[top of page]

APPS.OKS_HEADER_DETAILS_V references the following:

APPS
PACKAGE - ARP_ADDR_LABEL_PKG
SYNONYM - HZ_PARTIES
VIEW - OKC_K_HEADERS_V
SYNONYM - OKC_K_PARTY_ROLES_B
VIEW - OKC_STATUSES_V
PACKAGE - OKC_UTIL
- OKX_CUST_SITE_USES_V
APPS.OKS_HEADER_DETAILS_V is referenced by following:

APPS
VIEW - OKS_CONTRACT_DTLS_V

[top of page]

View: OKS_INSTANCE_HISTORY_V

[top of page]

APPS.OKS_INSTANCE_HISTORY_V references the following:

APPS
SYNONYM - OKS_INSTANCE_HISTORY

APPS.OKS_INSTANCE_HISTORY_V is not referenced by any database object

[top of page]

View: OKS_INST_HIST_DETAILS_V

[top of page]

APPS.OKS_INST_HIST_DETAILS_V references the following:

APPS
SYNONYM - OKS_INST_HIST_DETAILS
APPS.OKS_INST_HIST_DETAILS_V is referenced by following:

APPS
PACKAGE - OKS_IHD_PVT

[top of page]

View: OKS_INST_HIST_V

[top of page]

APPS.OKS_INST_HIST_V references the following:

APPS
SYNONYM - OKS_INST_HIST_DETAILS

APPS.OKS_INST_HIST_V is not referenced by any database object

[top of page]

View: OKS_INTERACTION_HIST_V

[top of page]

APPS.OKS_INTERACTION_HIST_V references the following:

APPS
SYNONYM - OKS_INTERACTION_HISTORY

APPS.OKS_INTERACTION_HIST_V is not referenced by any database object

[top of page]

View: OKS_INV_RVW_V

[top of page]

APPS.OKS_INV_RVW_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - OKS_BILL_CONT_LINES
SYNONYM - OKS_BILL_SUB_LINES
SYNONYM - OKS_BILL_TRANSACTIONS
SYNONYM - OKS_BILL_TXN_LINES

APPS.OKS_INV_RVW_V is not referenced by any database object

[top of page]

View: OKS_K_CATEGORIES_V

[top of page]

APPS.OKS_K_CATEGORIES_V references the following:

APPS
VIEW - OKC_SUBCLASSES_V

APPS.OKS_K_CATEGORIES_V is not referenced by any database object

[top of page]

View: OKS_K_DEFAULTS_V

[top of page]

APPS.OKS_K_DEFAULTS_V references the following:

APPS
SYNONYM - OKS_K_DEFAULTS

APPS.OKS_K_DEFAULTS_V is not referenced by any database object

[top of page]

View: OKS_K_DETAIL_V

[top of page]

APPS.OKS_K_DETAIL_V references the following:

APPS
VIEW - OKC_K_HEADERS_V
PACKAGE - OKC_UTIL
VIEW - OKS_K_ORDER_DETAILS_V

APPS.OKS_K_DETAIL_V is not referenced by any database object

[top of page]

View: OKS_K_GROUPS_V

[top of page]

APPS.OKS_K_GROUPS_V references the following:

APPS
VIEW - OKC_K_GROUPS_V

APPS.OKS_K_GROUPS_V is not referenced by any database object

[top of page]

View: OKS_K_HEADERS_HV

[top of page]

APPS.OKS_K_HEADERS_HV references the following:

APPS
SYNONYM - OKS_K_HEADERS_BH

APPS.OKS_K_HEADERS_HV is not referenced by any database object

[top of page]

View: OKS_K_HEADERS_V

[top of page]

APPS.OKS_K_HEADERS_V references the following:

APPS
SYNONYM - OKS_K_HEADERS_B
APPS.OKS_K_HEADERS_V is referenced by following:

APPS
PACKAGE - OKS_CONTRACT_HDR_PUB
PACKAGE - OKS_KHR_PVT

[top of page]

View: OKS_K_LINES_HV

[top of page]

APPS.OKS_K_LINES_HV references the following:

APPS
SYNONYM - OKS_K_LINES_BH
SYNONYM - OKS_K_LINES_TLH
APPS.OKS_K_LINES_HV is referenced by following:

APPS
VIEW - OKS_COV_ACTION_TIMES_HV

[top of page]

View: OKS_K_LINES_V

[top of page]

APPS.OKS_K_LINES_V references the following:

APPS
SYNONYM - OKS_K_LINES_B
SYNONYM - OKS_K_LINES_TL
APPS.OKS_K_LINES_V is referenced by following:

APPS
PACKAGE - OKS_CONTRACT_LINE_PUB
PACKAGE - OKS_KLN_PVT

[top of page]

View: OKS_K_ORDER_CONTACTS_V

[top of page]

APPS.OKS_K_ORDER_CONTACTS_V references the following:

APPS
SYNONYM - OKS_K_ORDER_CONTACTS
APPS.OKS_K_ORDER_CONTACTS_V is referenced by following:

APPS
VIEW - OKS_CONTACT_V

[top of page]

View: OKS_K_ORDER_DETAILS_V

[top of page]

APPS.OKS_K_ORDER_DETAILS_V references the following:

APPS
SYNONYM - OKS_K_ORDER_DETAILS
APPS.OKS_K_ORDER_DETAILS_V is referenced by following:

APPS
VIEW - OKS_K_DETAIL_V

[top of page]

View: OKS_K_SALES_CREDITS_V

[top of page]

APPS.OKS_K_SALES_CREDITS_V references the following:

APPS
SYNONYM - OKS_K_SALES_CREDITS
APPS.OKS_K_SALES_CREDITS_V is referenced by following:

APPS
VIEW - OKS_VRM_SALESCREDIT_V

[top of page]

View: OKS_LEVEL_ELEMENTS_V

[top of page]

APPS.OKS_LEVEL_ELEMENTS_V references the following:

APPS
SYNONYM - OKS_LEVEL_ELEMENTS

APPS.OKS_LEVEL_ELEMENTS_V is not referenced by any database object

[top of page]

View: OKS_LINES_V

[top of page]

APPS.OKS_LINES_V references the following:

APPS
PACKAGE - ARP_ADDR_LABEL_PKG
VIEW - OKC_K_HEADERS_V
VIEW - OKC_K_LINES_V
PACKAGE - OKC_UTIL
- OKX_CUST_SITE_USES_V
- OKX_CUSTOMER_ACCOUNTS_V

APPS.OKS_LINES_V is not referenced by any database object

[top of page]

View: OKS_LINE_DETAILS_V

[top of page]

APPS.OKS_LINE_DETAILS_V references the following:

APPS
PACKAGE - ARP_ADDR_LABEL_PKG
SYNONYM - OKC_K_ITEMS
VIEW - OKC_K_LINES_V
VIEW - OKX_SYSTEM_ITEMS_V
- OKX_CUST_SITE_USES_V
- OKX_CUSTOMER_ACCOUNTS_V
APPS.OKS_LINE_DETAILS_V is referenced by following:

APPS
VIEW - OKS_CONTRACT_DTLS_V

[top of page]

View: OKS_MASSCHANGE_CRITERIA_V

[top of page]

APPS.OKS_MASSCHANGE_CRITERIA_V references the following:

APPS
VIEW - OKC_MASSCHANGE_REQ_DTLS_V
VIEW - OKC_OPERATION_INSTANCES_V

APPS.OKS_MASSCHANGE_CRITERIA_V is not referenced by any database object

[top of page]

View: OKS_MSCHG_OPERATIONS_DTLS_V

[top of page]

APPS.OKS_MSCHG_OPERATIONS_DTLS_V references the following:

APPS
SYNONYM - OKS_MSCHG_OPERATIONS_DTLS

APPS.OKS_MSCHG_OPERATIONS_DTLS_V is not referenced by any database object

[top of page]

View: OKS_NOTE_SOURCES_V

[top of page]

APPS.OKS_NOTE_SOURCES_V references the following:

APPS
VIEW - OKC_K_HEADERS_V
SYNONYM - OKC_K_LINES_B
VIEW - OKC_K_LINES_V
PACKAGE - OKC_UTIL

APPS.OKS_NOTE_SOURCES_V is not referenced by any database object

[top of page]

View: OKS_ORDER_V

[top of page]

APPS.OKS_ORDER_V references the following:

APPS
PACKAGE - ASO_ORDER_INT
PACKAGE - OKC_CONTEXT
SYNONYM - OKS_K_ORDER_DETAILS
VIEW - OKX_SYSTEM_ITEMS_V
- OKX_ORDER_HEADERS_V
- OKX_ORDER_LINES_V

APPS.OKS_ORDER_V is not referenced by any database object

[top of page]

View: OKS_PARTIES_V

[top of page]

APPS.OKS_PARTIES_V references the following:

APPS
SYNONYM - HZ_PARTIES
SYNONYM - OKC_K_PARTY_ROLES_B

APPS.OKS_PARTIES_V is not referenced by any database object

[top of page]

View: OKS_PMA_V

[top of page]

APPS.OKS_PMA_V references the following:

APPS
SYNONYM - OKC_RULES_B
SYNONYM - OKC_RULE_GROUPS_B

APPS.OKS_PMA_V is not referenced by any database object

[top of page]

View: OKS_PML_V

[top of page]

APPS.OKS_PML_V references the following:

APPS
SYNONYM - OKC_RULES_B
SYNONYM - OKC_RULE_GROUPS_B

APPS.OKS_PML_V is not referenced by any database object

[top of page]

View: OKS_PM_ACTIVITIES_V

[top of page]

APPS.OKS_PM_ACTIVITIES_V references the following:

APPS
SYNONYM - OKS_PM_ACTIVITIES

APPS.OKS_PM_ACTIVITIES_V is not referenced by any database object

[top of page]

View: OKS_PM_PROGRAM_V

[top of page]

APPS.OKS_PM_PROGRAM_V references the following:

APPS
SYNONYM - OKC_RULES_B
SYNONYM - OKC_RULE_GROUPS_B

APPS.OKS_PM_PROGRAM_V is not referenced by any database object

[top of page]

View: OKS_PM_SCHEDULES_V

[top of page]

APPS.OKS_PM_SCHEDULES_V references the following:

APPS
SYNONYM - OKS_PM_SCHEDULES

APPS.OKS_PM_SCHEDULES_V is not referenced by any database object

[top of page]

View: OKS_PM_STREAM_LEVELS_V

[top of page]

APPS.OKS_PM_STREAM_LEVELS_V references the following:

APPS
SYNONYM - OKS_PM_STREAM_LEVELS

APPS.OKS_PM_STREAM_LEVELS_V is not referenced by any database object

[top of page]

View: OKS_PRICE_BREAKS_HIST_V

[top of page]

APPS.OKS_PRICE_BREAKS_HIST_V references the following:

APPS
SYNONYM - OKS_PRICE_BREAKS

APPS.OKS_PRICE_BREAKS_HIST_V is not referenced by any database object

[top of page]

View: OKS_PRICE_BREAKS_V

[top of page]

APPS.OKS_PRICE_BREAKS_V references the following:

APPS
SYNONYM - OKS_PRICE_BREAKS

APPS.OKS_PRICE_BREAKS_V is not referenced by any database object

[top of page]

View: OKS_PRODUCTS_V

[top of page]

APPS.OKS_PRODUCTS_V references the following:

APPS
VIEW - OKC_K_HEADERS_V
VIEW - OKC_K_ITEMS_V
VIEW - OKC_K_LINES_V
VIEW - OKC_LINE_STYLES_V
PACKAGE - OKC_UTIL

APPS.OKS_PRODUCTS_V is not referenced by any database object

[top of page]

View: OKS_PRODUCT_DETAILS_V

[top of page]

APPS.OKS_PRODUCT_DETAILS_V references the following:

APPS
PACKAGE - ARP_ADDR_LABEL_PKG
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - CSI_I_PRICING_ATTRIBS
VIEW - CSI_SYSTEMS_VL
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - HZ_CUST_ACCOUNTS_ALL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
VIEW - JTF_RS_GROUPS_VL
VIEW - JTF_RS_TEAMS_VL
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - MTL_UNITS_OF_MEASURE_TL
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - OE_ORDER_LINES_ALL
SYNONYM - PER_ALL_PEOPLE_F
VIEW - PO_VENDORS
- PO_VENDOR_SITES_ALL

APPS.OKS_PRODUCT_DETAILS_V is not referenced by any database object

[top of page]

View: OKS_PROD_DETAILS_V

[top of page]

APPS.OKS_PROD_DETAILS_V references the following:

APPS
PACKAGE - ARP_ADDR_LABEL_PKG
PACKAGE - CSICUMPI_PUB
VIEW - CS_CUSTOMER_PRODUCTS
SYNONYM - CS_CUSTOMER_PRODUCTS_ALL
SYNONYM - OKC_K_HEADERS_B
SYNONYM - OKC_K_ITEMS
SYNONYM - OKC_K_LINES_B
SYNONYM - OKC_LINE_STYLES_TL
VIEW - OKX_SYSTEMS_V
VIEW - OKX_SYSTEM_ITEMS_V
- OKX_CUSTOMER_ACCOUNTS_V
- OKX_PARTIES_V
- OKX_CUST_SITE_USES_V
APPS.OKS_PROD_DETAILS_V is referenced by following:

APPS
VIEW - OKS_CONTRACT_DTLS_V

[top of page]

View: OKS_QUALIFIERS_V

[top of page]

APPS.OKS_QUALIFIERS_V references the following:

APPS
SYNONYM - OKS_QUALIFIERS

APPS.OKS_QUALIFIERS_V is not referenced by any database object

[top of page]

View: OKS_REACTION_TIMES_HV

[top of page]

APPS.OKS_REACTION_TIMES_HV references the following:

APPS
SYNONYM - OKC_K_LINES_BH
SYNONYM - OKC_RULES_BH
SYNONYM - OKC_RULE_GROUPS_BH

APPS.OKS_REACTION_TIMES_HV is not referenced by any database object

[top of page]

View: OKS_REACTION_TIMES_V

[top of page]

APPS.OKS_REACTION_TIMES_V references the following:

APPS
SYNONYM - OKC_K_LINES_B
SYNONYM - OKC_RULES_B
SYNONYM - OKC_RULE_GROUPS_B

APPS.OKS_REACTION_TIMES_V is not referenced by any database object

[top of page]

View: OKS_REPNAME_V

[top of page]

APPS.OKS_REPNAME_V references the following:

APPS
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
SYNONYM - HZ_PARTIES
VIEW - OKC_CONTACTS_V
SYNONYM - OKC_K_HEADERS_B
SYNONYM - OKC_K_PARTY_ROLES_B
VIEW - OKC_K_PARTY_ROLES_V
VIEW - OKC_STATUSES_V
- OKS_EXTWAR_UTIL_PVT

APPS.OKS_REPNAME_V is not referenced by any database object

[top of page]

View: OKS_REPORT_TEMPLATES_V

[top of page]

APPS.OKS_REPORT_TEMPLATES_V references the following:

APPS
SYNONYM - OKS_REPORT_TEMPLATES

APPS.OKS_REPORT_TEMPLATES_V is not referenced by any database object

[top of page]

View: OKS_REPROCESSING_V

[top of page]

APPS.OKS_REPROCESSING_V references the following:

APPS
SYNONYM - OKS_REPROCESSING

APPS.OKS_REPROCESSING_V is not referenced by any database object

[top of page]

View: OKS_REP_V

[top of page]

APPS.OKS_REP_V references the following:

APPS
VIEW - JTF_RS_RESOURCE_EXTNS_VL
SYNONYM - JTF_RS_SALESREPS

APPS.OKS_REP_V is not referenced by any database object

[top of page]

View: OKS_RESOURCES_HV

[top of page]

APPS.OKS_RESOURCES_HV references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - OKC_CONTACTS_H
VIEW - OKC_K_PARTY_ROLES_HV

APPS.OKS_RESOURCES_HV is not referenced by any database object

[top of page]

View: OKS_RESOURCES_V

[top of page]

APPS.OKS_RESOURCES_V references the following:

APPS
SYNONYM - OKC_CONTACTS
SYNONYM - OKC_K_PARTY_ROLES_B

APPS.OKS_RESOURCES_V is not referenced by any database object

[top of page]

View: OKS_RESOURCE_GROUPS_V

[top of page]

APPS.OKS_RESOURCE_GROUPS_V references the following:

APPS
VIEW - JTF_RS_GROUPS_VL

APPS.OKS_RESOURCE_GROUPS_V is not referenced by any database object

[top of page]

View: OKS_REV_DISTRIBUTIONS_V

[top of page]

APPS.OKS_REV_DISTRIBUTIONS_V references the following:

APPS
SYNONYM - OKS_REV_DISTRIBUTIONS

APPS.OKS_REV_DISTRIBUTIONS_V is not referenced by any database object

[top of page]

View: OKS_RULES_V

[top of page]

APPS.OKS_RULES_V references the following:

APPS
VIEW - OKC_RULES_V

APPS.OKS_RULES_V is not referenced by any database object

[top of page]

View: OKS_SERVICE_COV_TEMPLTS_V

[top of page]

APPS.OKS_SERVICE_COV_TEMPLTS_V references the following:

APPS
SYNONYM - OKC_K_LINES_B
SYNONYM - OKC_K_LINES_TL

APPS.OKS_SERVICE_COV_TEMPLTS_V is not referenced by any database object

[top of page]

View: OKS_SERV_AVAILS_V

[top of page]

APPS.OKS_SERV_AVAILS_V references the following:

APPS
SYNONYM - OKS_SERV_AVAILS

APPS.OKS_SERV_AVAILS_V is not referenced by any database object

[top of page]

View: OKS_SERV_AVAIL_EXCEPTS_V

[top of page]

APPS.OKS_SERV_AVAIL_EXCEPTS_V references the following:

APPS
SYNONYM - OKS_SERV_AVAIL_EXCEPTS

APPS.OKS_SERV_AVAIL_EXCEPTS_V is not referenced by any database object

[top of page]

View: OKS_SERV_CUSTEXC_V

[top of page]

APPS.OKS_SERV_CUSTEXC_V references the following:

APPS
SYNONYM - OKS_SERV_AVAIL_EXCEPTS
- OKX_PARTIES_V

APPS.OKS_SERV_CUSTEXC_V is not referenced by any database object

[top of page]

View: OKS_SERV_HDR_V

[top of page]

APPS.OKS_SERV_HDR_V references the following:

APPS
SYNONYM - OKS_SERV_AVAILS
VIEW - OKX_SYSTEM_ITEMS_V

APPS.OKS_SERV_HDR_V is not referenced by any database object

[top of page]

View: OKS_SERV_PRODEXC_V

[top of page]

APPS.OKS_SERV_PRODEXC_V references the following:

APPS
SYNONYM - OKS_SERV_AVAIL_EXCEPTS
VIEW - OKX_SYSTEM_ITEMS_V

APPS.OKS_SERV_PRODEXC_V is not referenced by any database object

[top of page]

View: OKS_STREAM_LEVELS_V

[top of page]

APPS.OKS_STREAM_LEVELS_V references the following:

APPS
SYNONYM - OKS_STREAM_LEVELS_B

APPS.OKS_STREAM_LEVELS_V is not referenced by any database object

[top of page]

View: OKS_STREAM_V

[top of page]

APPS.OKS_STREAM_V references the following:

APPS
VIEW - OKS_STRM_TYPE_V

APPS.OKS_STREAM_V is not referenced by any database object

[top of page]

View: OKS_STRM_TYPE_V

[top of page]

APPS.OKS_STRM_TYPE_V references the following:

APPS
SYNONYM - OKS_STRM_TYPE
APPS.OKS_STRM_TYPE_V is referenced by following:

APPS
VIEW - OKS_STREAM_V

[top of page]

View: OKS_SUBSCR_ELEMENTS_V

[top of page]

APPS.OKS_SUBSCR_ELEMENTS_V references the following:

APPS
SYNONYM - OKS_SUBSCR_ELEMENTS

APPS.OKS_SUBSCR_ELEMENTS_V is not referenced by any database object

[top of page]

View: OKS_SUBSCR_HEADER_V

[top of page]

APPS.OKS_SUBSCR_HEADER_V references the following:

APPS
SYNONYM - OKS_SUBSCR_HEADER_B
SYNONYM - OKS_SUBSCR_HEADER_TL
APPS.OKS_SUBSCR_HEADER_V is referenced by following:

APPS
VIEW - OKS_COVERAGE_TEMPLTS_V

[top of page]

View: OKS_SUBSCR_PATTERNS_V

[top of page]

APPS.OKS_SUBSCR_PATTERNS_V references the following:

APPS
SYNONYM - OKS_SUBSCR_PATTERNS

APPS.OKS_SUBSCR_PATTERNS_V is not referenced by any database object

[top of page]

View: OKS_TEMPLATE_COUNTERS_V

[top of page]

APPS.OKS_TEMPLATE_COUNTERS_V references the following:

APPS
PACKAGE - OKS_AUTH_UTIL_PVT
VIEW - OKX_COUNTERS_V
VIEW - OKX_COUNTER_GROUPS_V
VIEW - OKX_CTR_ASSOCIATIONS_V

APPS.OKS_TEMPLATE_COUNTERS_V is not referenced by any database object

[top of page]

View: OKS_TEMPLATE_SET_V

[top of page]

APPS.OKS_TEMPLATE_SET_V references the following:

APPS
SYNONYM - OKS_TEMPLATE_SET

APPS.OKS_TEMPLATE_SET_V is not referenced by any database object

[top of page]

View: OKS_TIMEVALUES_V

[top of page]

APPS.OKS_TIMEVALUES_V references the following:

APPS
VIEW - OKC_TIMEVALUES_V

APPS.OKS_TIMEVALUES_V is not referenced by any database object

[top of page]

View: OKS_TIME_CODE_UNITS_V

[top of page]

APPS.OKS_TIME_CODE_UNITS_V references the following:

APPS
VIEW - OKC_TIME_CODE_UNITS_V

APPS.OKS_TIME_CODE_UNITS_V is not referenced by any database object

[top of page]

View: OKS_USAGE_COUNTERS_V

[top of page]

APPS.OKS_USAGE_COUNTERS_V references the following:

APPS
SYNONYM - CSI_COUNTERS_B
SYNONYM - CSI_COUNTERS_TL
SYNONYM - CSI_COUNTER_ASSOCIATIONS
SYNONYM - CSI_COUNTER_READINGS
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - CS_CSI_COUNTER_GROUPS
PACKAGE - OKC_CONTEXT
VIEW - OKC_K_HEADERS_V
VIEW - OKC_K_LINES_V
PACKAGE - OKC_UTIL
PACKAGE - OKS_AUTH_UTIL_PVT
VIEW - OKX_SYSTEM_ITEMS_V

APPS.OKS_USAGE_COUNTERS_V is not referenced by any database object

[top of page]

View: OKS_USAGE_ITEM_V

[top of page]

APPS.OKS_USAGE_ITEM_V references the following:

APPS
SYNONYM - CSI_COUNTERS_B
SYNONYM - CSI_COUNTERS_TL
SYNONYM - CSI_COUNTER_ASSOCIATIONS
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - CS_CSI_COUNTER_GROUPS
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - OKC_K_HEADERS_B
SYNONYM - OKC_K_ITEMS
VIEW - OKC_K_LINES_V

APPS.OKS_USAGE_ITEM_V is not referenced by any database object

[top of page]



Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract