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 - CLN Tables and Views

TABLE - CLN.CLN_AP_INVOICE_REJECTION_ARCH
TABLE - CLN.CLN_CH_COLL_PROPERTIES
TABLE - CLN.CLN_CH_DISPLAY_LABELS_DTL_B
TABLE - CLN.CLN_CH_DISPLAY_LABELS_DTL_TL
TABLE - CLN.CLN_CH_DISPLAY_LABELS_HDR
TABLE - CLN.CLN_CH_XMLGTXN_MAPPING
TABLE - CLN.CLN_COLL_COMPLETED_STATUS
TABLE - CLN.CLN_COLL_HIST_DTL
TABLE - CLN.CLN_COLL_HIST_HDR
TABLE - CLN.CLN_COLL_MESSAGES
TABLE - CLN.CLN_CST_DTLS_TEMP
TABLE - CLN.CLN_ITEMMST_DELETED_ITEMS
TABLE - CLN.CLN_NOTIFICATION_ACTION_DTL
TABLE - CLN.CLN_NOTIFICATION_ACTION_HDR
TABLE - CLN.CLN_NOTIFICATION_CODES_B
TABLE - CLN.CLN_NOTIFICATION_CODES_TL
TABLE - CLN.CLN_RN_VALIDATIONS
TABLE - CLN.M4R_WSM_DWIP_HDR_STAGING
TABLE - CLN.M4R_WSM_DWIP_LOT_QTY_STAGING
TABLE - CLN.M4R_WSM_DWIP_MSG_STAGING
VIEW - APPS.CLN_3C3_INVOICE_LINE_V
VIEW - APPS.CLN_3C3_INVOICE_V
VIEW - APPS.CLN_CH_DISPLAY_LABELS_DTL_VL
VIEW - APPS.CLN_INVENTORY_REPORT_V
VIEW - APPS.CLN_INV_CATEGORY_V
VIEW - APPS.CLN_INV_ITEM_REVISIONS_V
VIEW - APPS.CLN_INV_LOT_NUM_V
VIEW - APPS.CLN_ITEMMST_ABC_V
VIEW - APPS.CLN_ITEMMST_CTLG_CATS_V
VIEW - APPS.CLN_ITEMMST_CUSTOMER_V
VIEW - APPS.CLN_ITEMMST_INVENTORY_ORGS_V
VIEW - APPS.CLN_ITEMMST_ITEMCATEGORY_V
VIEW - APPS.CLN_ITEMMST_ITEMHEADER_V
VIEW - APPS.CLN_ITEMMST_ITEMVALUE_V
VIEW - APPS.CLN_ITEMMST_ITEM_CATEGORIES_V
VIEW - APPS.CLN_ITEMMST_ITEM_CAT_SETS_V
VIEW - APPS.CLN_ITEMMST_ITEM_STATUSES_V
VIEW - APPS.CLN_ITEMMST_SUPPLIER_V
VIEW - APPS.CLN_ITEMMST_TRADING_PARTNERS_V
VIEW - APPS.CLN_NOTIFICATION_CODES_VL
VIEW - APPS.CLN_PO_CHANGE_RESPONSE_LINE_V
VIEW - APPS.CLN_PO_ECX_LINE_LOC_ARCH_V
VIEW - APPS.CLN_PROCAT_AUTHORIZATION_V
VIEW - APPS.CLN_PROCAT_CATALOG_V
VIEW - APPS.CLN_PROCAT_CATITEM_V
VIEW - APPS.CLN_PROCAT_CURRENCIES_V
VIEW - APPS.CLN_PROCAT_CUSTOMER_V
VIEW - APPS.CLN_PROCAT_ITEMCATEGORY_V
VIEW - APPS.CLN_PROCAT_ITEM_CATEGORIES_V
VIEW - APPS.CLN_PROCAT_PRICE_LISTS_V
VIEW - APPS.CLN_PROCAT_PUBLISHER_V
VIEW - APPS.CLN_PROCAT_TRADING_PARTNERS_V
VIEW - APPS.CLN_PROCAT_VOLPRICEBREAK_V
VIEW - APPS.CLN_RN_UTIL_FROM_ROLE2_V
VIEW - APPS.CLN_RN_UTIL_FROM_ROLE_V
VIEW - APPS.CLN_RN_UTIL_TO_ROLE_CUST2_V
VIEW - APPS.CLN_RN_UTIL_TO_ROLE_CUSTOMER_V
VIEW - APPS.CLN_RN_UTIL_TO_ROLE_CUST_SUP_V
VIEW - APPS.CLN_RN_UTIL_TO_ROLE_INTERNAL_V
VIEW - APPS.CLN_RN_UTIL_TO_ROLE_SUPPLIER_V
VIEW - APPS.CLN_WSH_SS_SHIPITEMS_V
VIEW - APPS.CLN_WSH_SS_SHIPMENT_V
VIEW - APPS.CLN_XMLG_TXN_TYPES_V
VIEW - APPS.CLN_XML_CONTAINERS_RN_V
VIEW - APPS.CLN_XML_CONTAINERS_V
VIEW - APPS.CLN_XML_DELIVERIES2_V
VIEW - APPS.CLN_XML_DELIVERIES_V
VIEW - APPS.CLN_XML_ITEMS2_V
VIEW - APPS.CLN_XML_ITEMS_V
VIEW - APPS.M4R_3A6_OE_LINE_ACKS

