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
Comments
Indexes
Index Type Tablespace Column
CLN_AP_INVOICE_REJECTION_ARCH_ UNIQUE APPS_TS_TX_IDX INVOICE_ID
Columns
Name Datatype Length Mandatory Comments
INVOICE_ID NUMBER

Invoice ID
XMLG_INTERNAL_CONTROL_NUMBER NUMBER

Internal Control Number of the XML Message, in XML Gateway tables
INVOICE_NUMBER VARCHAR2 (50)
Invoice Number
REFERENCE_ID VARCHAR2 (100)
Reference ID of the original XML message
PO_NUMBER NUMBER

Purchase Order Number
INVOICE_AMOUNT NUMBER

Invoice Amount
INVOICE_DATE DATE

Invoice Date
REJECT_REASON_STRING VARCHAR2 (2000)
Concatenated Rejection Reasons gerated by AP Process Invoice Import Program
CREATED_BY NUMBER (15) Y Standard WHO Column
CREATION_DATE DATE
Y Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
LAST_UPDATE_DATE DATE
Y Standard WHO Column

[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
Comments

Collabortion Properties

Indexes
Index Type Tablespace Column
CLN_CH_COLL_PROPERTIES_U1 UNIQUE APPS_TS_SEED PROPERTY_ID
ZD_EDITION_NAME
CLN_CH_COLL_PROPERTIES_U2 NONUNIQUE APPS_TS_SEED APPLICATION_ID
COLLABORATION_TYPE
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER

Application ID of the product
PROPERTY_ID NUMBER
Y Primary Key
COLLABORATION_TYPE VARCHAR2 (30) Y Collaboration Type
MESSAGE_TYPE VARCHAR2 (10) Y Type of the message
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
DESTINATION_URL VARCHAR2 (100)
ZD_EDITION_NAME VARCHAR2 (30) Y

[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
Comments

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

Indexes
Index Type Tablespace Column
CLN_CH_DISPLAY_LABELS_DTL_B_U1 UNIQUE APPS_TS_TX_IDX GUID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
GUID RAW (16) Y
PARENT_GUID RAW (16) Y
CLN_COLUMNS VARCHAR2 (150)
SEARCH_ENABLED VARCHAR2 (1)
DISPLAY_ENABLED_EVENTS_SCREEN VARCHAR2 (1)
DISPLAY_ENABLED_RESULTS_TABLE VARCHAR2 (1)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
ZD_EDITION_NAME VARCHAR2 (30) Y

[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
Comments

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

Indexes
Index Type Tablespace Column
CLN_CH_DISP_LABELS_DTL_TL_U1 UNIQUE APPS_TS_TX_IDX GUID
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
GUID RAW (16) Y
LANGUAGE VARCHAR2 (4) Y
SOURCE_LANG VARCHAR2 (4) Y
DISPLAY_LABEL VARCHAR2 (150)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
ZD_EDITION_NAME VARCHAR2 (30) Y

[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
Comments

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

Indexes
Index Type Tablespace Column
CLN_CH_DISPLAY_LABELS_HDR_U1 UNIQUE APPS_TS_TX_IDX GUID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
GUID RAW (16) Y
COLLABORATION_STANDARD VARCHAR2 (30)
APPLICATION_ID NUMBER

COLLABORATION_TYPE VARCHAR2 (30)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
ZD_EDITION_NAME VARCHAR2 (30) Y

[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.
Comments

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

Indexes
Index Type Tablespace Column
CLN_CH_XMLGTXN_MAPPING_U1 UNIQUE APPS_TS_SEED MAPPING_ID
ZD_EDITION_NAME
CLN_CH_XMLGTXN_MAPPING_U2 UNIQUE APPS_TS_SEED XMLG_TRANSACTION_TYPE
XMLG_TRANSACTION_SUBTYPE
DOCUMENT_DIRECTION
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
MAPPING_ID NUMBER

Standard who column
XMLG_TRANSACTION_TYPE VARCHAR2 (100)
External Transaction Type for the Document
XMLG_TRANSACTION_SUBTYPE VARCHAR2 (100)
External Transaction Sub Type for the Document
DOCUMENT_DIRECTION VARCHAR2 (3)
Document Direction
APPLICATION_ID NUMBER

Application ID of the product
DOCUMENT_TYPE VARCHAR2 (100)
Document Type
COLLABORATION_TYPE VARCHAR2 (30)
Collaboration Type for the document
CREATION_DATE DATE

Standard who column
CREATED_BY NUMBER (15)
Standard who column
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATED_BY NUMBER (15)
Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
ZD_EDITION_NAME VARCHAR2 (30) Y

[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
Comments

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

Indexes
Index Type Tablespace Column
CLN_COLL_COMPLETED_STATUS_U1 UNIQUE APPS_TS_SEED COMPLETED_STATUS_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
GUID RAW (16) Y Primary Key
COMPLETED_STATUS_ID NUMBER

COMPLETED_STATUS_ID IS 'UNIQUE_ID'
APPLICATION_ID NUMBER

Application ID of the product
COLLABORATION_TYPE VARCHAR2 (30)
Collaboration Type for the document
DOCUMENT_TYPE VARCHAR2 (100)
Document type
DOCUMENT_DIRECTION VARCHAR2 (3)
Direction of the document
MESSAGE_COUNT NUMBER

Total number of Messages with the same application id,document type, collaboration type and document direction possible
CREATION_DATE DATE

Standard who column
CREATED_BY NUMBER (15)
Standard who column
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATED_BY NUMBER (15)
Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
COLLABORATION_STANDARD VARCHAR2 (30)
Collaboration Standard
ZD_EDITION_NAME VARCHAR2 (30) Y

[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.
Comments

Stores the detail information for any collaboration.

Indexes
Index Type Tablespace Column
CLN_COLL_HIST_DTL_U1 UNIQUE APPS_TS_TX_IDX COLLABORATION_DTL_ID
CLN_COLL_HIST_DTL_N1 NONUNIQUE APPS_TS_TX_IDX COLLABORATION_ID
CLN_COLL_HIST_DTL_N2 NONUNIQUE APPS_TS_TX_IDX XMLG_INTERNAL_CONTROL_NUMBER
CLN_COLL_HIST_DTL_N3 NONUNIQUE APPS_TS_TX_IDX XMLG_MSG_ID
Columns
Name Datatype Length Mandatory Comments
XML_EVENT_KEY VARCHAR2 (240)
This parameter stores the event key.
COLLABORATION_DTL_ID NUMBER

This is a unique running serial number generated by collaboration History Module. This uniquely identifies the collaboration details.
COLLABORATION_ID NUMBER

This is a unique running serial number generated by collaboration History Module, this uniquely identifies collaboration.
COLLABORATION_DOCUMENT_TYPE VARCHAR2 (100)
Type of the message that is sent or received. For examples typically in Oracle apps we have Process PO, Confirmation and ACK PO.
DOCUMENT_DIRECTION VARCHAR2 (3)
Whether the direction of the collaboration is inbound (IN) or outbound (OUT).
COLLABORATION_POINT VARCHAR2 (20)
The module/system, which is the source of the History transaction. APPS, XMLG, B2B Gateway etc.
ORIGINATOR_REFERENCE VARCHAR2 (255)
Any reference number from the message generator so as to identify the message. This can be taken as a reference id passed on by different individual components like XML gateway, 9iAS server etc.
DOCUMENT_STATUS VARCHAR2 (10)
Status of the document.
NOTIFICATION_ID VARCHAR2 (100)
Notification ID of the collaboration.
MESSAGE_TEXT VARCHAR2 (2000)
Any message associated with the document.
CREATION_DATE DATE

Standard who column.
CREATED_BY NUMBER

Standard who column.
LAST_UPDATE_DATE DATE

Standard who column.
LAST_UPDATED_BY NUMBER

Standard who column.
LAST_UPDATE_LOGIN NUMBER

Standard who column.
BSR_VERB VARCHAR2 (240)
Represent the elements in the Control area of OAG XML.
BSR_NOUN VARCHAR2 (240)
Represent the elements in the Control area of OAG XML.
BSR_REVISION VARCHAR2 (240)
Represent the elements in the Control area of OAG XML.
SENDER_LOGICAL_ID VARCHAR2 (240)
Represent the elements in the Control area of OAG XML.
SENDER_COMPONENT VARCHAR2 (240)
Represent the elements in the Control area of OAG XML.
SENDER_TASK VARCHAR2 (240)
Represent the elements in the Control area of OAG XML.
SENDER_REFERENCEID VARCHAR2 (240)
Represent the elements in the Control area of OAG XML.
SENDER_CONFIRMATION VARCHAR2 (240)
Represent the elements in the Control area of OAG XML.
SENDER_LANGUAGE VARCHAR2 (240)
Represent the elements in the Control area of OAG XML.
SENDER_CODEPAGE VARCHAR2 (240)
Represent the elements in the Control area of OAG XML.
SENDER_AUTHID VARCHAR2 (240)
Represent the elements in the Control area of OAG XML.
SENDER_DATETIME_QUALIFIER VARCHAR2 (240)
Represent the elements in the Control area of OAG XML.
SENDER_DATETIME VARCHAR2 (240)
Represent the elements in the Control area of OAG XML.
SENDER_TIMEZONE VARCHAR2 (240)
Represent the elements in the Control area of OAG XML.
ATTRIBUTE1 VARCHAR2 (240)
Additional attribute provided for later use.
ATTRIBUTE2 VARCHAR2 (240)
Additional attribute provided for later use.
ATTRIBUTE3 VARCHAR2 (240)
Additional attribute provided for later use.
ATTRIBUTE4 VARCHAR2 (240)
Additional attribute provided for later use.
ATTRIBUTE5 VARCHAR2 (240)
Additional attribute provided for later use.
ATTRIBUTE6 VARCHAR2 (240)
Additional attribute provided for later use.
ATTRIBUTE7 VARCHAR2 (240)
Additional attribute provided for later use.
ATTRIBUTE8 VARCHAR2 (240)
Additional attribute provided for later use.
ATTRIBUTE9 VARCHAR2 (240)
Additional attribute provided for later use.
ATTRIBUTE10 VARCHAR2 (240)
Additional attribute provided for later use.
ATTRIBUTE11 VARCHAR2 (240)
Additional attribute provided for later use.
ATTRIBUTE12 VARCHAR2 (240)
Additional attribute provided for later use.
ATTRIBUTE13 VARCHAR2 (240)
Additional attribute provided for later use.
ATTRIBUTE14 VARCHAR2 (240)
Additional attribute provided for later use.
ATTRIBUTE15 VARCHAR2 (240)
Additional attribute provided for later use.
RESEND_FLAG VARCHAR2 (1)
If this message was resent or not e.g. Y for yes and N for no.
XMLG_DOCUMENT_ID VARCHAR2 (256)
Unique ID for the document.
XMLG_INTERNAL_CONTROL_NUMBER NUMBER

Interanl control number as generated by the XMLG.
XMLG_MSG_ID VARCHAR2 (100)
Msg ID generated by the XMLG for each document.
XMLG_TRANSACTION_SUBTYPE VARCHAR2 (100)
External transaction sub type for the document.
XMLG_TRANSACTION_TYPE VARCHAR2 (100)
External transaction type for the document.
XMLG_INT_TRANSACTION_SUBTYPE VARCHAR2 (100)
This represents the Internal Transaction SubType for the transaction in the XML Gateway setup.
XMLG_INT_TRANSACTION_TYPE VARCHAR2 (100)
This represents the Internal Transaction Type for the transaction in the XML Gateway setup.

[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.
Comments

Stores the header information for any collaboration.

Indexes
Index Type Tablespace Column
CLN_COLL_HIST_HDR_U1 UNIQUE APPS_TS_TX_IDX COLLABORATION_ID
CLN_COLL_HIST_HDR_U2 UNIQUE APPS_TS_TX_IDX APPLICATION_REFERENCE_ID
CLN_COLL_HIST_HDR_N1 NONUNIQUE APPS_TS_TX_IDX APPLICATION_ID
DOCUMENT_NO
CLN_COLL_HIST_HDR_N2 NONUNIQUE APPS_TS_TX_IDX XMLG_TRANSACTION_TYPE
XMLG_TRANSACTION_SUBTYPE
XMLG_DOCUMENT_ID
CLN_COLL_HIST_HDR_N3 NONUNIQUE APPS_TS_TX_IDX XMLG_MSG_ID
CLN_COLL_HIST_HDR_N4 NONUNIQUE APPS_TS_TX_IDX XMLG_INTERNAL_CONTROL_NUMBER
Columns
Name Datatype Length Mandatory Comments
XML_EVENT_KEY VARCHAR2 (240)
This parameter stores the event key.
COLLABORATION_ID NUMBER

This is a unique running serial number generated by collaboration History Module, this uniquely identifies collaboration.
APPLICATION_ID VARCHAR2 (10)
The ID of the application that is using this document.
APPLICATION_REFERENCE_ID VARCHAR2 (100)
Any reference number that uniquely identifies this collaboration from integrating application point of view.
ORG_ID NUMBER

Organization ID from application.
RELEASE_NO VARCHAR2 (10)
Release Number from Application.
DOCUMENT_NO VARCHAR2 (255)
The number that identifies this transaction in the application.
RESEND_FLAG VARCHAR2 (1)
If this message was resent or not e.g. Y for yes and N for no.
RESEND_COUNT NUMBER

Number of times the original message was resent.
DOC_REVISION_NO VARCHAR2 (10)
Revision Number of the document.
PARTNER_DOCUMENT_NO VARCHAR2 (255)
The document number from the Trading partner if the collaboration was intiated from his end.
COLLABORATION_TYPE VARCHAR2 (30)
Type of the collaboration. For example Order, Change Order.
TRADING_PARTNER VARCHAR2 (30)
ID that uniquely identifies the trading partner.
DOCUMENT_OWNER VARCHAR2 (30)
One who create the Doc.
INITIATION_DATE DATE

Initial date of creation of the collaboration.
DOCUMENT_CREATION_DATE DATE

Document Creation date.
DOCUMENT_REVISION_DATE DATE

Document Revision date.
COLLABORATION_STATUS VARCHAR2 (10)
Status of the collaboration.
DISPOSITION VARCHAR2 (10)
Status of the transaction.
LAST_UPDATE_DATE DATE

Standard who column.
LAST_UPDATED_BY NUMBER

Standard who column.
CREATION_DATE DATE

Standard who column.
CREATED_BY NUMBER

Standard who column.
LAST_UPDATE_LOGIN NUMBER

Standard who column.
XMLG_MSG_ID VARCHAR2 (100)
Unique ID generated by XML Gateway for each XML document.
UNIQUE_ID1 VARCHAR2 (30)
Unique ID for identifying Collaboration.
UNIQUE_ID2 VARCHAR2 (30)
Unique ID for identifying Collaboration.
UNIQUE_ID3 VARCHAR2 (30)
Unique ID for identifying Collaboration.
UNIQUE_ID4 VARCHAR2 (30)
Unique ID for identifying Collaboration.
UNIQUE_ID5 VARCHAR2 (30)
Unique ID for identifying Collaboration.
XMLG_TRANSACTION_TYPE VARCHAR2 (100)
Transaction Type defined in the XMLG setting.
XMLG_TRANSACTION_SUBTYPE VARCHAR2 (100)
Transaction sub type defined in the XMLG setting.
XMLG_DOCUMENT_ID VARCHAR2 (256)
XML Gateway document ID.
TRADING_PARTNER_TYPE VARCHAR2 (10)
Trading Partner Type S for Supplier, C Customer, B Bank etc...
TRADING_PARTNER_SITE VARCHAR2 (30)
Trading Partner Site.
DOCUMENT_DIRECTION VARCHAR2 (3)
Direction of the document.
XMLG_INTERNAL_CONTROL_NUMBER NUMBER

Internal Control NUmber as generated by the XMLG.
XMLG_INT_TRANSACTION_SUBTYPE VARCHAR2 (100)
This represents the Internal Transaction SubType for the transaction in the XML Gateway setup.
XMLG_INT_TRANSACTION_TYPE VARCHAR2 (100)
This represents the Internal Transaction Type for the transaction in the XML Gateway setup.
COLLABORATION_STANDARD VARCHAR2 (30)
Collaboration Standard
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
DATTRIBUTE1 DATE

DATTRIBUTE2 DATE

DATTRIBUTE3 DATE

DATTRIBUTE4 DATE

DATTRIBUTE5 DATE

OWNER_ROLE VARCHAR2 (30)

[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.
Comments

Stores the detail messages for any collaboration.

Indexes
Index Type Tablespace Column
CLN_COLL_MESSAGES_U1 UNIQUE APPS_TS_TX_IDX DTL_MESSAGE_ID
CLN_COLL_MESSAGES_N1 NONUNIQUE APPS_TS_TX_IDX COLLABORATION_DTL_ID
Columns
Name Datatype Length Mandatory Comments
DTL_MESSAGE_ID NUMBER

This is a unique running serial number generated by collaboration History Module. This uniquely identifies the collaboration message.
COLLABORATION_DTL_ID NUMBER

This is a unique running serial number generated by collaboration History Module. This uniquely identifies the collaboration details.
REFERENCE1 VARCHAR2 (30)
Reference to associate the message with the document.
REFERENCE2 VARCHAR2 (30)
Reference to associate the message with the document.
REFERENCE3 VARCHAR2 (30)
Reference to associate the message with the document.
REFERENCE4 VARCHAR2 (30)
Reference to associate the message with the document.
REFERENCE5 VARCHAR2 (30)
Reference to associate the message with the document.
DTL_MESSAGE_TEXT VARCHAR2 (2000)
Gives the detail message of the Collaboration event.
CREATION_DATE DATE

Standard who column.
CREATED_BY NUMBER

Standard who column.
LAST_UPDATE_DATE DATE

Standard who column.
LAST_UPDATED_BY NUMBER

Standard who column.
LAST_UPDATE_LOGIN NUMBER

Standard who column.

[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
Comments

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

Indexes
Index Type Tablespace Column
CLN_CST_DTLS_TEMP_N1 NONUNIQUE APPS_TS_INTERFACE GROUP_ID
Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER

Unique ID for the item
GROUP_ID NUMBER

Group ID used for running the costing concurrent request in batch
ORGANIZATION_ID NUMBER

Organization ID
RESOURCE_ID NUMBER

Resource ID
USAGE_RATE_OR_AMOUNT NUMBER

Usage Rate or Amount
ITEM_COST NUMBER

Item Cost
COST_ELEMENT_ID NUMBER

Cost Element ID
COST_TYPE VARCHAR2 (10)
Cost Type
PROCESS_FLAG NUMBER

Process flag
ITEM_NUMBER VARCHAR2 (81)
Item Number
MFG_PART_NUM VARCHAR2 (30)
Mfg Part Number

[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
Comments

Archived Item Information, for temporary internal storage

Indexes
Index Type Tablespace Column
CLN_ITEMMST_DELETED_ITEMS_U1 UNIQUE APPS_TS_INTERFACE ORGANIZATION_ID
INVENTORY_ITEM_ID
CUSTOMER_ITEM_NUMBER
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

Organization ID
INVENTORY_ITEM_ID NUMBER
Y Inventory Item ID
CONCATENATED_SEGMENTS VARCHAR2 (100)
Item Number
ITEM_TYPE VARCHAR2 (100)
Item Type
PRIMARY_UOM_CODE VARCHAR2 (100)
Primary UOM Code
CUSTOMER_ITEM_NUMBER VARCHAR2 (100)
Customer Item Number

[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
Comments

Notification Action definition detail table

Indexes
Index Type Tablespace Column
CLN_NOTIFICATION_ACTION_DTL_U1 UNIQUE APPS_TS_SEED ACTION_DTL_ID
ZD_EDITION_NAME
CLN_NOTIFICATION_ACTION_DTL_N1 NONUNIQUE APPS_TS_SEED ACTION_HDR_ID
Columns
Name Datatype Length Mandatory Comments
GUID RAW (16) Y Primary Key
ACTION_DTL_ID NUMBER (38) Y Primary Key.
ACTION_HDR_ID NUMBER (38) Y Reference: CLN_NOTIFICATION_ACTION_HDR.ACTION_HDR_ID.
ACTION_CODE VARCHAR2 (30)
Lookup: CLN_ACTION_TYPE.
ACTIVE_FLAG VARCHAR2 (1)
Active flag [Y/N]
ATTRIBUTE1 VARCHAR2 (150)
Definition depends on the ACTION_CODE.
ATTRIBUTE2 VARCHAR2 (150)
Definition depends on the ACTION_CODE.
ATTRIBUTE3 VARCHAR2 (150)
Definition depends on the ACTION_CODE.
ATTRIBUTE4 VARCHAR2 (150)
Definition depends on the ACTION_CODE.
ATTRIBUTE5 VARCHAR2 (150)
Definition depends on the ACTION_CODE.
ATTRIBUTE6 VARCHAR2 (150)
Definition depends on the ACTION_CODE.
ATTRIBUTE7 VARCHAR2 (150)
Definition depends on the ACTION_CODE.
ATTRIBUTE8 VARCHAR2 (150)
Definition depends on the ACTION_CODE.
ATTRIBUTE9 VARCHAR2 (150)
Definition depends on the ACTION_CODE.
ATTRIBUTE10 VARCHAR2 (150)
Definition depends on the ACTION_CODE.
ATTRIBUTE11 VARCHAR2 (150)
Definition depends on the ACTION_CODE.
ATTRIBUTE12 VARCHAR2 (150)
Definition depends on the ACTION_CODE.
ATTRIBUTE13 VARCHAR2 (150)
Definition depends on the ACTION_CODE.
ATTRIBUTE14 VARCHAR2 (150)
Definition depends on the ACTION_CODE.
ATTRIBUTE15 VARCHAR2 (150)
Definition depends on the ACTION_CODE.
CREATION_DATE DATE

Standard Who Column
CREATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
ZD_EDITION_NAME VARCHAR2 (30) Y

[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
Comments

Notification Action definition header table

Indexes
Index Type Tablespace Column
CLN_NOTIFICATION_ACTION_HDR_U1 UNIQUE APPS_TS_SEED ACTION_HDR_ID
ZD_EDITION_NAME
CLN_NOTIFICATION_ACTION_HDR_N1 NONUNIQUE APPS_TS_SEED NOTIFICATION_ID
Columns
Name Datatype Length Mandatory Comments
ACTION_HDR_ID NUMBER (38) Y Primary Key.
APPLICATION_ID VARCHAR2 (10)
Lookup: CLN_APPLICATION_ID.
COLLABORATION_TYPE VARCHAR2 (30)
Lookup: CLN_COLLABORATION_TYPE.
NOTIFICATION_ID NUMBER (38)
Reference: CLN_NOTIFICATION_CODES_B.NOTIFICATION_ID.
CREATION_DATE DATE

Standard Who Column.
CREATED_BY NUMBER (15)
Standard Who Column.
LAST_UPDATE_DATE DATE

Standard Who Column.
LAST_UPDATED_BY NUMBER (15)
Standard Who Column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column.
ZD_EDITION_NAME VARCHAR2 (30) Y

[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.
Comments

Notification Codes base table.

Indexes
Index Type Tablespace Column
CLN_NOTIFICATION_CODES_B_U1 UNIQUE APPS_TS_SEED NOTIFICATION_ID
ZD_EDITION_NAME
CLN_NOTIFICATION_CODES_B_N1 NONUNIQUE APPS_TS_SEED NOTIFICATION_CODE
Columns
Name Datatype Length Mandatory Comments
NOTIFICATION_ID NUMBER (38) Y Primary Key.
COLLABORATION_POINT VARCHAR2 (15)
Lookup: CLN_COLLABORATION_POINT.
NOTIFICATION_CODE VARCHAR2 (10)
Identifies a notification For Instance: B2B_01.
CREATION_DATE DATE

Standard Who Column.
CREATED_BY NUMBER (15)
Standard Who Column.
LAST_UPDATE_DATE DATE

Standard Who Column.
LAST_UPDATED_BY NUMBER (15)
Standard Who Column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column.
ZD_EDITION_NAME VARCHAR2 (30) Y

[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
Comments

Notification Codes translated table

Indexes
Index Type Tablespace Column
CLN_NOTIFICATION_CODES_TL_U1 UNIQUE APPS_TS_SEED NOTIFICATION_ID
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
NOTIFICATION_ID NUMBER (38) Y Primary Key.
LANGUAGE VARCHAR2 (4) Y Language.
SOURCE_LANG VARCHAR2 (4) Y Source Language.
NOTIFICATION_MESSAGE VARCHAR2 (100)
Brief description of the Notification.
CREATION_DATE DATE

Standard Who Column.
CREATED_BY NUMBER (15)
Standard Who Column.
LAST_UPDATE_DATE DATE

Standard Who Column.
LAST_UPDATED_BY NUMBER (15)
Standard Who Column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column.
ZD_EDITION_NAME VARCHAR2 (30) Y

[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
Comments

Validations of RosettaNet PIPs as per RosettaNet Specifications

Indexes
Index Type Tablespace Column
CLN_RN_VALIDATIONS_U1 UNIQUE APPS_TS_SEED VALIDATION_ID
ZD_EDITION_NAME
CLN_RN_VALIDATIONS_U2 UNIQUE APPS_TS_SEED DOCUMENT_TYPE
XML_ELEMENT
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_TYPE VARCHAR2 (100) Y Root Element of the RosettaNet Message
VALIDATION_ID NUMBER
Y Primary Key
XML_ELEMENT VARCHAR2 (100) Y XML Element for which validation data is specified
MINIMUM_LENGTH NUMBER

Minimum Length(If not specified, the validation is not done)
MAXIMUM_LENGTH NUMBER

Maximum Length(If not specified, the validation is not done)
DATA_TYPE VARCHAR2 (100)
Data Type(If not specified, the validation is not done)
FORMAT_MASK VARCHAR2 (100)
Format Mask as specified in RosettaNet Specification
ORACLE_FORMAT_MASK VARCHAR2 (100)
Format Mask in Oracle Database Syntax(If not specified, the validation is not done)
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
ZD_EDITION_NAME VARCHAR2 (30) Y

[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
Comments
Indexes
Index Type Tablespace Column
M4R_WSM_DWIP_HDR_STAGING_U1 UNIQUE APPS_TS_TX_IDX HDR_ID
M4R_WSM_DWIP_HDR_STAGING_N1 NONUNIQUE APPS_TS_TX_IDX MSG_ID
Columns
Name Datatype Length Mandatory Comments
MSG_ID NUMBER
Y Internal Control Number of the message, which is unique to the message
HDR_ID NUMBER
Y Running Sequence Number
GROUP_ID NUMBER

Group ID of the data in the WSM interface tables
TRANSACTION_DATE DATE

Transaction Date
TRANSACTION_TYPE VARCHAR2 (30) Y
MANUFACTURED_LOC_CODE VARCHAR2 (30)
Location Code of Manufacturer
ADDITIONAL_TEXT VARCHAR2 (255)
Contains Account Number and Starting Lot Revision Number
FIRST_UNIT_START_DATE DATE

Starting Date of Work
PREV_OPERATION_SEQ_NUM VARCHAR2 (30)
Previous Operation Sequence Number
OPERATION_SEQ_NUM VARCHAR2 (30)
Operation Sequence Number
STATUS_CHANGE_CODE VARCHAR2 (255)
Status Change Code
REASON_CODE VARCHAR2 (255)
Reason Code
LOT_NUMBER VARCHAR2 (255)
Lot Number
SCHEDULED_COMPLETION_DATE DATE

Scheduled Completion date
SCHEDULED_START_DATE DATE

Scheduled Start date
PREV_LOT_NUMBER VARCHAR2 (255)
Previous Lot Number
PREV_LOT_CLASSIFICATION_CODE VARCHAR2 (255)
Previous Lot classification Code
PREV_LOT_UOM VARCHAR2 (30)
Previous Lot UOM
PREV_LOT_QTY NUMBER

Previous Lot Quantity
PRIMARY_ITEM_CODE VARCHAR2 (255)
Inventory Item of the Previous Lot
PRIMARY_ITEM_REVISION VARCHAR2 (3)
Inventory Items Revision
STARTING_LOT_ITEM_CODE VARCHAR2 (255)
Inventory Item of the present Lot
TRANSFER_TO_LOC_CODE VARCHAR2 (30)
Transfer to Location Code
ALT_ROUTING_DESIGNATOR VARCHAR2 (30)
Alternate Routing Designator for the Job
FROM_SUB_INVENTORY VARCHAR2 (30)
Sub Inventory in which the lot is present
TO_SUB_INVENTORY VARCHAR2 (30)
Sub Inventory to which teh item has to be moved
LOT_CODE VARCHAR2 (30)
Representative flag. Y if the Job is the representative Job
TRANSFER_FROM_ORG VARCHAR2 (3)
Transfer from Organisation
TRANSFER_TO_ORG VARCHAR2 (3)
Transfer to Organization
STATUS_FLAG VARCHAR2 (2)
Status of the transaction
ERROR_MESSAGE VARCHAR2 (255)
Error Messages got after transaction proecssing
CUSTOM_VALID_STATUS VARCHAR2 (10)
STARTING_LOT_ITEM_REVISION VARCHAR2 (3)
START_LOT_ALT_ROUT_DESIGNATOR VARCHAR2 (30)
ROUTING_PATH NUMBER (1)

[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
Comments
Indexes
Index Type Tablespace Column
M4R_WSM_DWIP_LOT_QTY_STAGING_U UNIQUE APPS_TS_TX_IDX LOT_QTY_ID
M4R_WSM_DWIP_LOT_QTY_STAGING_N NONUNIQUE APPS_TS_TX_IDX HDR_ID
Columns
Name Datatype Length Mandatory Comments
HDR_ID NUMBER
Y Referenced from Header table
LOT_QTY_ID NUMBER
Y Running Sequence Number
LOT_CLASSIFICATION_CODE VARCHAR2 (255)
Lot Classification Code
LOT_UOM VARCHAR2 (30)
Lot UOM
LOT_QTY NUMBER

Lot quantity

[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
Comments
Indexes
Index Type Tablespace Column
M4R_WSM_DWIP_MSG_STAGING_U1 UNIQUE APPS_TS_TX_IDX MSG_ID
Columns
Name Datatype Length Mandatory Comments
MSG_ID NUMBER
Y Internal Control Number of the message, which is unique to the message
TP_FROM_CODE VARCHAR2 (30)
Code identifying the from trading partner
TP_TO_CODE VARCHAR2 (30)
Code identifying the to trading partner
PARTY_ID NUMBER

Party ID of the trading partner
PARTY_SITE_ID NUMBER

Party Site ID of the trading partner
DOC_GENERATION_DATE DATE

The Business Document Generation Date
DOC_ID VARCHAR2 (256)
The Business Document Identifier

[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

Comments
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_TRX_ID NUMBER (15) Y Customer Transaction ID
CUSTOMER_TRX_LINE_ID NUMBER (15) Y Customer Transaction Line ID
LINE_TYPE VARCHAR2 (20) Y Line Type
LINE_NUMBER NUMBER
Y Line Number
LINE_AMOUNT NUMBER
Y Line Amount
UNIT_SELLING_PRICE NUMBER

Unit Selling Price
QUANTITY NUMBER

Quantity
DESCRIPTION VARCHAR2 (240)
Description
UOM VARCHAR2 (3)
Unit of Mesure
ITEM VARCHAR2 (4000)
Item
ITEM_DESCRIPTION VARCHAR2 (240)
Item Description
REFERENCE_NUMBER VARCHAR2 (82)
Reference Number
SALES_ORDER_NUMBER VARCHAR2 (50)
SALES_ORDER_REVISION NUMBER

SALES_ORDER_LINE_NUMBER VARCHAR2 (30)

[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

Comments
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_TRANSFER_ID NUMBER (15) Y Document transfer ID
CUSTOMER_TRX_ID NUMBER (15) Y Customer Transaction ID
TERM_ID NUMBER (15)
Term ID
AMOUNT NUMBER

Invoice Amount
CURRENCY_CODE VARCHAR2 (15)
Currency Code
TRX_DATE DATE
Y Transaction Date
TRX_NUMBER VARCHAR2 (20) Y Transaction Number
PO_NUMBER VARCHAR2 (50)
Purchase Order Number
DOCUMENT_TYPE VARCHAR2 (20)
Invoice Document Type
PAYMENT_METHOD VARCHAR2 (30)
Payment Method
SUPPLIER_NAME VARCHAR2 (240) Y Supplier Name
SUPPLIER_CODE VARCHAR2 (35)
Supplier Code
SALESREP VARCHAR2 (240)
Sales Representative
SALESREP_EMAIL VARCHAR2 (240)
Sales Representative Email
REFERENCE_NUMBER VARCHAR2 (81)
Reference Number
BILL_TO_LOCATION_CODE VARCHAR2 (40)
BillTo Location Code
BILL_TO_CUSTOMER_NAME VARCHAR2 (360) Y BillTo Customer Name
ORG_ID NUMBER (15)
Organization ID

[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

Comments
Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
GUID RAW (16) Y
PARENT_GUID RAW (16) Y
CLN_COLUMNS VARCHAR2 (150)
SEARCH_ENABLED VARCHAR2 (1)
DISPLAY_ENABLED_EVENTS_SCREEN VARCHAR2 (1)
DISPLAY_ENABLED_RESULTS_TABLE VARCHAR2 (1)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
DISPLAY_LABEL VARCHAR2 (150)

[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

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is used for mapping purposes in PIP-4C1

Columns
Name Datatype Length Mandatory Comments
START_DATE_ACTIVE DATE

Start Active Date
INVENTORY_ITEM_STATUS_CODE VARCHAR2 (10) Y Status Code Of The Inventory Item
ITEM_TYPE VARCHAR2 (30)
Item Type
PRIMARY_UOM_CODE VARCHAR2 (3)
Unit Of Measure
INVENTORY_ITEM_ID NUMBER
Y Inventory Item ID
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attrbute Category
ATTRIBUTE1 VARCHAR2 (240)
Attribute 1
ATTRIBUTE2 VARCHAR2 (240)
Attribute 2
ATTRIBUTE3 VARCHAR2 (240)
Attribute 3
ATTRIBUTE4 VARCHAR2 (240)
Attribute 4
ATTRIBUTE5 VARCHAR2 (240)
Attribute 5
ATTRIBUTE6 VARCHAR2 (240)
Attribute 6
ATTRIBUTE7 VARCHAR2 (240)
Attribute 7
ATTRIBUTE8 VARCHAR2 (240)
Attribute 8
ATTRIBUTE9 VARCHAR2 (240)
Attribute 9
ATTRIBUTE10 VARCHAR2 (240)
Attribute 10
ATTRIBUTE11 VARCHAR2 (240)
Attribute 11
ATTRIBUTE12 VARCHAR2 (240)
Attribute 12
ATTRIBUTE13 VARCHAR2 (240)
Attribute 13
ATTRIBUTE14 VARCHAR2 (240)
Attribute 14
ATTRIBUTE15 VARCHAR2 (240)
Attribute 15
END_DATE_ACTIVE DATE

End Date Active
DESCRIPTION VARCHAR2 (240)
Description
REVISION_ID NUMBER

Revision ID
REVISION VARCHAR2 (3)
Revision
ORGANIZATION_ID NUMBER
Y Organization ID
NAME VARCHAR2 (240) Y Name
ECE_TP_LOCATION_CODE VARCHAR2 (35)
Trading Partner Location Code
ADDRESS_LINE_1 VARCHAR2 (240)
Address Line 1
ADDRESS_LINE_2 VARCHAR2 (240)
Address Line 2
ADDRESS_LINE_3 VARCHAR2 (240)
Address Line 3
TOWN_OR_CITY VARCHAR2 (30)
Town or City
COUNTRY VARCHAR2 (60)
Country
POSTAL_CODE VARCHAR2 (30)
Postal Code
CONCATENATED_SEGMENTS VARCHAR2 (40)
Concatenated Segments
REVISION_QTY_CONTROL_CODE NUMBER

Revision Quantity Control Code
LOT_CONTROL_CODE NUMBER

Code for checking whether an item is Lot Controlled or not

[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

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

View used to get distinct values for the category

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Y Organization ID
CATEGORY_ID NUMBER
Y Category ID
DESCRIPTION VARCHAR2 (240)
Description of the category
CONCATENATED_SEGMENTS VARCHAR2 (163)
Concatenated Segments

[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

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

View to be used for value-sets used in 4C1 concurrent program

Columns
Name Datatype Length Mandatory Comments
REVISION VARCHAR2 (3) Y Revision of the item
ORGANIZATION_ID NUMBER
Y Organization ID.

[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

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

View used to get disctinct values of lot numbers for value-sets.

Columns
Name Datatype Length Mandatory Comments
LOT_NUMBER VARCHAR2 (80) Y Lot Number
ORGANIZATION_ID NUMBER
Y Organization ID

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View for the ABC section of the Sync Item XML message

Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER
Y Item Inventory ID.
ABC_CLASS_NAME VARCHAR2 (40) Y ABC Class Name.
ABC_CLASS_ID NUMBER
Y ABC Class ID.
ASSIGNMENT_GROUP_NAME VARCHAR2 (40) Y Assignment Group Name.
ASSIGNMENT_GROUP_ID NUMBER
Y Assignment Group ID.

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View containing the available item catalog categories.

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Y Organization ID.
ITEM_CATALOG_GROUP_ID NUMBER
Y Item Catalog Group ID.
CONCATENATED_SEGMENTS VARCHAR2 (40)
Item Catalog Group Name.

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View for the customer section of the Sync Item XML message

Columns
Name Datatype Length Mandatory Comments
PARTY_NAME VARCHAR2 (360) Y Customer Name.
PARTY_ID NUMBER
Y Customer Party ID.
CUSTOMER_PARTNRIDX VARCHAR2 (200)
Customer EDI Location Code.

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View of the available inventory organizations

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER (15) Y Organization ID.
ORGANIZATION_CODE VARCHAR2 (3)
Organization Code.
ORGANIZATION_NAME VARCHAR2 (240) Y Organization Name.
ORG_LEVEL VARCHAR2 (6)
Organization Level.

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View of the available item categories

Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER
Y Inventory Item ID.
ORGANIZATION_ID NUMBER
Y Organization ID.
CATEGORY_ID NUMBER
Y Category ID.
CATEGORY_SET_ID NUMBER
Y Category Set ID.
CATEGORY_NAME VARCHAR2 (163)
Category Name.
CATEGORY_DESCRIPTION VARCHAR2 (240)
Category Description.
CATEGORY_SET_NAME VARCHAR2 (30) Y Category Set Name.

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View for the Header section of the Sync Item XML message

Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER
Y Inventory Item ID.
START_DATE_ACTIVE DATE

Start Date that item is considered active.
UNIT_HEIGHT NUMBER

Unit Height.
DIMENSION_UOM_CODE VARCHAR2 (3)
Dimension Unit of Measure.
UNIT_LENGTH NUMBER

Unit Length.
UNIT_VOLUME NUMBER

Unit Volume.
VOLUME_UOM_CODE VARCHAR2 (3)
Volume Unit of Measure.
UNIT_WEIGHT NUMBER

Unit Weight.
WEIGHT_UOM_CODE VARCHAR2 (3)
Weight Unit of Measure.
UNIT_WIDTH NUMBER

Unit Width.
CONCATENATED_SEGMENTS VARCHAR2 (40)
Display Name of Item.
ITEM_TYPE VARCHAR2 (30)
Item Type.
PRIMARY_UOM_CODE VARCHAR2 (3)
Primary Unit of Measure.
BOM_ITEM_TYPE NUMBER
Y BOM Item Type.
INVENTORY_ITEM_STATUS_CODE VARCHAR2 (10) Y Inventory Item Status Code.
ORGANIZATION_ID NUMBER
Y Organization ID.
COST_OF_SALES_ACCOUNT NUMBER

Cost of Sales Account.
SAFETY_STOCK_BUCKET_DAYS NUMBER

Safety Stock Bucket Days.
CUMULATIVE_TOTAL_LEAD_TIME NUMBER

Cumulative Total Lead Time.
PLANNING_TIME_FENCE_DAYS NUMBER

Planning Time Fence Days.
MINIMUM_ORDER_QUANTITY NUMBER

Minimum Order Quantity.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute Category.
ATTRIBUTE1 VARCHAR2 (240)
Descriptive Flexfield Segment.
ATTRIBUTE2 VARCHAR2 (240)
Descriptive Flexfield Segment.
ATTRIBUTE3 VARCHAR2 (240)
Descriptive Flexfield Segment.
ATTRIBUTE4 VARCHAR2 (240)
Descriptive Flexfield Segment.
ATTRIBUTE5 VARCHAR2 (240)
Descriptive Flexfield Segment.
ATTRIBUTE6 VARCHAR2 (240)
Descriptive Flexfield Segment.
ATTRIBUTE7 VARCHAR2 (240)
Descriptive Flexfield Segment.
ATTRIBUTE8 VARCHAR2 (240)
Descriptive Flexfield Segment.
ATTRIBUTE9 VARCHAR2 (240)
Descriptive Flexfield Segment.
ATTRIBUTE10 VARCHAR2 (240)
Descriptive Flexfield Segment.
ATTRIBUTE11 VARCHAR2 (240)
Descriptive Flexfield Segment.
ATTRIBUTE12 VARCHAR2 (240)
Descriptive Flexfield Segment.
ATTRIBUTE13 VARCHAR2 (240)
Descriptive Flexfield Segment.
ATTRIBUTE14 VARCHAR2 (240)
Descriptive Flexfield Segment.
ATTRIBUTE15 VARCHAR2 (240)
Descriptive Flexfield Segment.
ITEM_DESCRIPTION VARCHAR2 (240)
Item Description.
REVISION VARCHAR2 (3)
Item Revision.
EFFECTIVITY_DATE DATE

Effectivity Date.
ITEM_CATALOG_GROUP_ID NUMBER

Item Catalog Group ID.
CUSTOMER_ITEM_NUMBER VARCHAR2 (50)
Customer Item Number.
CUSTOMER_ID NUMBER

HAZARD_CLASS VARCHAR2 (40)
Hazard Class.

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View for the Item Value section of the Sync Item XML message

Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER
Y Inventory Item ID.
ORGANIZATION_ID NUMBER
Y Organization ID.
ITEM_COST NUMBER

Item Cost.
COST_TYPE VARCHAR2 (10) Y Cost Type.

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View of the available item categories

Columns
Name Datatype Length Mandatory Comments
CATEGORY_ID NUMBER
Y Category ID.
CATEGORY_DESCRIPTION VARCHAR2 (240)
Category Description.
CATEGORY_SET_ID NUMBER
Y Category Set Id
CATEGORY_NAME VARCHAR2 (163)
ORGANIZATION_ID NUMBER
Y Organization ID.

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View of the available item category sets

Columns
Name Datatype Length Mandatory Comments
CATEGORY_SET_ID NUMBER
Y Category Set ID.
CATEGORY_SET_NAME VARCHAR2 (30) Y Category Set Name.
ORGANIZATION_ID NUMBER
Y Organization ID.

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View for the available item statuses

Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_STATUS_CODE VARCHAR2 (10) Y Inventory Item Status Code.

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View for the Supplier section of the Sync Item XML message

Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (240) Y Supplier Name.
SUPPLIER_PARTNRIDX VARCHAR2 (35)
Supplier EDI Location Code.

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View of the available trading partners

Columns
Name Datatype Length Mandatory Comments
TRADING_PARTNER_NAME VARCHAR2 (1026)
Trading Partner Name.
TP_HEADER_ID NUMBER
Y Trading Partner Header ID.

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Notification Codes table view that provides the translated notification message

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row ID
NOTIFICATION_ID NUMBER (38) Y Notification ID of the collaboration.
NOTIFICATION_MESSAGE VARCHAR2 (100)
Brief description of the Notification.
COLLABORATION_POINT VARCHAR2 (15)
The module/system, which is the source of the History transaction. APPS, XMLG, B2B Gateway etc.
NOTIFICATION_CODE VARCHAR2 (10)
Identifies a notification For Instance: B2B_01.
CREATION_DATE DATE

Standard Who Column
CREATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column

[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

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
DOCUMENT_LINE_ID NUMBER

Document Line ID
REQUEST_STATUS VARCHAR2 (30)
Request Status
MIN_REQUEST_STATUS VARCHAR2 (30)
Request Status at the Minimum Level
RESPONSE_REASON VARCHAR2 (2000)
Response Reason
SUPPLIER_LINE_REF VARCHAR2 (256)
Supplier Line Refernce.

[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

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
SUPPLIER_ORDER_LINE_NUMBER VARCHAR2 (25)
Supplier Order NUmber
PO_HEADER_ID NUMBER
Y PO Header ID
PO_RELEASE_ID NUMBER

PO Release ID
PO_LINE_ID NUMBER
Y PO Line ID
LINE_NUM NUMBER
Y Line number
LINE_LOCATION_ID NUMBER
Y Line Location ID
SHIPMENT_NUM NUMBER

Shipment NUmber
ORDERED_QUANTITY NUMBER

Ordered Quantity
UOM VARCHAR2 (3) Y Unit Of Measure
NEED_BY_DATE DATE

Need BY Date
PARTNER_ID NUMBER

Partner ID
PROMISED_DATE DATE

Promised Date
LAST_ACCEPT_DATE DATE

Last Accept Date
PRICE_OVERRIDE NUMBER

Price Override
TAXABLE_FLAG VARCHAR2 (1)
Taxable Flag
TAX_CODE_ID NUMBER

Tax Code ID
SHIP_TO_LOC_ID NUMBER

CONSIGNED_FLAG VARCHAR2 (1)
Consigned FLag

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View for the authorizization section of the Sync Catalog XML message

Columns
Name Datatype Length Mandatory Comments
USER_NAME VARCHAR2 (100) Y Authorized user for price list.

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View containing price list header information for the Sync Catalog XML message

Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (240)
Name of the price list.
START_DATE_ACTIVE DATE

Starting date of the valid period of the price list.
END_DATE_ACTIVE DATE

Ending date of the valid period of the price list.
COMMENTS VARCHAR2 (2000)
Price list description.
ACTIVE_FLAG VARCHAR2 (1)
Flag to determine if the price list is active.
LIST_TYPE_CODE VARCHAR2 (30)
Qualifier to determine if the list is a price list.
LIST_HEADER_ID NUMBER

Primary key for the price list.
CURRENCY_DETAIL_ID NUMBER

Foreign key to the types of currencies supported or 0 for the base currency for a price list.
TO_CURRENCY_CODE VARCHAR2 (30)
Display name of the currencies available.
FIXED_VALUE NUMBER

Multiplicative factor for currency conversion of type FIXED.

[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

Comments
Columns
Name Datatype Length Mandatory Comments
LIST_HEADER_ID NUMBER
Y
LIST_LINE_ID NUMBER
Y
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

PRODUCT_PRECEDENCE NUMBER

LIST_PRICE NUMBER

LIST_PRICE_UOM_CODE VARCHAR2 (3)
MINIMUM_ORDER_QUANTITY NUMBER

PRIMARY_UOM_CODE VARCHAR2 (3)
MAX_WARRANTY_AMOUNT NUMBER

CONCATENATED_SEGMENTS VARCHAR2 (40)
INVENTORY_ITEM_ID NUMBER
Y
ORGANIZATION_ID NUMBER
Y
ITEM_DESCRIPTION VARCHAR2 (240)
PARTY_ID NUMBER (15) Y
CUSTOMER_ITEM_NUMBER VARCHAR2 (50)
REVISION VARCHAR2 (3)
SERVICE_ITEM_FLAG VARCHAR2 (1) Y
CONTEXT VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (240)
ATTRIBUTE2 VARCHAR2 (240)
ATTRIBUTE3 VARCHAR2 (240)
ATTRIBUTE4 VARCHAR2 (240)
ATTRIBUTE5 VARCHAR2 (240)
ATTRIBUTE6 VARCHAR2 (240)
ATTRIBUTE7 VARCHAR2 (240)
ATTRIBUTE8 VARCHAR2 (240)
ATTRIBUTE9 VARCHAR2 (240)
ATTRIBUTE10 VARCHAR2 (240)
ATTRIBUTE11 VARCHAR2 (240)
ATTRIBUTE12 VARCHAR2 (240)
ATTRIBUTE13 VARCHAR2 (240)
ATTRIBUTE14 VARCHAR2 (240)
ATTRIBUTE15 VARCHAR2 (240)

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View of the available currencies the price list can be converted into

Columns
Name Datatype Length Mandatory Comments
CURRENCY_CODE VARCHAR2 (30)
Display name of currency.
CURRENCY_DETAIL_ID NUMBER

Currency ID.
LIST_HEADER_ID NUMBER

Price list header the currency ID is attached to.

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View of the recipient of the price list

Columns
Name Datatype Length Mandatory Comments
PARTY_NAME VARCHAR2 (360) Y Customer description.
PARTY_ID NUMBER
Y Customer ID in XML Gateway.
PARTY_SITE_ID NUMBER
Y
CUSTOMER_PARTNRIDX VARCHAR2 (200)
Customer EDI Location Code.

[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

Comments
Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER
Y Inventory Item ID.
ORGANIZATION_ID NUMBER
Y Organization ID.
CATEGORY_ID NUMBER
Y Category ID.
CATEGORY_NAME VARCHAR2 (163)
Category Name.
CATEGORY_DESCRIPTION VARCHAR2 (240)
Category Description.

[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

Comments
Columns
Name Datatype Length Mandatory Comments
LIST_HEADER_ID NUMBER
Y
CATEGORY_DESCRIPTION VARCHAR2 (240)
CATEGORY_ID NUMBER
Y

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View of the available price lists

Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (240)
LIST_HEADER_ID NUMBER

PARTY_ID NUMBER

ASSIGNED_FLAG CHAR (1)

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View of the sender of the price list

Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (240) Y Publisher Name.
PUBLISHER_PARTNRIDX VARCHAR2 (35)
Publisher EDI location code.

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View of the available trading partners

Columns
Name Datatype Length Mandatory Comments
TRADING_PARTNER_NAME VARCHAR2 (1026)
Customer Name from XML Gateway.
TP_HEADER_ID NUMBER
Y Customer header ID from XML Gateway.

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View for the price breaks of a particular price list item

Columns
Name Datatype Length Mandatory Comments
PRODUCT_LIST_LINE_ID NUMBER
Y Line ID of the catalog item.
PRICEBREAKVOL VARCHAR2 (240)
Price break volume.
PRICE_BREAK NUMBER

Price break.

[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

Comments
Columns
Name Datatype Length Mandatory Comments
ORG_ID NUMBER (15) Y
CONTACT_NAME VARCHAR2 (240) Y
CONTACT_EMAIL VARCHAR2 (0)
CONTACT_TELEPHONE VARCHAR2 (60)
CONTACT_FAX VARCHAR2 (60)
EDI_LOCATION_CODE VARCHAR2 (35)

[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

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

View to get From Role information for RosetaNet outbound XGMs

Columns
Name Datatype Length Mandatory Comments
ORG_ID NUMBER (15) Y Role ID (Organization ID)
CONTACT_NAME VARCHAR2 (240) Y Contact Name
CONTACT_EMAIL VARCHAR2 (0)
Contact Email
CONTACT_TELEPHONE VARCHAR2 (60)
Contact Telephone
CONTACT_FAX VARCHAR2 (60)
Contact Fax
EDI_LOCATION_CODE VARCHAR2 (35)
EDI Location Code

[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

Comments
Columns
Name Datatype Length Mandatory Comments
TP_ID NUMBER (15) Y
TP_SITE_ID NUMBER (15) Y
CONTACT_NAME VARCHAR2 (360) Y
CONTACT_EMAIL VARCHAR2 (0)
CONTACT_TELEPHONE VARCHAR2 (0)
CONTACT_FAX VARCHAR2 (0)
EDI_LOCATION_CODE VARCHAR2 (40)

[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

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

View to get To Role Customer information for RosetaNet outbound XGMs

Columns
Name Datatype Length Mandatory Comments
TP_ID NUMBER (15) Y Trading Partner ID
TP_SITE_ID NUMBER (15) Y Trading Partner Site ID
CONTACT_NAME VARCHAR2 (360) Y Contact Name
CONTACT_EMAIL VARCHAR2 (0)
Contact Email
CONTACT_TELEPHONE VARCHAR2 (0)
Contact Telephone
CONTACT_FAX VARCHAR2 (0)
Contact Fax
EDI_LOCATION_CODE VARCHAR2 (40)
EDI Location Code

[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

Comments
Columns
Name Datatype Length Mandatory Comments
TP_TYPE CHAR (1)
Trading Partner Type
TP_ID NUMBER

Trading Partner ID
TP_SITE_ID NUMBER

Trading Partner Site ID
CONTACT_NAME VARCHAR2 (360)
Contact Name
CONTACT_EMAIL VARCHAR2 (2000)
Contact Email
CONTACT_TELEPHONE VARCHAR2 (26)
Contact Telephone
CONTACT_FAX VARCHAR2 (26)
Contact Fax
EDI_LOCATION_CODE VARCHAR2 (60)
EDI Location Code

[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

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

View to get To Role Internal information for RosetaNet outbound XGMs

Columns
Name Datatype Length Mandatory Comments
TP_ID NUMBER (15) Y Trading Partner ID
TP_SITE_ID NUMBER (15) Y Trading Partner Site ID
CONTACT_NAME VARCHAR2 (60) Y Contact Name
CONTACT_EMAIL VARCHAR2 (0)
Contact Email
CONTACT_TELEPHONE VARCHAR2 (60)
Contact Telephone
CONTACT_FAX VARCHAR2 (0)
Contact Fax
EDI_LOCATION_CODE VARCHAR2 (35)
EDI Location Code

[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

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

View to get To Role Supplier information for RosetaNet outbound XGMs

Columns
Name Datatype Length Mandatory Comments
TP_ID NUMBER
Y Trading Partner ID
TP_SITE_ID NUMBER
Y Trading Partner Site ID
CONTACT_NAME VARCHAR2 (240)
Contact Name
CONTACT_EMAIL VARCHAR2 (2000)
Contact Email
CONTACT_TELEPHONE VARCHAR2 (26)
Contact Telephone
CONTACT_FAX VARCHAR2 (26)
Contact Fax
EDI_LOCATION_CODE VARCHAR2 (60)
EDI Location Code

[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

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

View of delivery line details

Columns
Name Datatype Length Mandatory Comments
ITEM_NUMBER VARCHAR2 (40)
Concatenated Segments Item Number.
INVENTORY_ITEM_ID NUMBER

Inventory Item ID.
CUSTOMER_ITEM_ID NUMBER

Customer Item ID.
REQUESTED_QTY NUMBER
Y Requested Quantity.
REQUESTED_QTY_UOM VARCHAR2 (3) Y Requested Quantity Unit Of Measure.
SRC_REQUESTED_QUANTITY NUMBER

As Ordered by Customer Quantity.
DELIVERY_DETAILS_GROSS_WEIGHT NUMBER

Gross Weight of the Line.
CONTAINER_TYPE_CODE VARCHAR2 (30)
Container Type Code.
CONTAINER_NAME VARCHAR2 (30)
Container Name.
COUNTRY_OF_ORIGIN VARCHAR2 (50)
Country of Origin.
FREIGHT_CLASS_CAT VARCHAR2 (30)
Freight Class Category.
HAZARD_CLASS VARCHAR2 (40)
Hazardous material class.
HAZARD_CLASS_ID NUMBER

Hazardous material Code.
ITEM_DESCRIPTION VARCHAR2 (250)
Item Description.
REVISION VARCHAR2 (3)
Item Revision.
CUSTOMER_ITEM_NUMBER VARCHAR2 (50)
Customer Item Number.
PACKING_INSTRUCTIONS VARCHAR2 (2000)
Packing Instructions.
OWNERSHIP_CODE VARCHAR2 (30)
FOB Code.
PARTIAL_SHIPMENT NUMBER

Is Partial Shipment.
BACKORDERED_QTY NUMBER

Backordered Quantity.
ORDERED_QTY NUMBER

Ordered Quantity.
ORDERED_QTY_UOM VARCHAR2 (3)
Ordered Quantity Unit of Measure.
SHIPPED_QTY NUMBER

Shipped Quantity.
VOLUME NUMBER

Volume.
VOLUME_UOM_CODE VARCHAR2 (3)
Volume Unit of Measure.
NET_WEIGHT NUMBER

Net Weight.
WEIGHT_UOM_CODE VARCHAR2 (3)
Weight Unit of Measure.
GROSS_WEIGHT NUMBER

Gross Weight.
SHIP_NOTES VARCHAR2 (2000)
Ship Notes.
DELIVERY_DETAIL_ID NUMBER
Y Delivery Detail ID.
SOURCE_LINE_ID NUMBER
Y Source Line ID.
PARENT_DELIVERY_DETAIL_ID NUMBER

Parent Delivery Detail ID.
DELIVERY_ID NUMBER

Delivery ID.
TOLERANCE_BELOW NUMBER

Tolerance Lower Limit.
TOLERANCE_ABOVE NUMBER

Tolerance Upper Limit.
LOAD_SEQUENCE_NUMBER NUMBER

Load Sequence Number.
SHIP_SET_ID NUMBER

Ship Set ID.
SUBINVENTORY VARCHAR2 (10)
Subinventory.
TOP_MODEL_LINE_ID NUMBER

Top Model Line ID.
SHIP_MODEL_COMPLETE_FLAG VARCHAR2 (1)
Ship Model Complete Flag.
DELIVER_TO_LOCATION_ID NUMBER

Deliver to Location ID.
ORG_ID NUMBER

Oranization ID.
CUSTOMER_ID NUMBER

Customer ID.
COMMODITY_CODE_CAT VARCHAR2 (30)
Commodity Code Category.
SHIPMENT_PRIORITY_CODE VARCHAR2 (2)
Shipment Priority Code.
LOT_NUMBER VARCHAR2 (80)
Lot Number.
SUBLOT_NUMBER VARCHAR2 (32)
Sublot Number.
FROM_SERIAL_NUMBER VARCHAR2 (30)
From Serial Number.
TO_SERIAL_NUMBER VARCHAR2 (30)
To Serial Number.
PREFERRED_GRADE VARCHAR2 (150)
Preferred Grade.
CUST_PO_NUMBER VARCHAR2 (50)
Customer PO Number.
WSN_ROWID VARCHAR2 (18)
Shipment Notice Row ID.

[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

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

View of delivery header details

Columns
Name Datatype Length Mandatory Comments
DELIVERY_ID NUMBER
Y Delivery ID.
ACTION_CODE VARCHAR2 (30) Y Shipping Transaction History Action Code.
DOCUMENT_NUMBER VARCHAR2 (120) Y Shipping Transaction History Document Number.
DOCUMENT_CREATION_DATE DATE
Y Delivery Creation Date.
SHIP_FROM_LOCATION VARCHAR2 (60) Y Delivery Ship From Location.
SHIP_METHOD VARCHAR2 (30)
Delivery Shipment Method.
COUNTRY VARCHAR2 (120)
Initial Pickup Location Country.
ULTIMATE_DROPOFF_DATE DATE

Ultimate Dropoff Date.
INITIAL_PICKUP_DATE DATE

Initial Pickup date.
DESCRIPTION VARCHAR2 (30)
Delivery Description.
DOCUMENT_TYPE VARCHAR2 (30) Y Shipping Transaction History Document Type.
FREIGHT_TERMS VARCHAR2 (30)
Freight Terms.
GROSS_WEIGHT NUMBER

Delivery Gross Weight.
NET_WEIGHT NUMBER

Delivery Net Weight.
WEIGHT_UOM_CODE VARCHAR2 (3)
Weight Unit Of Measure.
NUMBER_OF_LPN NUMBER

Number of LPN.
VOLUME NUMBER

Delivery Volume.
VOLUME_UOM_CODE VARCHAR2 (3)
Volume Unit Of Measure.
SHIPPING_MARKS VARCHAR2 (100)
Shipping Marks.
SHIP_TO_LOCATION VARCHAR2 (40) Y Ship To Location.
FOB_CODE VARCHAR2 (30)
FOB Code.
ORGANIZATION_CODE VARCHAR2 (3)
Organization Code.
ORGANIZATION_NAME VARCHAR2 (240) Y Organization Name.
LOADING_SEQUENCE NUMBER

Loading Sequence.
ORIG_DOCUMENT_NUMBER VARCHAR2 (120)
Shipping Transaction History Orig Document Number.
WAYBILL VARCHAR2 (30)
Waybill.
CARRIER VARCHAR2 (360)
Delivery Carrier.
SERVICE_LEVEL VARCHAR2 (30)
Delivery Service Level.
TRANSPORTATION_METHOD VARCHAR2 (30)
Delivery Transportation Method.
SHIP_FROM_EDI_LOCATION_CODE1 VARCHAR2 (35)
ShipFrom EDI Location Code.
SHIP_FROM_EDI_LOCATION_CODE2 VARCHAR2 (35)
ShipFrom EDI Location Code.
SHIP_FROM_ADDRESS1 VARCHAR2 (240)
ShipFrom Address1.
SHIP_FROM_ADDRESS2 VARCHAR2 (240)
ShipFrom Address2.
SHIP_FROM_ADDRESS3 VARCHAR2 (240)
ShipFrom Address3.
SHIP_FROM_CITY VARCHAR2 (30)
ShipFrom City.
SHIP_FROM_COUNTRY_CODE VARCHAR2 (60)
ShipFrom Country Code.
SHIP_FROM_POSTAL_CODE VARCHAR2 (30)
ShipFrom Postal Code.
SHIP_FROM_REGION VARCHAR2 (120)
ShipFrom Region.
SHIP_TO_EDI_LOCATION_CODE1 VARCHAR2 (40)
ShipTo EDI Location Code.
SHIP_TO_EDI_LOCATION_CODE2 VARCHAR2 (40)
ShipTo EDI Location Code.
SHIP_TO_ADDRESS1 VARCHAR2 (240)
ShipTo Address1.
SHIP_TO_ADDRESS2 VARCHAR2 (240)
ShipTo Address2.
SHIP_TO_ADDRESS3 VARCHAR2 (240)
ShipTo Address3.
SHIP_TO_CITY VARCHAR2 (120)
ShipTo City.
SHIP_TO_COUNTRY_CODE VARCHAR2 (120)
ShipTo Country.
SHIP_TO_POSTAL_CODE VARCHAR2 (60)
ShipTo Postal Code.
SHIP_TO_REGION VARCHAR2 (0)
ShipTo Region.

[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

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

View showing distinct combinations of XML Gateway Transactions Setup

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_TYPE VARCHAR2 (80) Y XML Gateway External Transaction Type
TRANSACTION_SUBTYPE VARCHAR2 (80) Y XML Gateway External Transaction Subtype
DIRECTION VARCHAR2 (20) Y Direction of the Document

[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

Comments
Columns
Name Datatype Length Mandatory Comments
CONTAINER_INSTANCE_ID NUMBER

CONTAINER_SERIAL_NUMBER VARCHAR2 (30)
CONTAINER_TYPE_INT VARCHAR2 (30)
CONTAINER_VOLUME NUMBER

CONTAINER_VOLUME_UOM_CODE_INT VARCHAR2 (3)
CONTAINER_NET_WEIGHT NUMBER

CONTAINER_SEAL_CODE VARCHAR2 (30)
CONTAINER_TRACKING_NUMBER VARCHAR2 (30)
DELIVERY_ID NUMBER

UNIT_HEIGHT NUMBER

UNIT_LENGTH NUMBER

UNIT_WIDTH NUMBER

PARENT_DELIVERY_DETAIL_ID NUMBER

LPN_ID NUMBER

RN_DUMMY_CONTAINER CHAR (1)

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View for SHIPUNIT containers section in OAG SHOW_SHIPMENT_005 XML payload

Columns
Name Datatype Length Mandatory Comments
CONTAINER_INSTANCE_ID NUMBER
Y Primary Key to identify delivery container line
CONTAINER_SERIAL_NUMBER VARCHAR2 (30)
Serial Number of a container item
CONTAINER_TYPE_INT VARCHAR2 (30)
Container type code
CONTAINER_VOLUME NUMBER

Volume
CONTAINER_VOLUME_UOM_CODE_INT VARCHAR2 (3)
CONTAINER_NET_WEIGHT NUMBER

Container Net Weight
CONTAINER_SEAL_CODE VARCHAR2 (30)
Seal Code
CONTAINER_TRACKING_NUMBER VARCHAR2 (30)
Tracking number
DELIVERY_ID NUMBER

Foreign Key to WSH_NEW_DELIVERIES
UNIT_HEIGHT NUMBER

Container Item height
UNIT_LENGTH NUMBER

Container Item length
UNIT_WIDTH NUMBER

Container Item width
PARENT_DELIVERY_DETAIL_ID NUMBER

Foreign Key to WSH_NEW_DELIVERIES for parent delivery
LPN_ID NUMBER

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View for SHIPMENT deliveries section in OAG SHOW_SHIPMENT_005 XML payload

Columns
Name Datatype Length Mandatory Comments
DOCUMENT_CODE VARCHAR2 (30) Y Unique Delivery Name
DELIVERY_ID NUMBER
Y Primary Key to identify delivery
DESTINATION_CODE_INT VARCHAR2 (40) Y Destination Internal Partner ID
DESTINATION_EDI_LOC_CODE VARCHAR2 (40)
Destination EDI Location Code
DESTINATION_NAME VARCHAR2 (50)
Destination Name
DESTINATION_ADDRESS1 VARCHAR2 (240) Y First Line of Destination Address
DESTINATION_ADDRESS2 VARCHAR2 (240)
Second Line of Destination Address
DESTINATION_ADDRESS3 VARCHAR2 (240)
Third Line of Destination Address
DESTINATION_CITY VARCHAR2 (60)
Destination City
DESTINATION_STATE VARCHAR2 (60)
DESTINATION_POSTAL_CODE VARCHAR2 (60)
Destination Postal Code
DESTINATION_COUNTRY_INT VARCHAR2 (60) Y Destination Country
DESTINATION_CONTACT_LAST_NAME VARCHAR2 (50)
Last Name of the Destination Contact Person
DESTINATION_CONTACT_FIRST_NAME VARCHAR2 (40)
First Name of the Destination Contact Person
DESTINATION_AREA_CODE VARCHAR2 (4000)
Destination Area Code
DESTINATION_TELEPHONE VARCHAR2 (4000)
Destination Telephone Number
SHIPPER_NUMBER NUMBER
Y Shipper Number
WAYBILL_NUMBER VARCHAR2 (30)
Waybill Number
BILL_OF_LADING VARCHAR2 (50)
Bill of Lading
PACKING_SLIP_NUMBER VARCHAR2 (50)
Packing Slip Number
FREIGHT_TERMS_CODE_INT VARCHAR2 (30)
Freight Terms Code
NUMBER_OF_LPN NUMBER

License Plate Number
SHIP_METHOD_CODE_INT VARCHAR2 (30)
Ship Method Code
ULTIMATE_DROPOFF_DATE DATE

Scheduled Delivery Date
INITIAL_PICKUP_DATE DATE

PLANNED_DEPARTURE_DATE DATE

Scheduled Ship Date
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive Flexfield Category
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
TP_DESCRIPTION VARCHAR2 (500)
Supplier Name
TP_LOCATION_CODE_EXT VARCHAR2 (35)
Supplier EDI Location Code
TP_ADDRESS1 VARCHAR2 (240)
First line of Supplier Address
TP_ADDRESS2 VARCHAR2 (240)
Second line of Supplier Address
TP_ADDRESS3 VARCHAR2 (240)
Third line of Supplier Address
TP_CITY VARCHAR2 (120)
Supplier City
TP_STATE VARCHAR2 (120)
TP_COUNTRY VARCHAR2 (120)
Supplier Country
TP_POSTAL_CODE VARCHAR2 (60)
Supplier Postal Code
TP_PHONE VARCHAR2 (60)
Supplier Phone Number
TP_FAX VARCHAR2 (60)
Fax Number of the Supplier Contact
TP_CODE NUMBER
Y Supplier Internal Partner ID
CARRIER_NAME_INT VARCHAR2 (360)
Carrier Name

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View for SHIPMENT deliveries section in OAG SHOW_SHIPMENT_005 XML payload

Columns
Name Datatype Length Mandatory Comments
DOCUMENT_CODE VARCHAR2 (30) Y Unique Delivery Name
DELIVERY_ID NUMBER
Y Primary Key to identify delivery
DESTINATION_CODE_INT VARCHAR2 (40) Y Destination Internal Partner ID
DESTINATION_EDI_LOC_CODE VARCHAR2 (40)
Destination EDI Location Code
DESTINATION_NAME VARCHAR2 (50)
Destination Name
DESTINATION_ADDRESS1 VARCHAR2 (240) Y First Line of Destination Address
DESTINATION_ADDRESS2 VARCHAR2 (240)
Second Line of Destination Address
DESTINATION_ADDRESS3 VARCHAR2 (240)
Third Line of Destination Address
DESTINATION_CITY VARCHAR2 (60)
Destination City
DESTINATION_STATE VARCHAR2 (60)
DESTINATION_POSTAL_CODE VARCHAR2 (60)
Destination Postal Code
DESTINATION_COUNTRY_INT VARCHAR2 (60) Y Destination Country
DESTINATION_CONTACT_LAST_NAME VARCHAR2 (50)
Last Name of the Destination Contact Person
DESTINATION_CONTACT_FIRST_NAME VARCHAR2 (40)
First Name of the Destination Contact Person
DESTINATION_AREA_CODE VARCHAR2 (4000)
Destination Area Code
DESTINATION_TELEPHONE VARCHAR2 (4000)
Destination Telephone Number
SHIPPER_NUMBER NUMBER
Y Shipper Number
WAYBILL_NUMBER VARCHAR2 (30)
Waybill Number
BILL_OF_LADING VARCHAR2 (50)
Bill of Lading
PACKING_SLIP_NUMBER VARCHAR2 (50)
Packing Slip Number
FREIGHT_TERMS_CODE_INT VARCHAR2 (30)
Freight Terms Code
NUMBER_OF_LPN NUMBER

License Plate Number
SHIP_METHOD_CODE_INT VARCHAR2 (30)
Ship Method Code
ULTIMATE_DROPOFF_DATE DATE

Scheduled Delivery Date
INITIAL_PICKUP_DATE DATE

PLANNED_DEPARTURE_DATE DATE

Scheduled Ship Date
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive Flexfield Category
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
TP_DESCRIPTION VARCHAR2 (500)
Supplier Name
TP_LOCATION_CODE_EXT VARCHAR2 (35)
Supplier EDI Location Code
TP_ADDRESS1 VARCHAR2 (240)
First line of Supplier Address
TP_ADDRESS2 VARCHAR2 (240)
Second line of Supplier Address
TP_ADDRESS3 VARCHAR2 (240)
Third line of Supplier Address
TP_CITY VARCHAR2 (120)
Supplier City
TP_STATE VARCHAR2 (120)
TP_COUNTRY VARCHAR2 (120)
Supplier Country
TP_POSTAL_CODE VARCHAR2 (60)
Supplier Postal Code
TP_PHONE VARCHAR2 (60)
Supplier Phone Number
TP_FAX VARCHAR2 (60)
Fax Number of the Supplier Contact
TP_CODE NUMBER
Y Supplier Internal Partner ID
CARRIER_NAME_INT VARCHAR2 (360)
Carrier Name

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View for SHIPITEM items section in OAG SHOW_SHIPMENT_005 XML payload

Columns
Name Datatype Length Mandatory Comments
CONTAINER_INSTANCE_ID NUMBER

Primary Key to identify delivery item line
DELIVERY_ID NUMBER

Foreign Key to WSH_NEW_DELIVERIES
CUSTOMER_PART_NUMBER VARCHAR2 (50)
Customer Part Number
SUPPLIER_PART_NUMBER VARCHAR2 (40)
Supplier Part Number
SHIPPED_QUANTITY NUMBER

Shipped Quantity
ITEM_UOM_CODE_INT VARCHAR2 (3)
Unit of Measure for Shipped, Requested and Packed Quantity
ORDERED_QUANTITY NUMBER

Ordered Quantity
PACKED_QUANTITY NUMBER

Packed Quantity
HAZARDOUS_MATERIAL_CODE_INT CHAR (2)
Hazardous Material Code
ORDER_QUANTITY_UOM_INT VARCHAR2 (3)
Unit of Measure for Ordered Quantity
CUSTOMER_MODEL_SERIAL_NUMBER VARCHAR2 (50)
Customer Model Serial Number
SHIPPING_INSTRUCTIONS VARCHAR2 (2000)
Shipping Instructions
REQUESTED_QUANTITY NUMBER

Requested Quantity
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive Flexfield Category
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Segment
LOT_NUMBER VARCHAR2 (80)
Lot Number
ORIG_SYS_LINE_REF VARCHAR2 (50)
Order Line Number in Original Purchase Order
ORDER_LINE_NUMBER VARCHAR2 (40)
Line Number
COUNTRY_OF_ORIGIN_EXT VARCHAR2 (35)
Supplier Country
CUSTOMER_ITEM_REVISION VARCHAR2 (3)
Customer Item Revision
PACKAGING_CODE_EXT VARCHAR2 (10)
Packaging Code
ORIG_SYS_DOCUMENT_REF VARCHAR2 (50)
Document Number in Original Purchase Order
ORIG_SYS_SHIPMENT_REF VARCHAR2 (50)
Shipment Number in Original Purchase Order
SALES_ORDER_HEADER_ID NUMBER

SALES_ORDER_LINE_ID NUMBER

SALES_ORDER_NUM NUMBER

SALES_ORDER_LINE_NUM NUMBER

MINOR_LINE_INDICATOR CHAR (1)
SORT_ORDER VARCHAR2 (2000)

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View for SHIPITEM items section in OAG SHOW_SHIPMENT_005 XML payload

Columns
Name Datatype Length Mandatory Comments
CONTAINER_INSTANCE_ID NUMBER

Primary Key to identify delivery item line
DELIVERY_ID NUMBER

Foreign Key to WSH_NEW_DELIVERIES
CUSTOMER_PART_NUMBER VARCHAR2 (50)
Customer Part Number
SUPPLIER_PART_NUMBER VARCHAR2 (40)
Supplier Part Number
SHIPPED_QUANTITY NUMBER

Shipped Quantity
ITEM_UOM_CODE_INT VARCHAR2 (3)
Unit of Measure for Shipped, Requested and Packed Quantity
ORDERED_QUANTITY NUMBER

Ordered Quantity
PACKED_QUANTITY NUMBER

Packed Quantity
HAZARDOUS_MATERIAL_CODE_INT CHAR (2)
Hazardous Material Code
ORDER_QUANTITY_UOM_INT VARCHAR2 (3)
Unit of Measure for Ordered Quantity
CUSTOMER_MODEL_SERIAL_NUMBER VARCHAR2 (50)
Customer Model Serial Number
SHIPPING_INSTRUCTIONS VARCHAR2 (2000)
Shipping Instructions
REQUESTED_QUANTITY NUMBER

Requested Quantity
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive Flexfield Category
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Segment
LOT_NUMBER VARCHAR2 (80)
Lot Number
ORIG_SYS_LINE_REF VARCHAR2 (50)
Order Line Number in Original Purchase Order
ORDER_LINE_NUMBER VARCHAR2 (40)
Line Number
COUNTRY_OF_ORIGIN_EXT VARCHAR2 (35)
Supplier Country
CUSTOMER_ITEM_REVISION VARCHAR2 (3)
Customer Item Revision
PACKAGING_CODE_EXT VARCHAR2 (10)
Packaging Code
ORIG_SYS_DOCUMENT_REF VARCHAR2 (50)
Document Number in Original Purchase Order
ORIG_SYS_SHIPMENT_REF VARCHAR2 (50)
Shipment Number in Original Purchase Order
SALES_ORDER_HEADER_ID NUMBER

SALES_ORDER_LINE_ID NUMBER

SALES_ORDER_NUM NUMBER

SALES_ORDER_LINE_NUM NUMBER

MINOR_LINE_INDICATOR CHAR (1)
SORT_ORDER VARCHAR2 (2000)

[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

Comments
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_ITEM VARCHAR2 (2000)
CHANGE_SEQUENCE VARCHAR2 (50)
FIRST_ACK_CODE VARCHAR2 (30)
LINE_NUMBER NUMBER

ORDERED_QUANTITY NUMBER

ORDER_QUANTITY_UOM VARCHAR2 (3)
ORIG_SYS_LINE_REF VARCHAR2 (50)
ORIG_SYS_SHIPMENT_REF VARCHAR2 (50)
REQUEST_DATE DATE

SCHEDULE_ARRIVAL_DATE DATE

SHIPMENT_NUMBER NUMBER

UNIT_SELLING_PRICE NUMBER

USER_ITEM_DESCRIPTION VARCHAR2 (1000)
CUSTOMER_LINE_NUMBER VARCHAR2 (50)
CUSTOMER_SHIPMENT_NUMBER VARCHAR2 (50)
SPLIT_FROM_LINE_REF VARCHAR2 (50)
LINK_TO_LINE_ID NUMBER

TOP_MODEL_LINE_ID NUMBER

ORIG_SYS_DOCUMENT_REF VARCHAR2 (50)
ACKNOWLEDGMENT_TYPE VARCHAR2 (30)
REQUEST_ID NUMBER

SOLD_TO_ORG_ID NUMBER

MODEL_REFERENCE_TEXT VARCHAR2 (124)

[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