CLN Views (50)

CLN - Supply Chain Trading Connector for RosettaNet — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
CLN_3C3_INVOICE_LINE_V	View of invoice lines which is used ot generate 3C3 outbound
CLN_3C3_INVOICE_V	View of invoices which is used ot generate 3C3 outbound
CLN_CH_DISPLAY_LABELS_DTL_VL
CLN_INVENTORY_REPORT_V	This view is used for mapping purposes in PIP-4C1
CLN_INV_CATEGORY_V	View used to get distinct values for the category
CLN_INV_ITEM_REVISIONS_V	View to be used for value-sets used in 4C1 concurrent program
CLN_INV_LOT_NUM_V	View used to get disctinct values of lot numbers for value-sets.
CLN_ITEMMST_ABC_V	View for the ABC section of the Sync Item XML message
CLN_ITEMMST_CTLG_CATS_V	View containing the available item catalog categories.
CLN_ITEMMST_CUSTOMER_V	View for the customer section of the Sync Item XML message
CLN_ITEMMST_INVENTORY_ORGS_V	View of the available inventory organizations
CLN_ITEMMST_ITEMCATEGORY_V	View of the available item categories
CLN_ITEMMST_ITEMHEADER_V	View for the Header section of the Sync Item XML message
CLN_ITEMMST_ITEMVALUE_V	View for the Item Value section of the Sync Item XML message
CLN_ITEMMST_ITEM_CATEGORIES_V	View of the available item categories
CLN_ITEMMST_ITEM_CAT_SETS_V	View of the available item category sets
CLN_ITEMMST_ITEM_STATUSES_V	View for the available item statuses
CLN_ITEMMST_SUPPLIER_V	View for the Supplier section of the Sync Item XML message
CLN_ITEMMST_TRADING_PARTNERS_V	View of the available trading partners
CLN_NOTIFICATION_CODES_VL	Notification Codes table view that provides the translated notification message
CLN_PO_CHANGE_RESPONSE_LINE_V	This view is used for mapping purposes in PIP-3A8Response
CLN_PO_ECX_LINE_LOC_ARCH_V	This view is used for mapping purposes in PIP-3A8Response
CLN_PROCAT_AUTHORIZATION_V	View for the authorizization section of the Sync Catalog XML message
CLN_PROCAT_CATALOG_V	View containing price list header information for the Sync Catalog XML message
CLN_PROCAT_CATITEM_V
CLN_PROCAT_CURRENCIES_V	View of the available currencies the price list can be converted into
CLN_PROCAT_CUSTOMER_V	View of the recipient of the price list
CLN_PROCAT_ITEMCATEGORY_V	View of the available currencies the price list can be converted into
CLN_PROCAT_ITEM_CATEGORIES_V
CLN_PROCAT_PRICE_LISTS_V	View of the available price lists
CLN_PROCAT_PUBLISHER_V	View of the sender of the price list
CLN_PROCAT_TRADING_PARTNERS_V	View of the available trading partners
CLN_PROCAT_VOLPRICEBREAK_V	View for the price breaks of a particular price list item
CLN_RN_UTIL_FROM_ROLE2_V	View on top of CLN_RN_UTIL_FROM_ROLE_V
CLN_RN_UTIL_FROM_ROLE_V	View to get From Role information for RosetaNet outbound XGMs
CLN_RN_UTIL_TO_ROLE_CUST2_V	View on top of CLN_RN_UTIL_TO_ROLE_CUSTOMER_V
CLN_RN_UTIL_TO_ROLE_CUSTOMER_V	View to get To Role Customer information for RosetaNet outbound XGMs
CLN_RN_UTIL_TO_ROLE_CUST_SUP_V	To populate the cusomer/supplier info in xml
CLN_RN_UTIL_TO_ROLE_INTERNAL_V	View to get To Role Internal information for RosetaNet outbound XGMs
CLN_RN_UTIL_TO_ROLE_SUPPLIER_V	View to get To Role Supplier information for RosetaNet outbound XGMs
CLN_WSH_SS_SHIPITEMS_V	View of delivery line details
CLN_WSH_SS_SHIPMENT_V	View of delivery header details
CLN_XMLG_TXN_TYPES_V	View showing distinct combinations of XML Gateway Transactions Setup
CLN_XML_CONTAINERS_RN_V
CLN_XML_CONTAINERS_V	View for SHIPUNIT containers section in OAG SHOW_SHIPMENT_005 XML payload
CLN_XML_DELIVERIES2_V	View for SHIPMENT deliveries section in OAG SHOW_SHIPMENT_005 XML payload
CLN_XML_DELIVERIES_V	View for SHIPMENT deliveries section in OAG SHOW_SHIPMENT_005 XML payload
CLN_XML_ITEMS2_V	View for SHIPITEM items section in OAG SHOW_SHIPMENT_005 XML payload
CLN_XML_ITEMS_V	View for SHIPITEM items section in OAG SHOW_SHIPMENT_005 XML payload
M4R_3A6_OE_LINE_ACKS	View same as OE_LINE_ACKS, with one additional column MODEL_REFERENCE_TEXT