Table: CLN_AP_INVOICE_REJECTION_ARCH

Description: Holds the rejected invoices, which are deleted from AP_INTERFACE_HEADERS due to errors

[top of page]

CLN.CLN_AP_INVOICE_REJECTION_ARCH does not reference any database object

CLN.CLN_AP_INVOICE_REJECTION_ARCH is referenced by following:

CLN
VIEW - CLN_AP_INVOICE_REJECTION_ARCH#

[top of page]

Table: CLN_CH_COLL_PROPERTIES

Description: Collabortion Properties

[top of page]

CLN.CLN_CH_COLL_PROPERTIES does not reference any database object

CLN.CLN_CH_COLL_PROPERTIES is referenced by following:

CLN
VIEW - CLN_CH_COLL_PROPERTIES#

[top of page]

Table: CLN_CH_DISPLAY_LABELS_DTL_B

Description: Detail Information of Setup Data of Lables(Names of the fields) displayed in Collaboration History

[top of page]

CLN.CLN_CH_DISPLAY_LABELS_DTL_B does not reference any database object

CLN.CLN_CH_DISPLAY_LABELS_DTL_B is referenced by following:

CLN
VIEW - CLN_CH_DISPLAY_LABELS_DTL_B#

[top of page]

Table: CLN_CH_DISPLAY_LABELS_DTL_TL

Description: Detail Information of Setup Data of Lables(Names of the fields) displayed in Collaboration History

[top of page]

CLN.CLN_CH_DISPLAY_LABELS_DTL_TL does not reference any database object

CLN.CLN_CH_DISPLAY_LABELS_DTL_TL is referenced by following:

CLN
VIEW - CLN_CH_DISPLAY_LABELS_DTL_TL#

[top of page]

Table: CLN_CH_DISPLAY_LABELS_HDR

Description: Header Information of Setup Data of Lables(Names of the fields) displayed in Collaboration History

[top of page]

CLN.CLN_CH_DISPLAY_LABELS_HDR does not reference any database object

CLN.CLN_CH_DISPLAY_LABELS_HDR is referenced by following:

CLN
VIEW - CLN_CH_DISPLAY_LABELS_HDR#

[top of page]

Table: CLN_CH_XMLGTXN_MAPPING

Description: This table recognises the Application ID, Document Type and Collaboration Type for on the basis of the XML setup.

[top of page]

CLN.CLN_CH_XMLGTXN_MAPPING does not reference any database object

CLN.CLN_CH_XMLGTXN_MAPPING is referenced by following:

CLN
VIEW - CLN_CH_XMLGTXN_MAPPING#

[top of page]

Table: CLN_COLL_COMPLETED_STATUS

Description: This table is used to default the collaboration status based on input parameters

[top of page]

CLN.CLN_COLL_COMPLETED_STATUS does not reference any database object

CLN.CLN_COLL_COMPLETED_STATUS is referenced by following:

CLN
VIEW - CLN_COLL_COMPLETED_STATUS#

[top of page]

Table: CLN_COLL_HIST_DTL

Description: Stores the detail information for any collaboration.

[top of page]

CLN.CLN_COLL_HIST_DTL does not reference any database object

CLN.CLN_COLL_HIST_DTL is referenced by following:

CLN
VIEW - CLN_COLL_HIST_DTL#

[top of page]

Table: CLN_COLL_HIST_HDR

Description: Stores the header information for any collaboration.

[top of page]

CLN.CLN_COLL_HIST_HDR does not reference any database object

CLN.CLN_COLL_HIST_HDR is referenced by following:

CLN
VIEW - CLN_COLL_HIST_HDR#

[top of page]

Table: CLN_COLL_MESSAGES

Description: Stores the detail messages for any collaboration.

[top of page]

CLN.CLN_COLL_MESSAGES does not reference any database object

CLN.CLN_COLL_MESSAGES is referenced by following:

CLN
VIEW - CLN_COLL_MESSAGES#

[top of page]

Table: CLN_CST_DTLS_TEMP

Description: This table is a temporary table used for storing records which can be later used for running the costing concurrent request

[top of page]

CLN.CLN_CST_DTLS_TEMP does not reference any database object

CLN.CLN_CST_DTLS_TEMP is referenced by following:

CLN
VIEW - CLN_CST_DTLS_TEMP#

[top of page]

Table: CLN_ITEMMST_DELETED_ITEMS

Description: Archived Item Information, for temporary internal storage
Primary Key: CLN_ITEMMST_DELETED_ITEMS_PK
  1. INVENTORY_ITEM_ID

[top of page]

CLN.CLN_ITEMMST_DELETED_ITEMS does not reference any database object

CLN.CLN_ITEMMST_DELETED_ITEMS is referenced by following:

CLN
VIEW - CLN_ITEMMST_DELETED_ITEMS#

[top of page]

Table: CLN_NOTIFICATION_ACTION_DTL

Description: Notification Action definition detail table

[top of page]

CLN.CLN_NOTIFICATION_ACTION_DTL does not reference any database object

CLN.CLN_NOTIFICATION_ACTION_DTL is referenced by following:

CLN
VIEW - CLN_NOTIFICATION_ACTION_DTL#

[top of page]

Table: CLN_NOTIFICATION_ACTION_HDR

Description: Notification Action definition header table

[top of page]

CLN.CLN_NOTIFICATION_ACTION_HDR does not reference any database object

CLN.CLN_NOTIFICATION_ACTION_HDR is referenced by following:

CLN
VIEW - CLN_NOTIFICATION_ACTION_HDR#

[top of page]

Table: CLN_NOTIFICATION_CODES_B

Description: Notification Codes base table.

[top of page]

CLN.CLN_NOTIFICATION_CODES_B does not reference any database object

CLN.CLN_NOTIFICATION_CODES_B is referenced by following:

CLN
VIEW - CLN_NOTIFICATION_CODES_B#

[top of page]

Table: CLN_NOTIFICATION_CODES_TL

Description: Notification Codes translated table

[top of page]

CLN.CLN_NOTIFICATION_CODES_TL does not reference any database object

CLN.CLN_NOTIFICATION_CODES_TL is referenced by following:

CLN
VIEW - CLN_NOTIFICATION_CODES_TL#

[top of page]

Table: CLN_RN_VALIDATIONS

Description: Validations of RosettaNet PIPs as per RosettaNet Specifications

[top of page]

CLN.CLN_RN_VALIDATIONS does not reference any database object

CLN.CLN_RN_VALIDATIONS is referenced by following:

CLN
VIEW - CLN_RN_VALIDATIONS#

[top of page]

Table: M4R_WSM_DWIP_HDR_STAGING

Description: M4R 7B1 Header Staging table

[top of page]

CLN.M4R_WSM_DWIP_HDR_STAGING does not reference any database object

CLN.M4R_WSM_DWIP_HDR_STAGING is referenced by following:

CLN
VIEW - M4R_WSM_DWIP_HDR_STAGING#

[top of page]

Table: M4R_WSM_DWIP_LOT_QTY_STAGING

Description: M4R 7B1 Lot quantity staging table

[top of page]

CLN.M4R_WSM_DWIP_LOT_QTY_STAGING does not reference any database object

CLN.M4R_WSM_DWIP_LOT_QTY_STAGING is referenced by following:

CLN
VIEW - M4R_WSM_DWIP_LOT_QTY_STAGING#

[top of page]

Table: M4R_WSM_DWIP_MSG_STAGING

Description: M4R 7B1 Message staging table

[top of page]

CLN.M4R_WSM_DWIP_MSG_STAGING does not reference any database object

CLN.M4R_WSM_DWIP_MSG_STAGING is referenced by following:

CLN
VIEW - M4R_WSM_DWIP_MSG_STAGING#

[top of page]

View: CLN_3C3_INVOICE_LINE_V

[top of page]

APPS.CLN_3C3_INVOICE_LINE_V references the following:

APPS
VIEW - AR_MEMO_LINES_ALL_VL
PACKAGE - FA_RX_FLEX_PKG
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - RA_CUSTOMER_TRX_LINES_ALL

APPS.CLN_3C3_INVOICE_LINE_V is not referenced by any database object

[top of page]

View: CLN_3C3_INVOICE_V

[top of page]

APPS.CLN_3C3_INVOICE_V references the following:

APPS
SYNONYM - AR_DOCUMENT_TRANSFERS
SYNONYM - AR_RECEIPT_METHODS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - HZ_CUST_ACCOUNTS_ALL
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - HZ_PARTIES
SYNONYM - RA_CUSTOMER_TRX_ALL
SYNONYM - RA_CUSTOMER_TRX_LINES_ALL
SYNONYM - RA_CUST_TRX_TYPES_ALL
- RA_SALESREPS_ALL

APPS.CLN_3C3_INVOICE_V is not referenced by any database object

[top of page]

View: CLN_CH_DISPLAY_LABELS_DTL_VL

[top of page]

APPS.CLN_CH_DISPLAY_LABELS_DTL_VL references the following:

APPS
SYNONYM - CLN_CH_DISPLAY_LABELS_DTL_B
SYNONYM - CLN_CH_DISPLAY_LABELS_DTL_TL

APPS.CLN_CH_DISPLAY_LABELS_DTL_VL is not referenced by any database object

[top of page]

View: CLN_INVENTORY_REPORT_V

[top of page]

APPS.CLN_INVENTORY_REPORT_V references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - MTL_SYSTEM_ITEMS_B
SYNONYM - MTL_SYSTEM_ITEMS_TL
- MTL_ITEM_REVISIONS
- MTL_SYSTEM_ITEMS_VL

APPS.CLN_INVENTORY_REPORT_V is not referenced by any database object

[top of page]

View: CLN_INV_CATEGORY_V

[top of page]

APPS.CLN_INV_CATEGORY_V references the following:

APPS
SYNONYM - MTL_CATEGORIES_TL
SYNONYM - MTL_ITEM_CATEGORIES
- MTL_CATEGORIES_B_KFV

APPS.CLN_INV_CATEGORY_V is not referenced by any database object

[top of page]

View: CLN_INV_ITEM_REVISIONS_V

[top of page]

APPS.CLN_INV_ITEM_REVISIONS_V references the following:

- MTL_ITEM_REVISIONS

APPS.CLN_INV_ITEM_REVISIONS_V is not referenced by any database object

[top of page]

View: CLN_INV_LOT_NUM_V

[top of page]

APPS.CLN_INV_LOT_NUM_V references the following:

APPS
SYNONYM - MTL_LOT_NUMBERS

APPS.CLN_INV_LOT_NUM_V is not referenced by any database object

[top of page]

View: CLN_ITEMMST_ABC_V

[top of page]

APPS.CLN_ITEMMST_ABC_V references the following:

APPS
SYNONYM - MTL_ABC_ASSIGNMENTS
SYNONYM - MTL_ABC_ASSIGNMENT_GROUPS
SYNONYM - MTL_ABC_CLASSES

APPS.CLN_ITEMMST_ABC_V is not referenced by any database object

[top of page]

View: CLN_ITEMMST_CTLG_CATS_V

[top of page]

APPS.CLN_ITEMMST_CTLG_CATS_V references the following:

APPS
SYNONYM - MTL_SYSTEM_ITEMS_B
- MTL_ITEM_CATALOG_GROUPS_KFV

APPS.CLN_ITEMMST_CTLG_CATS_V is not referenced by any database object

[top of page]

View: CLN_ITEMMST_CUSTOMER_V

[top of page]

APPS.CLN_ITEMMST_CUSTOMER_V references the following:

APPS
SYNONYM - ECX_EXT_PROCESSES
SYNONYM - ECX_TP_DETAILS
SYNONYM - ECX_TP_HEADERS
SYNONYM - ECX_TRANSACTIONS
SYNONYM - HZ_PARTIES

APPS.CLN_ITEMMST_CUSTOMER_V is not referenced by any database object

[top of page]

View: CLN_ITEMMST_INVENTORY_ORGS_V

[top of page]

APPS.CLN_ITEMMST_INVENTORY_ORGS_V references the following:

APPS
PACKAGE - FND_PROFILE
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - MTL_PARAMETERS
- ORG_ORGANIZATION_DEFINITIONS

APPS.CLN_ITEMMST_INVENTORY_ORGS_V is not referenced by any database object

[top of page]

View: CLN_ITEMMST_ITEMCATEGORY_V

[top of page]

APPS.CLN_ITEMMST_ITEMCATEGORY_V references the following:

APPS
SYNONYM - MTL_CATEGORIES_TL
SYNONYM - MTL_CATEGORY_SETS_B
SYNONYM - MTL_CATEGORY_SETS_TL
SYNONYM - MTL_CATEGORY_SET_VALID_CATS
SYNONYM - MTL_ITEM_CATEGORIES
- MTL_CATEGORIES_B_KFV

APPS.CLN_ITEMMST_ITEMCATEGORY_V is not referenced by any database object

[top of page]

View: CLN_ITEMMST_ITEMHEADER_V

[top of page]

APPS.CLN_ITEMMST_ITEMHEADER_V references the following:

APPS
PACKAGE - ARP_ADDR_PKG
PACKAGE - CLN_SYNCITEM_PKG
PACKAGE - FND_PROFILE
VIEW - MTL_CUSTOMER_ITEM_XREFS_V
SYNONYM - PO_HAZARD_CLASSES_TL
- MTL_ITEM_REVISIONS
- MTL_SYSTEM_ITEMS_VL

APPS.CLN_ITEMMST_ITEMHEADER_V is not referenced by any database object

[top of page]

View: CLN_ITEMMST_ITEMVALUE_V

[top of page]

APPS.CLN_ITEMMST_ITEMVALUE_V references the following:

APPS
SYNONYM - CST_COST_TYPES
SYNONYM - CST_ITEM_COSTS

APPS.CLN_ITEMMST_ITEMVALUE_V is not referenced by any database object

[top of page]

View: CLN_ITEMMST_ITEM_CATEGORIES_V

[top of page]

APPS.CLN_ITEMMST_ITEM_CATEGORIES_V references the following:

APPS
SYNONYM - MTL_CATEGORIES_TL
SYNONYM - MTL_CATEGORY_SETS_B
SYNONYM - MTL_CATEGORY_SET_VALID_CATS
SYNONYM - MTL_ITEM_CATEGORIES
- MTL_CATEGORIES_B_KFV

APPS.CLN_ITEMMST_ITEM_CATEGORIES_V is not referenced by any database object

[top of page]

View: CLN_ITEMMST_ITEM_CAT_SETS_V

[top of page]

APPS.CLN_ITEMMST_ITEM_CAT_SETS_V references the following:

APPS
SYNONYM - MTL_CATEGORIES_B
SYNONYM - MTL_CATEGORY_SETS_B
SYNONYM - MTL_CATEGORY_SETS_TL
SYNONYM - MTL_CATEGORY_SET_VALID_CATS
SYNONYM - MTL_ITEM_CATEGORIES

APPS.CLN_ITEMMST_ITEM_CAT_SETS_V is not referenced by any database object

[top of page]

View: CLN_ITEMMST_ITEM_STATUSES_V

[top of page]

APPS.CLN_ITEMMST_ITEM_STATUSES_V references the following:

- MTL_ITEM_STATUS

APPS.CLN_ITEMMST_ITEM_STATUSES_V is not referenced by any database object

[top of page]

View: CLN_ITEMMST_SUPPLIER_V

[top of page]

APPS.CLN_ITEMMST_SUPPLIER_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - HR_LOCATIONS_ALL
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.CLN_ITEMMST_SUPPLIER_V is not referenced by any database object

[top of page]

View: CLN_ITEMMST_TRADING_PARTNERS_V

[top of page]

APPS.CLN_ITEMMST_TRADING_PARTNERS_V references the following:

APPS
SYNONYM - ECX_EXT_PROCESSES
SYNONYM - ECX_TP_DETAILS
SYNONYM - ECX_TP_HEADERS
SYNONYM - ECX_TRANSACTIONS
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES

APPS.CLN_ITEMMST_TRADING_PARTNERS_V is not referenced by any database object

[top of page]

View: CLN_NOTIFICATION_CODES_VL

[top of page]

APPS.CLN_NOTIFICATION_CODES_VL references the following:

APPS
SYNONYM - CLN_NOTIFICATION_CODES_B
SYNONYM - CLN_NOTIFICATION_CODES_TL

APPS.CLN_NOTIFICATION_CODES_VL is not referenced by any database object

[top of page]

View: CLN_PO_CHANGE_RESPONSE_LINE_V

[top of page]

APPS.CLN_PO_CHANGE_RESPONSE_LINE_V references the following:

APPS
PACKAGE - CLN_PO_CHANGE_RESPONSE_PKG
SYNONYM - PO_CHANGE_REQUESTS
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.CLN_PO_CHANGE_RESPONSE_LINE_V is not referenced by any database object

[top of page]

View: CLN_PO_ECX_LINE_LOC_ARCH_V

[top of page]

APPS.CLN_PO_ECX_LINE_LOC_ARCH_V references the following:

APPS
SYNONYM - MTL_UNITS_OF_MEASURE_TL
SYNONYM - PO_LINES_ALL
SYNONYM - PO_LINE_LOCATIONS_ALL

APPS.CLN_PO_ECX_LINE_LOC_ARCH_V is not referenced by any database object

[top of page]

View: CLN_PROCAT_AUTHORIZATION_V

[top of page]

APPS.CLN_PROCAT_AUTHORIZATION_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - FND_USER
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.CLN_PROCAT_AUTHORIZATION_V is not referenced by any database object

[top of page]

View: CLN_PROCAT_CATALOG_V

[top of page]

APPS.CLN_PROCAT_CATALOG_V references the following:

APPS
SYNONYM - QP_CURRENCY_DETAILS
SYNONYM - QP_LIST_HEADERS_B
SYNONYM - QP_LIST_HEADERS_TL

APPS.CLN_PROCAT_CATALOG_V is not referenced by any database object

[top of page]

View: CLN_PROCAT_CATITEM_V

[top of page]

APPS.CLN_PROCAT_CATITEM_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - MTL_CUSTOMER_ITEMS
SYNONYM - MTL_CUSTOMER_ITEM_XREFS
SYNONYM - MTL_SYSTEM_ITEMS_TL
SYNONYM - QP_LIST_LINES
SYNONYM - QP_PRICING_ATTRIBUTES
- MTL_ITEM_REVISIONS
- MTL_SYSTEM_ITEMS_B_KFV

APPS.CLN_PROCAT_CATITEM_V is not referenced by any database object

[top of page]

View: CLN_PROCAT_CURRENCIES_V

[top of page]

APPS.CLN_PROCAT_CURRENCIES_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - QP_CURRENCY_DETAILS
SYNONYM - QP_LIST_HEADERS_B
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.CLN_PROCAT_CURRENCIES_V is not referenced by any database object

[top of page]

View: CLN_PROCAT_CUSTOMER_V

[top of page]

APPS.CLN_PROCAT_CUSTOMER_V references the following:

APPS
SYNONYM - ECX_EXT_PROCESSES
SYNONYM - ECX_TP_DETAILS
SYNONYM - ECX_TP_HEADERS
SYNONYM - ECX_TRANSACTIONS
SYNONYM - HZ_PARTIES

APPS.CLN_PROCAT_CUSTOMER_V is not referenced by any database object

[top of page]

View: CLN_PROCAT_ITEMCATEGORY_V

[top of page]

APPS.CLN_PROCAT_ITEMCATEGORY_V references the following:

APPS
SYNONYM - MTL_CATEGORIES_TL
SYNONYM - MTL_CATEGORY_SETS_B
SYNONYM - MTL_DEFAULT_CATEGORY_SETS
SYNONYM - MTL_ITEM_CATEGORIES
- MTL_CATEGORIES_V

APPS.CLN_PROCAT_ITEMCATEGORY_V is not referenced by any database object

[top of page]

View: CLN_PROCAT_ITEM_CATEGORIES_V

[top of page]

APPS.CLN_PROCAT_ITEM_CATEGORIES_V references the following:

APPS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - MTL_CATEGORIES_TL
SYNONYM - MTL_CATEGORY_SETS_B
SYNONYM - MTL_CUSTOMER_ITEMS
SYNONYM - MTL_CUSTOMER_ITEM_XREFS
SYNONYM - MTL_DEFAULT_CATEGORY_SETS
SYNONYM - MTL_ITEM_CATEGORIES
SYNONYM - QP_LIST_LINES
SYNONYM - QP_PRICING_ATTRIBUTES
- MTL_SYSTEM_ITEMS_B_KFV
- MTL_CATEGORIES_V

APPS.CLN_PROCAT_ITEM_CATEGORIES_V is not referenced by any database object

[top of page]

View: CLN_PROCAT_PRICE_LISTS_V

[top of page]

APPS.CLN_PROCAT_PRICE_LISTS_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - QP_LIST_HEADERS_B
SYNONYM - QP_LIST_HEADERS_TL
PUBLIC
SYNONYM - DUAL
- QPBV_QUALIFIERS
- DUAL

APPS.CLN_PROCAT_PRICE_LISTS_V is not referenced by any database object

[top of page]

View: CLN_PROCAT_PUBLISHER_V

[top of page]

APPS.CLN_PROCAT_PUBLISHER_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - HR_LOCATIONS_ALL
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.CLN_PROCAT_PUBLISHER_V is not referenced by any database object

[top of page]

View: CLN_PROCAT_TRADING_PARTNERS_V

[top of page]

APPS.CLN_PROCAT_TRADING_PARTNERS_V references the following:

APPS
SYNONYM - ECX_EXT_PROCESSES
SYNONYM - ECX_TP_DETAILS
SYNONYM - ECX_TP_HEADERS
SYNONYM - ECX_TRANSACTIONS
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES

APPS.CLN_PROCAT_TRADING_PARTNERS_V is not referenced by any database object

[top of page]

View: CLN_PROCAT_VOLPRICEBREAK_V

[top of page]

APPS.CLN_PROCAT_VOLPRICEBREAK_V references the following:

APPS
SYNONYM - QP_LIST_LINES
SYNONYM - QP_PRICING_ATTRIBUTES
SYNONYM - QP_RLTD_MODIFIERS

APPS.CLN_PROCAT_VOLPRICEBREAK_V is not referenced by any database object

[top of page]

View: CLN_RN_UTIL_FROM_ROLE2_V

[top of page]

APPS.CLN_RN_UTIL_FROM_ROLE2_V references the following:

APPS
VIEW - CLN_RN_UTIL_FROM_ROLE_V

APPS.CLN_RN_UTIL_FROM_ROLE2_V is not referenced by any database object

[top of page]

View: CLN_RN_UTIL_FROM_ROLE_V

[top of page]

APPS.CLN_RN_UTIL_FROM_ROLE_V references the following:

APPS
SYNONYM - HR_LOCATIONS_ALL
- HR_ALL_ORGANIZATION_UNITS_VL
APPS.CLN_RN_UTIL_FROM_ROLE_V is referenced by following:

APPS
VIEW - CLN_RN_UTIL_FROM_ROLE2_V

[top of page]

View: CLN_RN_UTIL_TO_ROLE_CUST2_V

[top of page]

APPS.CLN_RN_UTIL_TO_ROLE_CUST2_V references the following:

APPS
VIEW - CLN_RN_UTIL_TO_ROLE_CUSTOMER_V

APPS.CLN_RN_UTIL_TO_ROLE_CUST2_V is not referenced by any database object

[top of page]

View: CLN_RN_UTIL_TO_ROLE_CUSTOMER_V

[top of page]

APPS.CLN_RN_UTIL_TO_ROLE_CUSTOMER_V references the following:

APPS
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
APPS.CLN_RN_UTIL_TO_ROLE_CUSTOMER_V is referenced by following:

APPS
VIEW - CLN_RN_UTIL_TO_ROLE_CUST2_V

[top of page]

View: CLN_RN_UTIL_TO_ROLE_CUST_SUP_V

[top of page]

APPS.CLN_RN_UTIL_TO_ROLE_CUST_SUP_V references the following:

APPS
PACKAGE - FND_GLOBAL
- CLN_RN_UTIL_TO_ROLE_CUSTOMER_V
- CLN_RN_UTIL_TO_ROLE_SUPPLIER_V

APPS.CLN_RN_UTIL_TO_ROLE_CUST_SUP_V is not referenced by any database object

[top of page]

View: CLN_RN_UTIL_TO_ROLE_INTERNAL_V

[top of page]

APPS.CLN_RN_UTIL_TO_ROLE_INTERNAL_V references the following:

APPS
PACKAGE - HR_GENERAL
- HR_LOCATIONS

APPS.CLN_RN_UTIL_TO_ROLE_INTERNAL_V is not referenced by any database object

[top of page]

View: CLN_RN_UTIL_TO_ROLE_SUPPLIER_V

[top of page]

APPS.CLN_RN_UTIL_TO_ROLE_SUPPLIER_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - PO_VENDORS
- PO_VENDOR_SITES_ALL

APPS.CLN_RN_UTIL_TO_ROLE_SUPPLIER_V is not referenced by any database object

[top of page]

View: CLN_WSH_SS_SHIPITEMS_V

[top of page]

APPS.CLN_WSH_SS_SHIPITEMS_V references the following:

APPS
SYNONYM - MTL_CUSTOMER_ITEMS
SYNONYM - WSH_DELIVERY_ASSIGNMENTS
SYNONYM - WSH_DELIVERY_DETAILS
SYNONYM - WSH_NEW_DELIVERIES
SYNONYM - WSH_SERIAL_NUMBERS
- PO_HAZARD_CLASSES_VL
- MTL_CATEGORY_SETS_VL
- MTL_SYSTEM_ITEMS_KFV

APPS.CLN_WSH_SS_SHIPITEMS_V is not referenced by any database object

[top of page]

View: CLN_WSH_SS_SHIPMENT_V

[top of page]

APPS.CLN_WSH_SS_SHIPMENT_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - HR_LOCATIONS_ALL_TL
PACKAGE - HR_SECURITY
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - HZ_PARTY_SITES
SYNONYM - WSH_LOCATIONS
SYNONYM - WSH_NEW_DELIVERIES
SYNONYM - WSH_TRANSACTIONS_HISTORY
- ORG_ORGANIZATION_DEFINITIONS
- WSH_UTIL_CORE
- WSH_CARRIERS_V

APPS.CLN_WSH_SS_SHIPMENT_V is not referenced by any database object

[top of page]

View: CLN_XMLG_TXN_TYPES_V

[top of page]

APPS.CLN_XMLG_TXN_TYPES_V references the following:

APPS
SYNONYM - ECX_EXT_PROCESSES

APPS.CLN_XMLG_TXN_TYPES_V is not referenced by any database object

[top of page]

View: CLN_XML_CONTAINERS_RN_V

[top of page]

APPS.CLN_XML_CONTAINERS_RN_V references the following:

APPS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - WSH_DELIVERY_ASSIGNMENTS
SYNONYM - WSH_DELIVERY_DETAILS

APPS.CLN_XML_CONTAINERS_RN_V is not referenced by any database object

[top of page]

View: CLN_XML_CONTAINERS_V

[top of page]

APPS.CLN_XML_CONTAINERS_V references the following:

APPS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - WSH_DELIVERY_ASSIGNMENTS
SYNONYM - WSH_DELIVERY_DETAILS

APPS.CLN_XML_CONTAINERS_V is not referenced by any database object

[top of page]

View: CLN_XML_DELIVERIES2_V

[top of page]

APPS.CLN_XML_DELIVERIES2_V references the following:

APPS
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCOUNT_ROLES
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - WSH_DELIVERY_ASSIGNMENTS
SYNONYM - WSH_DELIVERY_LEGS
SYNONYM - WSH_DOCUMENT_INSTANCES
PACKAGE - WSH_ECE_VIEWS_DEF
SYNONYM - WSH_LOCATIONS
SYNONYM - WSH_NEW_DELIVERIES
SYNONYM - WSH_TRIPS
SYNONYM - WSH_TRIP_STOPS
- WSH_UTIL_CORE

APPS.CLN_XML_DELIVERIES2_V is not referenced by any database object

[top of page]

View: CLN_XML_DELIVERIES_V

[top of page]

APPS.CLN_XML_DELIVERIES_V references the following:

APPS
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCOUNT_ROLES
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - WSH_DELIVERY_ASSIGNMENTS
SYNONYM - WSH_DELIVERY_LEGS
SYNONYM - WSH_DOCUMENT_INSTANCES
PACKAGE - WSH_ECE_VIEWS_DEF
SYNONYM - WSH_LOCATIONS
SYNONYM - WSH_NEW_DELIVERIES
SYNONYM - WSH_TRIPS
SYNONYM - WSH_TRIP_STOPS
- WSH_UTIL_CORE

APPS.CLN_XML_DELIVERIES_V is not referenced by any database object

[top of page]

View: CLN_XML_ITEMS2_V

[top of page]

APPS.CLN_XML_ITEMS2_V references the following:

APPS
SYNONYM - MTL_CUSTOMER_ITEMS
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - OE_ORDER_LINES_ALL
SYNONYM - RLM_SCHEDULE_LINES_ALL
SYNONYM - WSH_DELIVERY_ASSIGNMENTS
SYNONYM - WSH_DELIVERY_DETAILS
SYNONYM - WSH_NEW_DELIVERIES
- MTL_ITEM_FLEXFIELDS
- WSH_DSNO_PACKED_QUANTITY_V

APPS.CLN_XML_ITEMS2_V is not referenced by any database object

[top of page]

View: CLN_XML_ITEMS_V

[top of page]

APPS.CLN_XML_ITEMS_V references the following:

APPS
SYNONYM - MTL_CUSTOMER_ITEMS
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - OE_ORDER_LINES_ALL
SYNONYM - RLM_SCHEDULE_LINES_ALL
SYNONYM - WSH_DELIVERY_ASSIGNMENTS
SYNONYM - WSH_DELIVERY_DETAILS
SYNONYM - WSH_NEW_DELIVERIES
- MTL_ITEM_FLEXFIELDS
- WSH_DSNO_PACKED_QUANTITY_V

APPS.CLN_XML_ITEMS_V is not referenced by any database object

[top of page]

View: M4R_3A6_OE_LINE_ACKS

[top of page]

APPS.M4R_3A6_OE_LINE_ACKS references the following:

APPS
SYNONYM - OE_LINE_ACKS
SYNONYM - OE_ORDER_LINES_ALL

APPS.M4R_3A6_OE_LINE_ACKS is not referenced by any database object

[top of page]



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