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

TABLE - RLM.RLM_BLANKET_RSO
TABLE - RLM.RLM_CUST_ITEM_CUM_ADJ_ALL
TABLE - RLM.RLM_CUST_ITEM_CUM_KEYS_ALL
TABLE - RLM.RLM_CUST_ITEM_TERMS_ALL
TABLE - RLM.RLM_CUST_SHIPTO_TERMS_ALL
TABLE - RLM.RLM_DEMAND_EXCEPTIONS
TABLE - RLM.RLM_INTERFACE_HEADERS_ALL
TABLE - RLM.RLM_INTERFACE_LINES_ALL
TABLE - RLM.RLM_MESSAGE_CATEGORY
TABLE - RLM.RLM_SCHEDULE_HEADERS_ALL
TABLE - RLM.RLM_SCHEDULE_LINES_ALL
TABLE - RLM.RLM_SHIP_DELIVERY_CODES
TABLE - RLM.RLM_UI_QUERIES
TABLE - RLM.RLM_UI_QUERY_COLUMNS
VIEW - APPS.RLM_CUM_ADJ_DETAILS_V
VIEW - APPS.RLM_CUM_SHIPFR_CUST_ITEMS_V
VIEW - APPS.RLM_CUM_SHIPFR_SHIPTO_V
VIEW - APPS.RLM_CUM_SHIP_DETAILS_V
VIEW - APPS.RLM_CUM_SITE_USES_V
VIEW - APPS.RLM_CUSTOMERS_V
VIEW - APPS.RLM_CUSTOMER_TERMS_V
VIEW - APPS.RLM_CUST_INV_ITEM_V
VIEW - APPS.RLM_CUST_ITEM_CUM_ADJ_V
VIEW - APPS.RLM_CUST_ITEM_CUM_DETAILS_V
VIEW - APPS.RLM_CUST_ITEM_CUM_KEYS_V
VIEW - APPS.RLM_CUST_ITEM_TERMS_V
VIEW - APPS.RLM_CUST_SHIPTO_TERMS_UNIQUE
VIEW - APPS.RLM_CUST_SHIPTO_TERMS_V
VIEW - APPS.RLM_HRZ_SCHEDULE_LINES_V
VIEW - APPS.RLM_MESSAGE_CATEGORY_V
VIEW - APPS.RLM_OE_ORDER_LINES_V
VIEW - APPS.RLM_SCHEDULE_DATES_V
VIEW - APPS.RLM_SCHEDULE_INTERFACE_HDR_V
VIEW - APPS.RLM_SCHEDULE_INTERFACE_LINES_V
VIEW - APPS.RLM_SCHEDULE_ITEMS_V
VIEW - APPS.RLM_SCHEDULE_LINE_CUM_V
VIEW - APPS.RLM_SHIPTO_ITEM_TERMS_V

Table: RLM_BLANKET_RSO

Description:
Comments

This table stores information related to the effective start and end dates of releases created against a blanket sales agreement.

Indexes
Index Type Tablespace Column
RLM_BLANKET_RSO_U1 UNIQUE APPS_TS_TX_IDX RSO_HDR_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
RLM_BLANKET_RSO_N1 NONUNIQUE APPS_TS_TX_IDX BLANKET_NUMBER
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_ID NUMBER
Y Customer ID
BLANKET_NUMBER NUMBER
Y Blanket Sales Agreement
RSO_HDR_ID NUMBER
Y Release Sales Order Header ID
CUSTOMER_ITEM_ID NUMBER

Customer Item ID
EFFECTIVE_START_DATE DATE
Y Effective Start Date of the release sales order
EFFECTIVE_END_DATE DATE
Y Effective End Date of the release sales order

[top of page]

RLM.RLM_BLANKET_RSO does not reference any database object

RLM.RLM_BLANKET_RSO is referenced by following:

RLM
VIEW - RLM_BLANKET_RSO#

[top of page]

Table: RLM_CUST_ITEM_CUM_ADJ_ALL

Description: This table stores adjustments to the cum for all RLM customer destination items. It has a child relationship to RLM_CUST_ITEM_CUM_KEYS. The adjustments reflect manual CUM adjustment via a form in the Release Management module.If CUM Manag
Primary Key: CUM_ADJ_ID_PK
  1. CUM_ADJ_ID
Comments

This table stores adjustments to the cum for all RLM customer destination items. It has a child relationship to RLM_CUST_ITEM_CUM_KEYS. The adjustments reflect manual CUM adjustment via a form in the Release Management module.

Columns
Name Datatype Length Mandatory Comments
CUM_ADJ_ID NUMBER
Y Unique identifier for CUM Adjustment transaction
CUM_KEY_ID NUMBER
Y Customer Item cum KEY unique ID. FK to RLM_CUST_ITEM_CUM_KEYS
TRANSACTION_DATE_TIME DATE
Y Transaction date/time
ADJUSTMENT_REASON VARCHAR2 (30)
Validated against MTL_TRANSACTION_REASONS.REASON_NAME
ORG_ID NUMBER

Operating unit ID
ADJUSTMENT_REFERENCE VARCHAR2 (240)
Comment field
TRANSACTION_QTY NUMBER

Transaction quantity expressed in the UOM on the CUM Key; for shipment transactions, this is the summarized quantity of all order lines shipped for this item associated with the shipment number; for ATO items, the summary of the features/components
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield context column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who Column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
TP_ATTRIBUTE1 VARCHAR2 (150)
Trading partner flexfield segment column
TP_ATTRIBUTE2 VARCHAR2 (150)
Trading partner flexfield segment column
TP_ATTRIBUTE3 VARCHAR2 (150)
Trading partner flexfield segment column
TP_ATTRIBUTE4 VARCHAR2 (150)
Trading partner flexfield segment column
TP_ATTRIBUTE5 VARCHAR2 (150)
Trading partner flexfield segment column
TP_ATTRIBUTE6 VARCHAR2 (150)
Trading partner flexfield segment column
TP_ATTRIBUTE7 VARCHAR2 (150)
Trading partner flexfield segment column
TP_ATTRIBUTE8 VARCHAR2 (150)
Trading partner flexfield segment column
TP_ATTRIBUTE9 VARCHAR2 (150)
Trading partner flexfield segment column
TP_ATTRIBUTE10 VARCHAR2 (150)
Trading partner flexfield segment column
TP_ATTRIBUTE11 VARCHAR2 (150)
Trading partner flexfield segment column
TP_ATTRIBUTE12 VARCHAR2 (150)
Trading partner flexfield segment column
TP_ATTRIBUTE13 VARCHAR2 (150)
Trading partner flexfield segment column
TP_ATTRIBUTE14 VARCHAR2 (150)
Trading partner flexfield segment column
TP_ATTRIBUTE15 VARCHAR2 (150)
Trading partner flexfield segment column
TP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Trading partner flexfield context column

[top of page]

RLM.RLM_CUST_ITEM_CUM_ADJ_ALL does not reference any database object

RLM.RLM_CUST_ITEM_CUM_ADJ_ALL is referenced by following:

RLM
VIEW - RLM_CUST_ITEM_CUM_ADJ_ALL#

[top of page]

Table: RLM_CUST_ITEM_CUM_KEYS_ALL

Description: This table stores the CUM key values associated with a particular ship-to/ship-from/item combination according to the CUM Management rules defined for the trading partners which are supported in Oracle Release Management.
Primary Key: CUM_KEY_ID_PK
  1. CUM_KEY_ID
Comments

This table stores the CUM key values associated with a particular ship-to/ship-from/item combination according to the CUM Management rules defined for the trading partners which are supported in Oracle Release Management.

Indexes
Index Type Tablespace Column
RLM_CUST_ITEM_CUM_KEYS_U1 UNIQUE APPS_TS_TX_IDX CUM_KEY_ID
SHIP_FROM_ORG_ID
SHIP_TO_ADDRESS_ID
BILL_TO_ADDRESS_ID
INTRMD_SHIP_TO_ID
CUSTOMER_ITEM_ID
CUM_START_DATE
CUST_RECORD_YEAR
PURCHASE_ORDER_NUMBER
RLM_CUST_ITEM_CUM_KEYS_N1 NONUNIQUE APPS_TS_TX_IDX CUSTOMER_ITEM_ID
SHIP_TO_ADDRESS_ID
Columns
Name Datatype Length Mandatory Comments
CUM_KEY_ID NUMBER
Y Customer Item cum KEY unique ID
CUSTOMER_ITEM_ID NUMBER
Y Customer Item unique ID. FK to MTL_CUSTOMER_ITEMS
SHIP_TO_ADDRESS_ID NUMBER

Ship to Address unique ID, if the customer-side CUM Org Level defined for the Ship-from/Ship-to relationship to which this cum key belongs is Ship-to. One of the three address Ids (Ship to, Bill to, or Intermediate Ship to) must be specified
BILL_TO_ADDRESS_ID NUMBER

Bill to Address unique ID, if the customer-side CUM Org Level defined for the Ship-from/Ship-to relationship to which this cum key belongs is Bill-to. One of the three address Ids (Ship to, Bill to, or Intermediate Ship to must be specified.
INTRMD_SHIP_TO_ID NUMBER

Intermediate Ship to Address unique ID, if the customer-side CUM Org Level defined for the Ship-from/Ship-to relationship to which this cum key belongs is Intermediate Ship to. One of the three address Ids (Ship to, Bill to, or Intermediate Ship to) must be specified.
SHIP_FROM_ORG_ID NUMBER

Ship-from organization unique ID. FK to MTL_PARAMETERS. Null only if CUM Org Level is SHIP_TO_ALL_SHIP_FROMS
CUM_START_DATE DATE

If CUM Management is being done, CUM period start date
CUST_RECORD_YEAR VARCHAR2 (35)
If CUM management is being done with Record keeping year significance, the specific record keeping year associated with the cum period
ORG_ID NUMBER

Operating unit unique ID. FK to HR_ORGANIZATION_UNITS.
PURCHASE_ORDER_NUMBER VARCHAR2 (50)
If CUM management is being done with purchase order significance, the specific PO to which this CUM belongs
CUST_UOM_CODE VARCHAR2 (3)
Unit of measure used for CUM calculations related to this CUM Key. FK to MTL_UNITS_OF_MEASURE
CUM_QTY NUMBER

Indicates CUM calculated quantity as per shipment inclusion rule. This column can be used directly, without any further processing, to display current CUM.
CUM_QTY_AFTER_CUTOFF NUMBER

Indicates all shipments that occurred after cut-off time, which are not included in because of shipment inclusion rules.
CUM_QTY_TO_BE_ACCUMULATED NUMBER

Indicates all shipments made for this CUM Key, which are not included in CUM_QTY due to shipment inclusion rule and not included in CUM_QTY_AFTER_CUTOFF. This quantity gets added to CUM_QTY on next shipment or next day, depending on the shipment inclusion rule, when LAST_CUM_QTY_UPDATE_DATE is less than the CUM as-of date and time
LAST_CUM_QTY_UPDATE_DATE DATE

The date/time when CUM_QTY was last updated by shipments and adjustments
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield context column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
TP_ATTRIBUTE1 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE2 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE3 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE4 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE5 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE6 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE7 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE8 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE9 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE10 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE11 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE12 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE13 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE14 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE15 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Trading Partner Flexfield context column
INACTIVE_FLAG VARCHAR2 (1)
A flag to indicate whether CUM is active.
CUM_NOTE_TEXT VARCHAR2 (4000)
Comments (or) Reason for inactivating the CUM.

[top of page]

RLM.RLM_CUST_ITEM_CUM_KEYS_ALL does not reference any database object

RLM.RLM_CUST_ITEM_CUM_KEYS_ALL is referenced by following:

RLM
VIEW - RLM_CUST_ITEM_CUM_KEYS_ALL#

[top of page]

Table: RLM_CUST_ITEM_TERMS_ALL

Description: This table contains new R-12 customer item attributes which are dependent upon the Ship-From Customer Item relationship. Some attributes from Phase 1 were carried forward from VEH_MTL_CUSTOMER_ITEMS, which is being eliminated in Phase 2.
Primary Key: CUST_ITEM_TERMS_PK
  1. CUST_ITEM_TERMS_ID
Comments

This table contains new R-12 customer item attributes which are dependent upon the Ship-From Customer Item relationship. Some attributes from Phase 1 were carried forward from VEH_MTL_CUSTOMER_ITEMS, which is being eliminated in Phase 2.

Indexes
Index Type Tablespace Column
RLM_CUST_ITEM_TERMS_U1 UNIQUE APPS_TS_TX_IDX CUST_ITEM_TERMS_ID
RLM_CUST_ITEM_TERMS_U2 NONUNIQUE APPS_TS_TX_IDX CUSTOMER_ITEM_ID
SHIP_FROM_ORG_ID
CUSTOMER_ID
ADDRESS_ID
ORG_ID
Columns
Name Datatype Length Mandatory Comments
CUST_ITEM_TERMS_ID NUMBER
Y Ship From Customer Item Unique Identifier
CUSTOMER_ITEM_ID NUMBER
Y Customer Item unique identifier. FK to MTL_CUSTOMER_ITEMS.
SHIP_FROM_ORG_ID NUMBER
Y Ship from organization unique identifier. FK to RLM_CUST_SHIPTO_TERMS_ALL
ADDRESS_ID NUMBER

Address unique identifier. FK to RLM_CUST_SHIPTO_TERMS_ALL.
HEADER_ID NUMBER

Unique identifier of the sales order to which the customer item is linked. Demand for this item is placed this sales order by the Release Management demand processor.It will be cleared if the Sales Order is purged. FK to OE_ORDER_HEADERS
AGREEMENT_NAME VARCHAR2 (240)
The Pricing Agreement contract with the customer. The Demand Stream Processor will use this to determine Customer PO Number and pricing. FK to OE_AGREEMENTS
FUTURE_AGREEMENT_NAME VARCHAR2 (240)
The future Pricing Agreement contract with the customer to be used when the current Pricing Agreement expires. The Demand Stream Processor will use this to determine Customer PO Number and pricing . FK to OE_AGREEMENTS.
CALC_CUM_FLAG VARCHAR2 (1)
Flag to indicate, if the ship from is under cum management, whether or not cums should be calculated for this particular item
CUM_CURRENT_START_DATE DATE

Current CUM calculation starting date if CUM_CONTROL_CODE = CUM_UNTIL_MANUAL_RESET
CUM_PREVIOUS_START_DATE DATE

Previous CUM calculation starting date if CUM_CONTROL_CODE = CUM_UNTIL_MANUAL_RESET. To be used in building the CUM key if shipment date is earlier than Current CUM calculation starting date
CUST_ITEM_STATUS_CODE VARCHAR2 (25)
Current Release status of the item, e.g. prototype, production, non-carryover for reporting purposes; this is updated by the material planner, not the EDI transaction. This column can be a selection criteria for future RLM reports. This column is a foreign key to the MTL_ITEM_STATUS table.
ROUND_TO_STD_PACK_FLAG VARCHAR2 (1)
Indicates whether requirements should be rounded up to standard packs. If set on, the additional quantity to fill the std pack is subtracted from the next oldest requirement to avoid most overshipments
SHIP_DELIVERY_RULE_NAME VARCHAR2 (30)
If populated, identifies the shipment /delivery pattern code to be used when calculating the specific shipment dates from the customer release transactions for this item. FK to RLM_SHIP_DELIVERY_CODES
SHIP_METHOD VARCHAR2 (30)
Unique identifier for the shipment method. FK to MTL_INTERORG_SHIP_METHODS
INTRANSIT_TIME NUMBER

In-transit Lead Time between ship-from and ship-to locations, based on default ship method and expressed in time UOM
STD_PACK_QTY NUMBER

If the requirements should be rounded up to standard packs in the Demand Processor, the quantity per pack expressed in the customer UOM.
TIME_UOM_CODE VARCHAR2 (3)
UOM in which in-transit lead time is expressed
ORG_ID NUMBER

Operating unit unique ID. FK to HR_ORGANIZATION_UNITS.
PRICE_LIST_ID NUMBER

Unique identifier for price list associated with customer item if pricing agreement is not used. FK to OE_PRICE_LISTS
DEMAND_TOLERANCE_ABOVE NUMBER

Positive tolerance (high end) for changes to Customer Item demand.
USE_EDI_SDP_CODE_FLAG VARCHAR2 (1) Y Flag that indicates whether you want to used the ship delivery pattern code that the customer sends in on the EDI transactions, if it is populated.
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
PLN_FIRM_DAY_TO NUMBER

Last day from the Planning Schedule horizon start date to which demand will be considered Firm (Shippable).
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield context column
PLN_FORECAST_DAY_FROM NUMBER

First day from the Planning Schedule horizon start date from which demand will be considered Forecast to Order Management
PLN_FORECAST_DAY_TO NUMBER

Last day from the Planning Schedule horizon start date to which demand will be considered Forecast to Order Management.
PLN_FROZEN_DAY_TO NUMBER

Last day from the Planning Schedule horizon start date to which demand will be considered Frozen (cannot be changed)
PLN_FROZEN_DAY_FROM NUMBER

First day from the Planning Schedule horizon start date from which demand will be considered Frozen (cannot be changed).
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment column
SEQ_FIRM_DAY_FROM NUMBER

First day from the Sequenced Schedule horizon start date from which demand will be considered Firm (Shippable)
SEQ_FIRM_DAY_TO NUMBER

Last day from the Sequenced Schedule horizon start date to which demand will be considered Firm (Shippable).
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment column
SEQ_FORECAST_DAY_TO NUMBER

Last day from the Sequenced Schedule horizon start date to which demand will be considered Forecast to Order Management.
SEQ_FORECAST_DAY_FROM NUMBER

First day from the Sequenced Schedule horizon start date from which demand will be considered Forecast to Order Management
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment column
SEQ_FROZEN_DAY_FROM NUMBER

First day from the Sequenced Schedule horizon start date from which demand will be considered Frozen (cannot be changed)
SEQ_FROZEN_DAY_TO NUMBER

Last day from the Sequenced Schedule horizon start date to which demand will be considered Frozen (cannot be changed)
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment column
SHP_FIRM_DAY_FROM NUMBER

First day from the Shipping Schedule horizon start date from which demand will be considered Firm (Shippable).
SHP_FIRM_DAY_TO NUMBER

Last day from the Shipping Schedule horizon start date to which demand will be considered Firm (Shippable) .
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment column
SHP_FROZEN_DAY_TO NUMBER

Last day from the Shipping Schedule horizon start date to which demand will be considered Frozen (cannot be changed)
SHP_FROZEN_DAY_FROM NUMBER

First day from the Shipping Schedule horizon start date from which demand will be considered Frozen (cannot be changed).
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment column
SHP_FORECAST_DAY_TO NUMBER

Last day from the Shipping Schedule horizon start date to which demand will be considered Forecast to Order Management
SHP_FORECAST_DAY_FROM NUMBER

First day from the Shipping Schedule horizon start date from which demand will be considered Forecast to Order Management.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
DEMAND_TOLERANCE_BELOW NUMBER

Negative tolerance (low end) for changes to Customer Item demand
CUSTOMER_CONTACT_ID NUMBER

Customer Contact. FK to RA_CONTACTS
CUSTOMER_ID NUMBER
Y Customer unique identifier. FK to RA_CUSTOMERS
FREIGHT_CODE VARCHAR2 (25)
Default freight code or carrier, to be used by the demand processor to populate the freight carrier on the inbound demand. This can be defaulted from the profile option RLM_default_carrier. FK to ORG_FREIGHT.
PLN_FIRM_DAY_FROM NUMBER

First day from the Planning Schedule horizon start date from which demand will be considered Firm (Shippable).
SUPPLIER_CONTACT_ID NUMBER

Supplier Contact. FK to PER_PEOPLE_F
TP_ATTRIBUTE1 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE2 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE3 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE4 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE5 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE6 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE7 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE8 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE9 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE10 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE11 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE12 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE13 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE14 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE15 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Trading Partner Flexfield context column
INACTIVE_DATE DATE

Date when this customer item terms is no longer valid
COMMENTS VARCHAR2 (240)
Comments related to organization relationship to the customer, ship-to-address or customer item terms.
PLN_MRP_FORECAST_DAY_FROM NUMBER

First day from the Planning schedule horizon start date from which the demand is considered forecast to MRP.
PLN_MRP_FORECAST_DAY_TO NUMBER

Last day from the Planning schedule horizon start date to which the demand is considered forecast to MRP.
SHP_MRP_FORECAST_DAY_FROM NUMBER

First day from the Shipping Schedule horizon start date from which the demand is considered Forecast to MRP.
SHP_MRP_FORECAST_DAY_TO NUMBER

Last day from the Shipping Schedule horizon start date to which the demand is considered Forecast to MRP
SEQ_MRP_FORECAST_DAY_FROM NUMBER

First day from the Sequenced Schedule horizon start date from which the demand is considered Forecast to MRP
SEQ_MRP_FORECAST_DAY_TO NUMBER

Last day from the Sequenced Schedule horizon start date to which the demand is considered Forecast to MRP
DEFAULT_SHIP_FROM VARCHAR2 (1)
Used to designate a default processing rule when multiple Ship-From organizations exist at item level setup
PLN_FROZEN_FLAG VARCHAR2 (1)
If this field is set to Y, the Demand Stream Processor rolls forward the dates on the incoming planning schedule to a non-frozen bucket.
SHP_FROZEN_FLAG VARCHAR2 (1)
If this field is set to Y, the Demand Stream Processor rolls forward the dates on the incoming shipping schedule to a non-frozen bucket.
SEQ_FROZEN_FLAG VARCHAR2 (1)
If this field is set to Y, the Demand Stream Processor rolls forward the dates on the incoming sequenced schedule to a non-frozen bucket.
ISSUE_WARNING_DROP_PARTS_FLAG VARCHAR2 (1)
For future use
BLANKET_NUMBER NUMBER

Blanket Sales Agreement
RELEASE_RULE VARCHAR2 (2)
Release Rule
RELEASE_TIME_FRAME NUMBER

Release Time Frame
RELEASE_TIME_FRAME_UOM VARCHAR2 (3)
Release Time Frame UOM
AGREEMENT_ID NUMBER

Stores the agreement_id of the Pricing Agreement contract with the customer. The Demand Stream Processor will use this to determine Customer PO Number and pricing. FK to OE_AGREEMENTS.
FUTURE_AGREEMENT_ID NUMBER

Stores the agreement_id of the future Pricing Agreement contract with the customer to be used when the current Pricing Agreement expires. The Demand Stream Processor will use this to determine Customer PO Number and pricing . FK to OE_AGREEMENTS.
EXCLUDE_NON_WORKDAYS_FLAG VARCHAR2 (1)
Stores the Value for Option to Exclude Non-workdays from Intransit Time Calculations
DISABLE_CREATE_CUM_KEY_FLAG VARCHAR2 (1)
Stores the Value for Option to Disable Auto-creation of CUM keys

[top of page]

RLM.RLM_CUST_ITEM_TERMS_ALL does not reference any database object

RLM.RLM_CUST_ITEM_TERMS_ALL is referenced by following:

RLM
VIEW - RLM_CUST_ITEM_TERMS_ALL#

[top of page]

Table: RLM_CUST_SHIPTO_TERMS_ALL

Description: This table contains new R-12 customer address attributes which are dependent upon the ship-from/ship-to relationship. Some attributes from Phase 1 were carried forward from VEH_RA_ADDRESSES, which is being eliminated in Phase 2.
Primary Key: CUST_SHIPTO_TERMS_PK
  1. CUST_SHIPTO_TERMS_ID
Comments

This table contains new R-12 customer address attributes which are dependent upon the ship-from/ship-to relationship. Some attributes from Phase 1 were carried forward from VEH_RA_ADDRESSES, which is being eliminated in Phase 2.
This table has one row for each ship-from location associated with a ship-to address.

Indexes
Index Type Tablespace Column
RLM_CUST_SHIPTO_TERMS_U1 UNIQUE APPS_TS_TX_IDX CUSTOMER_ID
ADDRESS_ID
SHIP_FROM_ORG_ID
ORG_ID
RLM_CUST_SHIPTO_TERMS_U2 NONUNIQUE APPS_TS_TX_IDX CUST_SHIPTO_TERMS_ID
Columns
Name Datatype Length Mandatory Comments
CUST_SHIPTO_TERMS_ID NUMBER
Y Customer Ship To Terms unique Identifier
ADDRESS_ID NUMBER

Ship-To Address unique identifier. FK to RA_ADDRESSES
CUSTOMER_ID NUMBER

Customer unique identifier. FK to RA_CUSTOMERS
SHIP_FROM_ORG_ID NUMBER
Y Ship-from Organization unique identifier. FK to MTL_PARAMETERS
CUM_CONTROL_CODE VARCHAR2 (30) Y CUM Management control code. Determines if and how CUM Management is done with this customer address shipments. If CUM Management is done by Purchase Order, the PO number must be included for every item in shipment. If CUM Management is done by Record keeping year, the current Record keeping year must be included in every shipment.. Validated against FND_LOOKUPS.LOOKUP_TYPE = RLM_CUM_CONTROL_CODE
SHIP_METHOD VARCHAR2 (30)
Unique identifier for the shipment method. FK to MTL_INTERORG_SHIP_METHODS
INTRANSIT_TIME NUMBER

In-transit Lead Time between ship-from and ship-to locations, based on default ship method and expressed in time UOM
TIME_UOM_CODE VARCHAR2 (3)
UOM in which in-transit lead time is expressed
SHIP_DELIVERY_RULE_NAME VARCHAR2 (30) Y Default shipment/delivery rule name for this customer address. FK to RLM_SHIP_DELIVERY_CODES
CUM_CURRENT_RECORD_YEAR VARCHAR2 (35)
Customer Current Record keeping year code if applicable to CUM_CONTROL_CODE value. It will be attached to all items on ASNs to this destination
CUM_PREVIOUS_RECORD_YEAR VARCHAR2 (240)
Customer Previous Record keeping year code if applicable to CUM_CONTROL_CODE value. It will be attached to all items on ASNs to this destination
CUM_CURRENT_START_DATE DATE

Current CUM calculation starting date if applicable to CUM_CONTROL_CODE value. It will be attached to all items on ASNs to this destination.
CUM_PREVIOUS_START_DATE DATE

Previous CUM calculation starting date if applicable to CUM_CONTROL_CODE value. To be used in building the CUM key if shipment date is earlier than Current CUM calculation starting date
CUM_ORG_LEVEL_CODE VARCHAR2 (30)
If CUM Management is on, is the business entity levels at which the cum is calculated between the customer and supplier. Validated against FND_LOOKUPS.LOOKUP_TYPE = RLM_CUM_ORG_LEVEL
CUM_SHIPMENT_RULE_CODE VARCHAR2 (30)
If CUM Management is on, this specifies the most recent shipment which should be included in CUM: current, last, or yesterday's shipment. Validated against FND_LOOKUPS.LOOKUP_TYPE = RLM_CUM_SHIPMENT_RULE
CUM_YESTERD_TIME_CUTOFF NUMBER

If CUM Management is on, and yesterday's shipment. is the last shipment to include, this is the cutoff time for yesterday's shipments to be included
CUST_ASSIGN_SUPPLIER_CD VARCHAR2 (35)
The code the customer uses to identify you as a supplier, transmitted by the customer in the N1 segment
CUSTOMER_RCV_CALENDAR_CD VARCHAR2 (10)
Customer receiving calendar code. Used in conjunction with the supplier shipment calendar code. If populated, the Demand Stream Processor will use this calendar when applying ship/delivery pattern rules to ensure the customer site is open for receiving on a calculated shipment arrival date. FK to BOM_CALENDARS
FREIGHT_CODE VARCHAR2 (25)
Default freight code, to be used by the demand processor to populate the freight carrier on the inbound demand. This can be defaulted from the profile option RLM_default_carrier. FK to ORG_FREIGHT
SUPPLIER_SHP_CALENDAR_CD VARCHAR2 (10)
Supplier shipping calendar code. If populated, the Demand Stream Processor will use this calendar when applying ship/delivery pattern rules and lead time offsets to ensure the supplier site is available for shipping on calculated scheduled shipment date. FK to BOM_CALENDARS
UNSHIP_FIRM_CUTOFF_DAYS NUMBER

If UNSHIPPED_FIRM_DISP_CD = DELETE_AFTER_N_DAYS, the number of days before the current date where the requirement is eligible for cancellation.
UNSHIPPED_FIRM_DISP_CD VARCHAR2 (30)
Indicates disposition of old unshipped firm demand when the Demand Stream Processor has new immediate firm demand, since this type of demand cannot be accurately matched by date/quantity. Validated against FND_LOOKUPS.LOOKUP_TYPE = RLM_FIRM_DISP_CODE
USE_EDI_SDP_CODE_FLAG VARCHAR2 (1) Y Flag that indicates whether you want to used the ship delivery pattern code that the customer sends in on the EDI transactions, if it is populated
DEMAND_TOLERANCE_ABOVE NUMBER

Positive tolerance (high end) for changes to Customer Item demand
DEMAND_TOLERANCE_BELOW NUMBER

Negative tolerance (low end) for changes to Customer Item demand
INACTIVE_DATE DATE

Date when this ship from/ship to terms relationship is no longer active
HEADER_ID NUMBER

Unique identifier of the default sales order to which the customer item is linked. Demand for items is placed on this sales order by the Release Management demand processor unless a different SO is specified at the ship-from customer item level. It will be cleared if the Sales Order is purged. FK to OE_ORDER_HEADERS
ORG_ID NUMBER

Operating unit unique ID. FK to HR_ORGANIZATION_UNITS
PRICE_LIST_ID NUMBER

Unique identifier for default price list associated with this ship-from/ship-to relationship if pricing agreement contract is not used. FK to OE_PRICE_LISTS
CRITICAL_ATTRIBUTE_KEY VARCHAR2 (80)
ASCII string of characters which identify the optional matching attributes which are enabled as critical attributes, which must contain a value for the Demand Processor. An exception (warning) will be generated if one of these is missing on Firm demand.
CUSTOMER_CONTACT_ID NUMBER

Customer Contact. FK to RA_CONTACTS
PLN_FIRM_DAY_FROM NUMBER

First day from the Planning Schedule horizon start date from which demand will be considered Firm (Shippable).
PLN_FIRM_DAY_TO NUMBER

Last day from the Planning Schedule horizon start date to which demand will be considered Firm (Shippable).
PLN_FORECAST_DAY_FROM NUMBER

First day from the Planning Schedule horizon start date from which demand will be considered Forecast to Order Management.
PLN_FORECAST_DAY_TO NUMBER

Last day from the Planning Schedule horizon start date to which demand will be considered Forecast to Order Management.
PLN_FROZEN_DAY_TO NUMBER

Last day from the Planning Schedule horizon start date to which demand will be considered Frozen (cannot be changed).
PLN_FROZEN_DAY_FROM NUMBER

First day from the Planning Schedule horizon start date from which demand will be considered Frozen (cannot be changed).
SEQ_FIRM_DAY_FROM NUMBER

First day from the Sequenced Schedule horizon start date from which demand will be considered Firm (Shippable) .
SEQ_FIRM_DAY_TO NUMBER

Last day from the Sequenced Schedule horizon start date to which demand will be considered Firm (Shippable).
SEQ_FORECAST_DAY_TO NUMBER

Last day from the Sequenced Schedule horizon start date to which demand will be considered Forecast to Order Management.
SEQ_FORECAST_DAY_FROM NUMBER

First day from the Sequenced Schedule horizon start date from which demand will be considered Forecast to Order Management.
SEQ_FROZEN_DAY_FROM NUMBER

First day from the Sequenced Schedule horizon start date from which demand will be considered Frozen (cannot be changed)
SEQ_FROZEN_DAY_TO NUMBER

Last day from the Sequenced Schedule horizon start date to which demand will be considered Frozen (cannot be changed)
SHP_FIRM_DAY_FROM NUMBER

First day from the Shipping Schedule horizon start date from which demand will be considered Firm (Shippable).
SHP_FIRM_DAY_TO NUMBER

Last day from the Shipping Schedule horizon start date to which demand will be considered Firm (Shippable) .
SHP_FROZEN_DAY_TO NUMBER

Last day from the Shipping Schedule horizon start date to which demand will be considered Frozen (cannot be changed).
SHP_FROZEN_DAY_FROM NUMBER

First day from the Shipping Schedule horizon start date from which demand will be considered Frozen (cannot be changed).
SHP_FORECAST_DAY_TO NUMBER

Last day from the Shipping Schedule horizon start date to which demand will be considered Forecast to Order Management.
ROUND_TO_STD_PACK_FLAG VARCHAR2 (1)
Indicates whether requirements should be rounded up.
SUPPLIER_CONTACT_ID NUMBER

Supplier Contact. FK to PER_PEOPLE_F.
AGREEMENT_NAME VARCHAR2 (240)
The default Pricing Agreement contract associated with this ship-from/ship-to relationship. The Demand Processor will use this to determine Customer PO Number and pricing unless a different Pricing Agreement is specified at the ship-from customer item level. FK to OE_AGREEMENTS.
STD_PACK_QTY NUMBER

If the requirements should be rounded up to standard packs in the Demand Processor, the quantity per pack expressed in the customer UOM.
FUTURE_AGREEMENT_NAME VARCHAR2 (240)
The future default Pricing Agreement contract associated with this ship-from/ship-to relationship to be used when the current Pricing Agreement expires. The Demand Processor will use this to determine Customer PO Number and pricing if demand is dated after the expiration date of the current Pricing Agreement unless a different future Pricing Agreement is specified at the ship-from customer item level. FK to OE_AGREEMENTS.
SHP_FORECAST_DAY_FROM NUMBER

First day from the Shipping Schedule horizon start date from which demand will be considered Forecast to Order Management
SCHEDULE_HIERARCHY_CODE VARCHAR2 (240)
Hierarchy of schedule types for demand consumption from PLN/SHP/SEQ schedule. Validated against FND_LOOKUPS.LOOKUP_TYPE = RLM_SCHEDULE_HIERARCHY. Mandatory at Customer level
COMMENTS VARCHAR2 (240)
Comments related to the Organization relationship to the Customer, Ship-To Address, or Customer Item. Optional at all levels.
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield context column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
TP_ATTRIBUTE1 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE2 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE3 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE4 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE5 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE6 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE7 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE8 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE9 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE10 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE11 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE12 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE13 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE14 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE15 VARCHAR2 (150)
Trading Partner Flexfield Segment column
TP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Trading Partner Flexfield Context column
MATCH_ACROSS_KEY VARCHAR2 (240)
ASCII string of characters which identify the enabled optional demand matching attributes when demand from different schedule types is being compared. The ASCII character assigned to the matching column is stored in FND_LOOKUPS.LOOKUP_CODE after the comma delimiter.
MATCH_WITHIN_KEY VARCHAR2 (240)
ASCII string of characters which identify the enabled optional demand matching attributes when demand from the same schedule type is being compared. The ASCII character assigned to the matching column is stored in FND_LOOKUPS.LOOKUP_CODE after the comma delimiter.
PLN_MRP_FORECAST_DAY_FROM NUMBER

First day from Planning Schedule horizon start date from which the demand is considered forecast to MRP.
PLN_MRP_FORECAST_DAY_TO NUMBER

Last day from Planning Schedule horizon start date to which the demand is considered forecast to MRP.
SHP_MRP_FORECAST_DAY_FROM NUMBER

First day from Shipping Schedule horizon start date from which the demand is considered forecast to MRP.
SHP_MRP_FORECAST_DAY_TO NUMBER

Last day from Shipping Schedule horizon start date to which the demand is considered forecast to MRP.
SEQ_MRP_FORECAST_DAY_FROM NUMBER

First day from Sequenced Schedule horizon start date from which the demand is considered forecast to MRP.
SEQ_MRP_FORECAST_DAY_TO NUMBER

Last day from Sequenced Schedule horizon start date to which the demand is considered forecast to MRP.
INTRANSIT_CALC_BASIS VARCHAR2 (15)
Used to determine whether receipt or shipment info. should be used to calculate intransit quantities.
DEFAULT_SHIP_FROM VARCHAR2 (1)
Used to designate a default processing rule when multiple Ship-From Organizations exist at customer or address level setup
PLN_FROZEN_FLAG VARCHAR2 (1)
If this field is set to Y, the Demand Stream Processor rolls forward the dates on the incoming planning schedule to a non-frozen bucket.
SHP_FROZEN_FLAG VARCHAR2 (1)
If this field is set to Y, the Demand Stream Processor rolls forward the dates on the incoming shipping schedule to a non-frozen bucket.
SEQ_FROZEN_FLAG VARCHAR2 (1)
If this field is set to Y, the Demand Stream Processor rolls forward the dates on the incoming sequenced schedule to a non-frozen bucket.
ISSUE_WARNING_DROP_PARTS_FLAG VARCHAR2 (1)
For future use
BLANKET_NUMBER NUMBER

Blanket Sales Agreement
RELEASE_RULE VARCHAR2 (2)
Release Rule
RELEASE_TIME_FRAME NUMBER

Release Time Frame
RELEASE_TIME_FRAME_UOM VARCHAR2 (3)
Release Time Frame UOM
AGREEMENT_ID NUMBER

Stores the agreement_id of the Pricing Agreement contract with the customer. The Demand Stream Processor will use this to determine Customer PO Number and pricing. FK to OE_AGREEMENTS.
FUTURE_AGREEMENT_ID NUMBER

Stores the agreement_id of future Pricing Agreement contract with the customer to be used when the current Pricing Agreement expires. The Demand Stream Processor will use this to determine Customer PO Number and pricing . FK to OE_AGREEMENTS.
EXCLUDE_NON_WORKDAYS_FLAG VARCHAR2 (1)
Stores the Value for Option to Exclude Non-workdays from Intransit Time Calculations
DISABLE_CREATE_CUM_KEY_FLAG VARCHAR2 (1)
Stores the Value for Option to Disable Auto-creation of CUM keys

[top of page]

RLM.RLM_CUST_SHIPTO_TERMS_ALL does not reference any database object

RLM.RLM_CUST_SHIPTO_TERMS_ALL is referenced by following:

RLM
VIEW - RLM_CUST_SHIPTO_TERMS_ALL#

[top of page]

Table: RLM_DEMAND_EXCEPTIONS

Description: This table contains Release Management Exception records
Primary Key: EXCEPTION_ID_PK
  1. EXCEPTION_ID
Comments

This table stores the exception messages in the form of errors or warnings , which get generated when the Demand Processor is run.

Indexes
Index Type Tablespace Column
RLM_DEMAND_EXCEPTIONS_U1 UNIQUE APPS_TS_TX_IDX EXCEPTION_ID
SYS_IL0000045854C00079$$ UNIQUE APPS_TS_TX_DATA
RLM_DEMAND_EXCEPTIONS_N1 NONUNIQUE APPS_TS_TX_IDX REQUEST_ID
RLM_DEMAND_EXCEPTIONS_N2 NONUNIQUE APPS_TS_TX_IDX SCHEDULE_HEADER_ID
RLM_DEMAND_EXCEPTIONS_N3 NONUNIQUE APPS_TS_TX_IDX INTERFACE_HEADER_ID
RLM_DEMAND_EXCEPTIONS_N4 NONUNIQUE APPS_TS_TX_IDX MESSAGE_NAME
Columns
Name Datatype Length Mandatory Comments
EXCEPTION_ID NUMBER
Y Exception Unique Identifier
MESSAGE_NAME VARCHAR2 (30) Y The exception code. FK to FND_NEW_MESSAGES.
EXCEPTION_LEVEL VARCHAR2 (1) Y Indicates whether the exception is a warning ('W'), an error ('E'), or information ('I')
CUST_BILL_TO_EXT VARCHAR2 (35)
Bill-To Location
CUST_INTERMD_SHIPTO_EXT VARCHAR2 (35)
External Customer Bill-To Cross Reference
CUST_ITEM_DESCRIPTION VARCHAR2 (80)
Customer Item Description
CUST_JOB_NUMBER VARCHAR2 (50)
Customer Job Number
CUST_MODEL_SERIAL_NUM VARCHAR2 (35)
Customer's Vehicle Identification Number for this sequenced detail, e.g. VIN or Chassis ID.
CUST_NAME_EXT VARCHAR2 (360)
Customer Name, as sent by the customer in the N1 and/or N2 segment.
CUSTOMER_PROD_SEQ_NUM VARCHAR2 (35)
Customer Production Sequence Number, or Delivery Number
CUST_SHIP_FROM_ORG_EXT VARCHAR2 (80)
External Inventory Organization Cross Reference
CUST_SHIP_TO_EXT VARCHAR2 (35)
External Ship-To Address Cross Reference
CUST_UOM_EXT VARCHAR2 (10)
External Customer Unit of Measure Cross Reference
CUSTOMER_ITEM_EXT VARCHAR2 (50)
External Customer Part Number Cross Reference
DATE_TYPE_CODE VARCHAR2 (30)
Type of Start/End Date, e.g. Ship, Delivery, Pull Signal, Cumulative. Validated against FND_LOOKUPS.LOOKUP_TYPE = RLM_DATE_TYPE_CODE
ECE_TP_LOCATION_CODE_EXT VARCHAR2 (35)
For EDI transactions only, EDI Gateway Trading Partner Code assigned to the transaction in the EDI Gateway Common Control Record.
ECE_TP_TRANSLATOR_CODE VARCHAR2 (35)
For EDI transactions only, EDI Gateway Trading Partner Code assigned to the transaction in the EDI Gateway Common Control Record.
EDI_CONTROL_NUM_3 VARCHAR2 (15)
EDI control number 3 (ST) assigned by the customer's EDI translator for audit.
EDI_TEST_INDICATOR VARCHAR2 (1)
EDI Test/Production trasaction indicator (T or P), assigned by the customer's EDI translator. EDI Gateway rules determine the handling of test transactions within the Demand Processor.
EXCEPTION_ATTRIBUTE1 VARCHAR2 (150)
Exception place holder flexfield (not standard AOL)
EXCEPTION_ATTRIBUTE10 VARCHAR2 (150)
Exception place holder flexfield (not standard AOL)
EXCEPTION_ATTRIBUTE11 VARCHAR2 (150)
Exception place holder flexfield (not standard AOL)
EXCEPTION_ATTRIBUTE12 VARCHAR2 (150)
Exception place holder flexfield (not standard AOL)
EXCEPTION_ATTRIBUTE13 VARCHAR2 (150)
Exception place holder flexfield (not standard AOL)
EXCEPTION_ATTRIBUTE14 VARCHAR2 (150)
Exception place holder flexfield (not standard AOL)
EXCEPTION_ATTRIBUTE15 VARCHAR2 (150)
Exception place holder flexfield (not standard AOL)
EXCEPTION_ATTRIBUTE16 VARCHAR2 (150)
Exception place holder flexfield (not standard AOL)
EXCEPTION_ATTRIBUTE17 VARCHAR2 (150)
Exception place holder flexfield (not standard AOL)
EXCEPTION_ATTRIBUTE18 VARCHAR2 (150)
Exception place holder flexfield (not standard AOL)
EXCEPTION_ATTRIBUTE19 VARCHAR2 (150)
Exception place holder flexfield (not standard AOL)
EXCEPTION_ATTRIBUTE2 VARCHAR2 (150)
Exception place holder flexfield (not standard AOL)
EXCEPTION_ATTRIBUTE20 VARCHAR2 (150)
Exception place holder flexfield (not standard AOL)
EXCEPTION_ATTRIBUTE3 VARCHAR2 (150)
Exception place holder flexfield (not standard AOL)
EXCEPTION_ATTRIBUTE4 VARCHAR2 (150)
Exception place holder flexfield (not standard AOL)
EXCEPTION_ATTRIBUTE5 VARCHAR2 (150)
Exception place holder flexfield (not standard AOL)
EXCEPTION_ATTRIBUTE6 VARCHAR2 (150)
Exception place holder flexfield (not standard AOL)
EXCEPTION_ATTRIBUTE7 VARCHAR2 (150)
Exception place holder flexfield (not standard AOL)
EXCEPTION_ATTRIBUTE8 VARCHAR2 (150)
Exception place holder flexfield (not standard AOL)
EXCEPTION_ATTRIBUTE9 VARCHAR2 (150)
Exception place holder flexfield (not standard AOL)
ITEM_DETAIL_QUANTITY NUMBER

Requested quantity. If Item_Detail_Type = 0, 1, 2, this is the demand quantity. If Item_Detail_Type = 3, this is the authorization quantity. If Item_Detail_Type = 4, this is the shipped, received or CUM quantity. If Item_Detail_Type = 5, this is a miscellaneous quantity, such as ahead/behind, inventory balance, etc.
ITEM_DETAIL_SUBTYPE VARCHAR2 (30)
Schedule item detail row sub-type: For firm or forecast demand, Bucket type associated with the demand date/quantity; for authorizations, the type of authorizations, the type of authorization; for shipment/receipt, cumulative or last. Validated against FND_LOOKUPS
ITEM_DETAIL_TYPE VARCHAR2 (30)
Schedule item detail row type:0 = Past Due Firm,1 = Firm Demand,2 = Forecast Demand, 3 = Authorization,4 = Shipment/Receipt Info,5 = OtherValidated against FND_LOOKUPS.LOOKUP_TYPE = RLM_DETAIL_TYPE_CODE
MESSAGE_TEXT VARCHAR2 (3999)
Exception message
QTY_TYPE_CODE VARCHAR2 (30)
Actual or Cumulative. Validated against FND_LOOKUPS.LOOKUP_TYPE=RLM_QTY_TYPE_CODE
INTERFACE_HEADER_ID NUMBER

Interface header Unique Identifier
INTERFACE_LINE_ID NUMBER

Interface Line Unique Identifier. This column will be null if an error or warning pertained to the schedule header.
SCHEDULE_HEADER_ID NUMBER

Schedule header unique indentifier
SCHEDULE_LINE_ID NUMBER

Schedule item unique identifier
SCHEDULE_TYPE VARCHAR2 (30)
Schedule Type: Planning, Shipping or Sequenced. Validated against FND_LOOKUPS.LOOKUP_TYPE = RLM_SCHEDULE_TYPE.
SCHED_GENERATION_DATE DATE

Date customer generated either during the schedule or the planning information on the schedule.
SCHEDULE_ITEM_NUM NUMBER

Schedule Item Number, the means to identify how item demand and information is grouped by the customer within the schedule.
SCHEDULE_PURPOSE VARCHAR2 (30)
Schedule purpose code, i.e. Original, Replace, Cancellation, etc. Validated against FND_LOOKUPS.LOOKUP_TYPE = RLM_SCHEDULE_PURPOSE.
SCHEDULE_REFERENCE_NUM VARCHAR2 (35)
Customer assigned schedule reference or release number
SCHEDULE_SOURCE VARCHAR2 (30)
EDI or manual transaction source for this schedule, i.e. 830, 862, 866, DELFOR, MANUAL, etc.
START_DATE_TIME DATE

Customer-specified date/time, as transmitted by the customer on the EDI transaction.
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Request Identifier
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who Column
INVENTORY_ITEM VARCHAR2 (50)
Inventory Item Number
SCHEDULE_LINE_NUMBER NUMBER

Schedule Line Number
HORIZON_START_DATE DATE

Horizon Start Date
HORIZON_END_DATE DATE

Horizon End Date
ORDER_HEADER_ID NUMBER

Order Header Identifier
ORDER_LINE_ID NUMBER

Order Line Identifier
REQUEST_DATE DATE

Request Date
INDUSTRY_ATTRIBUTE1 VARCHAR2 (150)
Industry Attribute1. Also Customer Record Year.
SCHEDULE_DATE VARCHAR2 (240)
Schedule Date
CUST_PO_NUMBER VARCHAR2 (50)
Customer Purchase Order Number
CUSTOMER_DOCK_CODE VARCHAR2 (35)
Customer Dock Code
CUST_PRODUCTION_LINE VARCHAR2 (50)
Customer Production Line
PURGE_STATUS VARCHAR2 (30)
Indicates if an exception caused by Purge Concurrent Program
ORIGIN_TABLE VARCHAR2 (9)
Indicates to the Purge Schedule Concurrent Program whether the schedule data comes from interface or archive tables.
REPORT_SUMMARY CLOB (4000)
Contains additional information related to the error encountered in Process Order API and specified in MESSAGE_TEXT

[top of page]

RLM.RLM_DEMAND_EXCEPTIONS does not reference any database object

RLM.RLM_DEMAND_EXCEPTIONS is referenced by following:

RLM
VIEW - RLM_DEMAND_EXCEPTIONS#

[top of page]

Table: RLM_INTERFACE_HEADERS_ALL

Description: This table stores the header level details of the Release Management schedules. It has details pertainig to the specific schedule and customer level information. EDI Gateway will feed into this table for the demand transactions of Planning,
Primary Key: HEADER_ID_PK
  1. HEADER_ID
Comments

This table stores the header level details of the Release Management
schedules. It has details pertaining to the specific schedule and customer
level information. EDI Gateway will feed into this table for the demand
transactions of Planning, Shipping and Sequenced Schedules.
Scope: public
Lifecycle: active
Display Name: Release Management Headers Interface
Product: RLM
Category: BUSINESS_ENTITY RLM_SCHEDULE

Indexes
Index Type Tablespace Column
RLM_HEADERS_INTERFACE_U1 UNIQUE APPS_TS_TX_IDX HEADER_ID
RLM_INTERFACE_HEADERS_N1 NONUNIQUE APPS_TS_TX_IDX SCHEDULE_HEADER_ID
RLM_INTERFACE_HEADERS_N2 NONUNIQUE APPS_TS_TX_IDX ECE_TP_LOCATION_CODE_EXT
RLM_INTERFACE_HEADERS_N3 NONUNIQUE APPS_TS_TX_IDX CUSTOMER_ID
RLM_INTERFACE_HEADERS_N4 NONUNIQUE APPS_TS_TX_IDX SCHEDULE_REFERENCE_NUM
RLM_INTERFACE_HEADERS_N5 NONUNIQUE APPS_TS_TX_IDX SCHED_HORIZON_START_DATE
RLM_INTERFACE_HEADERS_N6 NONUNIQUE APPS_TS_TX_IDX CUST_NAME_EXT
Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER
Y Sequence Generated Unique Identifier
CUST_ADDRESS_1_EXT VARCHAR2 (35)
Customer address line 1, as sent by the customer on the N3 segment.
CUST_ADDRESS_2_EXT VARCHAR2 (35)
Customer address line 2, as sent by the customer on the N3 segment.
CUST_ADDRESS_3_EXT VARCHAR2 (35)
Customer address line 3, as sent by the customer on the N3 segment.
CUST_ADDRESS_4_EXT VARCHAR2 (35)
Customer address line 4, as sent by the customer on the N3 segment.
CUST_CITY_EXT VARCHAR2 (30)
Customer address city, as sent by the customer on the N4 segment.
CUST_COUNTRY_EXT VARCHAR2 (3)
Customer country, as sent by the customer on the N4 segment.
CUST_COUNTY_EXT VARCHAR2 (25)
Customer county, as sent by the customer on the N4 segment.
CUSTOMER_EXT VARCHAR2 (30)
Trading Partner designator Cross Reference
CUST_NAME_EXT VARCHAR2 (360)
Customer Name, as sent by the customer in the N1 and/or N2 segment.
CUST_POSTAL_CD_EXT VARCHAR2 (15)
Customer address postal code,as sent by the customer on the N4 segment.
CUST_PROVINCE_EXT VARCHAR2 (10)
Customer province, as sent by the customer on the N4 segment.
CUST_STATE_EXT VARCHAR2 (10)
Customer state, as sent by the customer on the N4 segment.
CUSTOMER_ID NUMBER

Customer Identifier. FK to RA_CUSTOMERS.
ECE_PRIMARY_ADDRESS_ID NUMBER

Customer Primary Address ID populated by EDI Gateway code conversion of external Trading Partner Location Code. FK to RA_ADDRESSES.
ECE_TP_LOCATION_CODE_EXT VARCHAR2 (35)
For EDI transactions only, external Trading Partner Location Code assigned to the location in the EDI Gateway Common Control Record .
ECE_TP_TRANSLATOR_CODE VARCHAR2 (35)
For EDI transactions only, EDI Gateway Trading Partner Code assigned to the transaction in the EDI Gateway Common Control Record .
EDI_CONTROL_NUM_1 VARCHAR2 (15)
EDI control number 1 (ISA) assigned by the customer EDI translator for audit.
EDI_CONTROL_NUM_2 VARCHAR2 (15)
EDI control number 2 (GS) assigned by the customer EDI translator for audit.
EDI_CONTROL_NUM_3 VARCHAR2 (15)
EDI control number 3 (ST) assigned by the customer EDI translator for audit.
EDI_TEST_INDICATOR VARCHAR2 (1)
EDI Test/Production transaction indicator (T or P), assigned by the customer EDI translator. EDI Gateway rules determine the handling of test transactions within the Demand Processor.
HEADER_CONTACT_CODE_1 VARCHAR2 (3)
Contact code 1 included in customer EDI transaction (not validated)
HEADER_CONTACT_CODE_2 VARCHAR2 (3)
Contact code 2 included in customer EDI transaction (not validated)
HEADER_CONTACT_VALUE_1 VARCHAR2 (80)
Values associated with Contact code 1: concatenation of name, communication code, and communication number
HEADER_CONTACT_VALUE_2 VARCHAR2 (80)
Values associated with Contact code 2 : concatenation of name, communication code, and communication number
HEADER_NOTE_TEXT VARCHAR2 (4000)
Free form note text included in the schedule at the header level
HEADER_REF_CODE_1 VARCHAR2 (3)
Reference code 1 included in customer EDI transaction
HEADER_REF_CODE_2 VARCHAR2 (3)
Reference code 2 included in customer EDI transaction
HEADER_REF_CODE_3 VARCHAR2 (3)
Reference code 3 included in customer EDI transaction
HEADER_REF_VALUE_1 VARCHAR2 (35)
Value associated with Reference code 1
HEADER_REF_VALUE_2 VARCHAR2 (35)
Value associated with Reference code 2
HEADER_REF_VALUE_3 VARCHAR2 (35)
Value associated with Reference code 3
ORG_ID NUMBER

Operating unit unique ID. FK to HR_ORGANIZATION_UNITS.
PROCESS_STATUS NUMBER

Indicates the current processing status of a record (1=do not process, 2=waiting to be processed, 3=in process, 4=error, 5=processed, 6='processed with error(s)' for headers with lines in-error.
SCHEDULE_HEADER_ID NUMBER

Schedule header unique identifier. FK to RLM_SCHEDULE_HEADERS
SCHEDULE_TYPE VARCHAR2 (30)
Schedule Type: Planning, Shipping or Sequenced. Validated against FND_LOOKUPS.LOOKUP_TYPE = RLM_SCHEDULE_TYPE.
SCHEDULE_TYPE_EXT VARCHAR2 (30)
External value from which RLM_SCHEDULE_TYPE was derived in EDI Gateway Code Conversion.
SCHED_GENERATION_DATE DATE

Date customer generated either the schedule or the planning information on the schedule.
SCHED_HORIZON_END_DATE DATE

Schedule horizon end date (to be derived based on demand contained within the schedule if not specified)
SCHED_HORIZON_START_DATE DATE

Schedule horizon start date (to be derived based on demand contained within the schedule if not specified)
SCHEDULE_PURPOSE VARCHAR2 (30)
Schedule purpose code, i.e. Original, Replace, Cancellation, etc. Validated against FND_LOOKUPS.LOOKUP_TYPE =RLM_SCHEDULE_PURPOSE
SCHEDULE_PURPOSE_EXT VARCHAR2 (30)
External value from which SCHEDULE_PURPOSE was derived in EDI Gateway Code Conversion.
SCHEDULE_REFERENCE_NUM VARCHAR2 (35)
Customer assigned schedule reference or release number
SCHEDULE_SOURCE VARCHAR2 (30)
EDI or manual transaction source for this schedule, i.e. 830, 862, 866, DELFOR, MANUAL, etc.
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield context column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
TP_ATTRIBUTE1 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE2 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE3 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE4 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE5 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE6 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE7 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE8 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE9 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE10 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE11 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE12 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE13 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE14 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE15 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Trading Partner flexfield context column
CUST_ADDRESS_5_EXT VARCHAR2 (35)
For future use
CUST_ADDRESS_6_EXT VARCHAR2 (35)
For future use
CUST_ADDRESS_7_EXT VARCHAR2 (35)
For future use
CUST_ADDRESS_8_EXT VARCHAR2 (35)
For future use
CUST_ADDRESS_9_EXT VARCHAR2 (35)
For future use
ONE_TIME_CUST_FLAG_EXT VARCHAR2 (35)
For future use
CURRENCY_EXT VARCHAR2 (35)
For future use
TAX_EXEMPT_FLAG_EXT VARCHAR2 (35)
For future use
TAX_ID_EXT VARCHAR2 (35)
For future use
HEADER_CONTACT_EMAIL_1_EXT VARCHAR2 (50)
For future use
HEADER_CONTACT_EMAIL_2_EXT VARCHAR2 (50)
For future use
HEADER_CONTACT_FAX_1_EXT VARCHAR2 (35)
For future use
HEADER_CONTACT_FAX_2_EXT VARCHAR2 (35)
For future use
HEADER_CONTACT_TEL_1_EXT VARCHAR2 (50)
For future use
HEADER_CONTACT_TEL_2_EXT VARCHAR2 (50)
For future use
CUST_FAX_EXT VARCHAR2 (35)
For future use
CUST_REGION_EXT VARCHAR2 (35)
For future use
CUST_TAX_JURISDICTION_EXT VARCHAR2 (35)
For future use
CUST_TEL_EXT VARCHAR2 (35)
For future use
CUST_URL_EXT VARCHAR2 (100)
For future use
ORIGINAL_DOCUMENT_DATE DATE

For future use
RESP_DOCUMENT_DATE DATE

For future use
DOCUMENT_DESCRIPTION VARCHAR2 (50)
For future use
DOCUMENT_REV_NUM VARCHAR2 (35)
For future use
RESP_SCHEDULE_ID VARCHAR2 (35)
For future use
RESP_DOCUMENT_REV_NUM VARCHAR2 (35)
For future use
BUCKET_END_DATE DATE

For future use
BUCKET_START_DATE DATE

For future use
FLEX_BUCKET_CODE VARCHAR2 (30)
For future use
SUPPLIER_NAME_EXT VARCHAR2 (60)
For future use
ONE_TIME_SUPPLIER_FLAG_EXT VARCHAR2 (35)
For future use
SUPPLIER_ID NUMBER

For future use
SUPPLIER_CURRENCY_EXT VARCHAR2 (35)
For future use
SUPPLIER_DESCRIPTION_EXT VARCHAR2 (35)
For future use
CUST_DESCRIPTION_EXT VARCHAR2 (35)
For future use
SUPPLIER_TAX_EXEMPT_FLAG_EXT VARCHAR2 (35)
For future use
SUPPLIER_TAX_ID_EXT VARCHAR2 (35)
For future use
SUPPLIER_ADDRESS_1_EXT VARCHAR2 (35)
For future use
SUPPLIER_ADDRESS_2_EXT VARCHAR2 (35)
For future use
SUPPLIER_ADDRESS_3_EXT VARCHAR2 (35)
For future use
SUPPLIER_ADDRESS_4_EXT VARCHAR2 (35)
For future use
SUPPLIER_ADDRESS_5_EXT VARCHAR2 (35)
For future use
SUPPLIER_ADDRESS_6_EXT VARCHAR2 (240)
For future use
SUPPLIER_ADDRESS_7_EXT VARCHAR2 (35)
For future use
SUPPLIER_ADDRESS_8_EXT VARCHAR2 (35)
For future use
SUPPLIER_ADDRESS_9_EXT VARCHAR2 (35)
For future use
SUPPLIER_CITY_EXT VARCHAR2 (30)
For future use
SUPPLIER_COUNTY_EXT VARCHAR2 (35)
For future use
SUPPLIER_FAX_EXT VARCHAR2 (35)
For future use
SUPPLIER_POSTAL_CD_EXT VARCHAR2 (15)
For future use
SUPPLIER_REGION_EXT VARCHAR2 (35)
For future use
SUPPLIER_STATE_EXT VARCHAR2 (10)
For future use
SUPPLIER_PROVINCE_EXT VARCHAR2 (10)
For future use
SUPPLIER_TAX_JURISDICTION_EXT VARCHAR2 (35)
For future use
SUPPLIER_TEL_EXT VARCHAR2 (35)
For future use
SUPPLIER_URL_EXT VARCHAR2 (100)
For future use
SUP_HEADER_CONTACT_CODE_1 VARCHAR2 (3)
For future use
SUP_HEADER_CONTACT_CODE_2 VARCHAR2 (3)
For future use
SUP_HEADER_CONTACT_VALUE_1 VARCHAR2 (80)
For future use
SUP_HEADER_CONTACT_VALUE_2 VARCHAR2 (80)
For future use
SUP_HEADER_CONTACT_EMAIL_1_EXT VARCHAR2 (50)
For future use
SUP_HEADER_CONTACT_EMAIL_2_EXT VARCHAR2 (50)
For future use
SUP_HEADER_CONTACT_FAX_1_EXT VARCHAR2 (35)
For future use
SUP_HEADER_CONTACT_FAX_2_EXT VARCHAR2 (35)
For future use
SUP_HEADER_CONTACT_TEL_1_EXT VARCHAR2 (50)
For future use
SUP_HEADER_CONTACT_TEL_2_EXT VARCHAR2 (50)
For future use
SUPPLIER_COUNTRY_EXT VARCHAR2 (3)
For future use

[top of page]

RLM.RLM_INTERFACE_HEADERS_ALL does not reference any database object

RLM.RLM_INTERFACE_HEADERS_ALL is referenced by following:

RLM
VIEW - RLM_INTERFACE_HEADERS_ALL#

[top of page]

Table: RLM_INTERFACE_LINES_ALL

Description: EDI Inbound Gateway feeds into this table which stores the item and item detail level information associated with customer planning, shipping, or production sequenced schedules.
Primary Key: LINE_ID_PK
  1. LINE_ID
Comments

This table stores the item and item detail level information associated with
customer planning, shipping, or production sequenced schedules. For
production sequence schedules, the item represents the feature, not the
configuration.
This table stores all details for scheduled items: dated demand,
authorizations, and customer shipment/receipt information. It has a child
relationship to RLM_INTERFACE_HEADERS.
Scope: public
Lifecycle: active
Display Name: Release Management Lines Interface
Product: RLM
Category: BUSINESS_ENTITY RLM_SCHEDULE

Indexes
Index Type Tablespace Column
RLM_LINES_INTERFACE_U1 UNIQUE APPS_TS_TX_IDX LINE_ID
HEADER_ID
RLM_INTERFACE_LINES_N1 NONUNIQUE APPS_TS_TX_IDX HEADER_ID
CUSTOMER_ITEM_ID
ITEM_DETAIL_SUBTYPE
RLM_INTERFACE_LINES_N2 NONUNIQUE APPS_TS_TX_IDX HEADER_ID
INVENTORY_ITEM_ID
RLM_INTERFACE_LINES_N3 NONUNIQUE APPS_TS_TX_IDX HEADER_ID
CUSTOMER_ITEM_EXT
RLM_INTERFACE_LINES_N4 NONUNIQUE APPS_TS_TX_IDX HEADER_ID
CUSTOMER_ITEM_ID
SHIP_FROM_ORG_ID
SHIP_TO_ADDRESS_ID
ORDER_HEADER_ID
PROCESS_STATUS
RLM_INTERFACE_LINES_N5 NONUNIQUE APPS_TS_TX_IDX HEADER_ID
CUSTOMER_ITEM_ID
INVENTORY_ITEM_ID
SHIP_TO_ORG_ID
ORDER_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
LINE_ID NUMBER
Y Sequence Generated Unique Identifier
HEADER_ID NUMBER
Y Sequence Generated Unique Identifier foreign key to the RLM_INTERFACE_HEADERS_ALL.
AGREEMENT_ID NUMBER

Unique identifier for agreement on which customer purchase order is associated. FK to RA_AGREEMENTS
ATO_DATA_TYPE VARCHAR2 (30)
Code to describe what type of data is included for the ATO item (1=Model and Options, 2=Model, 3=Options.) Validated against FND_LOOKUPS.LOOKUP_TYPE =RLM_ITEM_METHOD_TYPE
BILL_TO_ADDRESS_1_EXT VARCHAR2 (35)
Bill To address line 1, as sent by the customer on the N3 segment.
BILL_TO_ADDRESS_2_EXT VARCHAR2 (35)
Bill To address line 2, as sent by the customer on the N3 segment.
BILL_TO_ADDRESS_3_EXT VARCHAR2 (35)
Bill To address line 3, as sent by the customer on the N3 segment.
BILL_TO_ADDRESS_4_EXT VARCHAR2 (35)
Bill To address line 4, as sent by the customer on the N3 segment.
BILL_TO_ADDRESS_ID NUMBER

Bill To address identifier. FK to RA_ADDRESSES.
INVOICE_TO_ORG_ID NUMBER

Unique identifier for invoice-to organization which relates to BILL_TO_ADDRESS_ID. FK to HR_ORGANIZATIONS
BILL_TO_CITY_EXT VARCHAR2 (30)
Bill To address city, as sent by the customer on the N4 segment.
BILL_TO_COUNTRY_EXT VARCHAR2 (3)
Bill To country, as sent by the customer on the N4 segment.
BILL_TO_COUNTY_EXT VARCHAR2 (25)
Bill To county, as sent by the customer on the N4 segment.
BILL_TO_NAME_EXT VARCHAR2 (60)
Bill To Name, as sent by the customer in the N1 and/or N2 segment.
BILL_TO_POSTAL_CD_EXT VARCHAR2 (15)
Bill To address postal code,as sent by the customer on the N4 segment.
BILL_TO_PROVINCE_EXT VARCHAR2 (10)
Bill To province, as sent by the customer on the N4 segment.
BILL_TO_SITE_USE_ID NUMBER

Bill To site use identifier. FK to RA_SITE_USES.
BILL_TO_STATE_EXT VARCHAR2 (10)
Bill To state, as sent by the customer on the N4 segment.
CARRIER_ID_CODE_EXT VARCHAR2 (35)
The carrier id, as sent by the customer on the TD5 segment.
CARRIER_QUALIFIER_EXT VARCHAR2 (3)
The carrier qualifier, as sent by the customer on the TD5 segment.
COMMODITY_EXT VARCHAR2 (35)
Customer specified commodity code
COUNTRY_OF_ORIGIN_EXT VARCHAR2 (35)
Customer-specified country of origin
CUST_ASSEMBLY_EXT VARCHAR2 (30)
The customer assembly identification, as sent on the LIN segment of the 866 txn.
CUST_ASSIGNED_ID_EXT VARCHAR2 (20)
Customer assigned identification for differentiation within a transaction set, from LIN01.
CUST_BILL_TO_EXT VARCHAR2 (35)
External Customer Bill To Cross Reference
CUST_CONTRACT_NUM_EXT VARCHAR2 (35)
The customer contract number, as sent on the LIN segment of the 830 txn.
CUSTOMER_DOCK_CODE VARCHAR2 (50)
Customer dock code.
CUST_INTRMD_SHIP_TO_EXT VARCHAR2 (35)
External Intermediate ship to Cross Reference
CUST_ITEM_PRICE_EXT NUMBER

Price included on the customer EDI transaction.
CUST_ITEM_PRICE_UOM_EXT VARCHAR2 (3)
UOM corresponding to the price included on teh customer EDI transaction.
CUSTOMER_ITEM_REVISION VARCHAR2 (3)
Customer part revision included on schedule
CUSTOMER_JOB VARCHAR2 (50)
Customer job number
CUST_MANUFACTURER_EXT VARCHAR2 (35)
The manufacturer, as sent by the customer on the LIN segment of the 866 txn.
CUST_MODEL_NUMBER_EXT VARCHAR2 (35)
Customer Model Number for this sequenced detail
CUST_MODEL_SERIAL_NUMBER VARCHAR2 (35)
Customer Vehicle Identification Number for this sequenced detail, e.g. VIN or Chassis ID.
CUST_ORDER_NUM_EXT VARCHAR2 (35)
The order number as sent by the customer on the LIN segment of the 866 and 830 txn.
CUST_PROCESS_NUM_EXT VARCHAR2 (35)
The process number, as sent by the customer on the LIN segment of the 866 and 862 transaction.
CUST_PRODUCTION_LINE VARCHAR2 (50)
Customer production line
CUST_PRODUCTION_SEQ_NUM VARCHAR2 (35)
Customer Production Sequence Number, or Delivery Number
CUST_SET_NUM_EXT VARCHAR2 (35)
The customer set number, as sent on the LIN segment of the 862 and 866 txns.
CUST_SHIP_FROM_ORG_EXT VARCHAR2 (80)
External Inventory Organization Cross Reference
CUST_SHIP_TO_EXT VARCHAR2 (35)
External Ship to address Cross Reference
CUST_UOM_EXT VARCHAR2 (10)
External Customer unit of measure cross reference
CUSTOMER_ITEM_EXT VARCHAR2 (50)
External Customer part number Cross Reference
CUSTOMER_ITEM_ID NUMBER

Customer item identifier. FK to MTL_CUSTOMER_ITEMS.
REQUEST_DATE DATE

The date and time the customer wants the material delivered or shipped, based on whether the requirements are delivery based or ship based
SCHEDULE_DATE DATE

Planned shipment date and time (request_date - delivery lead time if delivery based)
DATE_TYPE_CODE VARCHAR2 (30)
Type of start/end date, e.g. ship, deliver, Pull signal, Cumulative. Validated against FND_LOOKUPS.LOOKUP_TYPE =RLM_DATE_TYPE_CODE
DATE_TYPE_CODE_EXT VARCHAR2 (30)
External value from which DATE_TYPE_CODE was derived in EDI Gateway Code Conversion.
DELIVERY_LEAD_TIME NUMBER

For demand lines, the difference between arrival and shipment dates, based on default shipping method between the ship-from and ship-to locations. This is determined by the Calculate Ship Date routine and passed into Order Import.
END_DATE_TIME DATE

Customer-specified optional end date/time, applicable for flexible bucketed requirements, and cumulative information such as authorizations and shipped/received
EQUIPMENT_CODE_EXT VARCHAR2 (3)
The equipment code, as sent by the customer on the TD3 segment.
EQUIPMENT_NUMBER_EXT VARCHAR2 (35)
The equipment number, as sent by the customer on the TD3 segment.
HANDLING_CODE_EXT VARCHAR2 (3)
Special handling code as sent by the customer in the TD4 segment.
HAZARD_CODE_EXT VARCHAR2 (10)
Hazardous Material Code corresponding to the Hazardous Material Code Qualifier as sent by the customer in the TD4 segment.
HAZARD_CODE_QUAL_EXT VARCHAR2 (3)
Hazardous Material Code Qualifier as sent by the customer in the TD4 segment.
HAZARD_DESCRIPTION_EXT VARCHAR2 (80)
Hazardous Material Description as sent by the customer in the TD4 segment.
IMPORT_LICENSE_DATE_EXT DATE

Customer Import License Date
IMPORT_LICENSE_EXT VARCHAR2 (35)
Customer Import License for shipment destination country
INDUSTRY_ATTRIBUTE1 VARCHAR2 (150)
Record keeping or model year.
INDUSTRY_ATTRIBUTE10 VARCHAR2 (150)
Industry Descriptive Flexfield
INDUSTRY_ATTRIBUTE11 VARCHAR2 (150)
Industry Descriptive Flexfield
INDUSTRY_ATTRIBUTE12 VARCHAR2 (150)
Industry Descriptive Flexfield
INDUSTRY_ATTRIBUTE13 VARCHAR2 (150)
Industry Descriptive Flexfield
INDUSTRY_ATTRIBUTE14 VARCHAR2 (150)
Industry Descriptive Flexfield
INDUSTRY_ATTRIBUTE15 VARCHAR2 (150)
Industry Descriptive Flexfield
INDUSTRY_ATTRIBUTE2 VARCHAR2 (150)
Industry Descriptive Flexfield
INDUSTRY_ATTRIBUTE3 VARCHAR2 (150)
Industry Descriptive Flexfield
INDUSTRY_ATTRIBUTE4 VARCHAR2 (150)
Industry Descriptive Flexfield
INDUSTRY_ATTRIBUTE5 VARCHAR2 (150)
Industry Descriptive Flexfield
INDUSTRY_ATTRIBUTE6 VARCHAR2 (150)
Industry Descriptive Flexfield
INDUSTRY_ATTRIBUTE7 VARCHAR2 (150)
Industry Descriptive Flexfield
INDUSTRY_ATTRIBUTE8 VARCHAR2 (150)
Industry Descriptive Flexfield
INDUSTRY_ATTRIBUTE9 VARCHAR2 (150)
Industry Descriptive Flexfield
INDUSTRY_CONTEXT VARCHAR2 (30)
Industry Descriptive context Flexfield
INTRMD_SHIP_TO_ID NUMBER

Customer Intermediate Ship-to Destination unique identifier. FK to RA_ADDRESSES
SHIP_TO_ORG_ID NUMBER

Unique identifier for ship-to organization which relates to SHIP_TO_ADDRESS_ID. FK to HR_ORGANIZATIONS
INTRMD_ST_ADDRESS_1_EXT VARCHAR2 (35)
Intermediate Ship To address line 1, as sent by the customer on the N3 segment.
INTRMD_ST_ADDRESS_2_EXT VARCHAR2 (35)
Intermediate Ship To address line 2, as sent by the customer on the N3 segment.
INTRMD_ST_ADDRESS_3_EXT VARCHAR2 (35)
Intermediate Ship To address line 3, as sent by the customer on the N3 segment.
INTRMD_ST_ADDRESS_4_EXT VARCHAR2 (35)
Intermediate Ship To address line 4, as sent by the customer on the N3 segment.
INTRMD_ST_CITY_EXT VARCHAR2 (30)
Intermediate Ship To address city, as sent by the customer on the N4 segment.
INTRMD_ST_COUNTRY_EXT VARCHAR2 (3)
Intermediate Ship To country, as sent by the customer on the N4 segment.
INTRMD_ST_COUNTY_EXT VARCHAR2 (25)
Intermediate Ship To county, as sent by the customer on the N4 segment.
INTRMD_ST_NAME_EXT VARCHAR2 (60)
Intermediate Ship To Name, as sent by the customer in the N1 and/or N2 segment.
INTRMD_ST_POSTAL_CD_EXT VARCHAR2 (15)
Intermediate Ship To address postal code, as sent by the customer on the N4 segment.
INTRMD_ST_PROVINCE_EXT VARCHAR2 (10)
Intermediate Ship To province, as sent by the customer on the N4 segment.
INTRMD_ST_STATE_EXT VARCHAR2 (10)
Intermediate Ship To state, as sent by the customer on the N4 segment.
INTRMD_ST_SITE_USE_ID NUMBER

Intermediate Ship To site use identifier, FK to RA_SITE_USES
INVENTORY_ITEM_ID NUMBER

Inventory item identifier. FK to MTL_SYSTEM_ITEMS.
INVENTORY_ITEM_SEGMENT1 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT10 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT11 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT12 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT13 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT14 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT15 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT16 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT17 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT18 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT19 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT2 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT20 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT3 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT4 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT5 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT6 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT7 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT8 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT9 VARCHAR2 (40)
Accounting Flexfield
ITEM_CONTACT_CODE_1 VARCHAR2 (3)
Contact code 1 included in customer EDI transaction
ITEM_CONTACT_CODE_2 VARCHAR2 (3)
Contact code 2 included in customer EDI transaction
ITEM_CONTACT_VALUE_1 VARCHAR2 (80)
Values associated with Contact code 1: concatenation of name, communication code, and communication number
ITEM_CONTACT_VALUE_2 VARCHAR2 (80)
Values associated with Contact code 2 : concatenation of name, communication code, and communication number
ITEM_DESCRIPTION_EXT VARCHAR2 (80)
Item description included on schedule
ITEM_DETAIL_QUANTITY NUMBER

Requested quantity. If Item_Detail_Type = 0,1,2, this is the demand quantity. If Item_Detail_Type = 3, this is the authorization quantity. If Item_Detail_Type = 4, this is the shipped, received or cum quantity. If Item_Detail_Type = 5, this is a miscellaneous quantity, such as ahead/behind, inventory balance, etc.
ITEM_DETAIL_REF_CODE_1 VARCHAR2 (3)
Reference code 1 included in customer EDI transaction
ITEM_DETAIL_REF_CODE_2 VARCHAR2 (3)
Reference code 2 included in customer EDI transaction
ITEM_DETAIL_REF_CODE_3 VARCHAR2 (3)
Reference code 3 included in customer EDI transaction
ITEM_DETAIL_REF_VALUE_1 VARCHAR2 (35)
Value associated with Reference code 1
ITEM_DETAIL_REF_VALUE_2 VARCHAR2 (35)
Value associated with Reference code 2
ITEM_DETAIL_REF_VALUE_3 VARCHAR2 (35)
Value associated with Reference code 3
ITEM_DETAIL_SUBTYPE VARCHAR2 (30)
Schedule item detail row sub-type:For form or forecast demand, Bucket type associated with the demand date/quantity; for authorizations, the type of authorization; for shipment/receipt, cumulative or last.
ITEM_DETAIL_SUBTYPE_EXT VARCHAR2 (30)
External value from which ITEM_DETAIL_SUBTYPE was derived in EDI Gateway Code Conversion.
ITEM_DETAIL_TYPE VARCHAR2 (30)
Schedule item detail row type: 0 = Past Due Firm1 = Firm Demand, 2 = Forecast Demand, 3 = Authorization, 4 = Shipment/Receipt Info, 5 = OtherValidated against FND_LOOKUPS.LOOKUP_TYPE =RLM_DETAIL_TYPE_CODE
ITEM_DETAIL_TYPE_EXT VARCHAR2 (30)
External value from which ITEM_DETAIL_TYPE was derived in EDI Gateway Code Conversion.
ITEM_ENG_CNG_LVL_EXT VARCHAR2 (35)
Customer part engineering change level included on schedule
ITEM_MEASUREMENTS_EXT VARCHAR2 (240)
Item measurement information as sent by the customer on the MEA segments.
ITEM_NOTE_TEXT VARCHAR2 (4000)
Free form item note text included in the schedule
ITEM_REF_CODE_1 VARCHAR2 (3)
Reference code 1 included in customer EDI transaction
ITEM_REF_CODE_2 VARCHAR2 (3)
Reference code 2 included in customer EDI transaction
ITEM_REF_CODE_3 VARCHAR2 (3)
Reference code 3 included in customer EDI transaction
ITEM_REF_VALUE_1 VARCHAR2 (35)
Value associated with Reference code 1
ITEM_REF_VALUE_2 VARCHAR2 (35)
Value associated with Reference code 2
ITEM_REF_VALUE_3 VARCHAR2 (35)
Value associated with Reference code 3
ITEM_RELEASE_STATUS_EXT VARCHAR2 (3)
Customer part release status included on schedule
LADING_QUANTITY_EXT NUMBER

The lading quantity as sent by the customer on the TD1 segment.
LETTER_CREDIT_EXPDT_EXT DATE

Customer letter of credit expiration date
LETTER_CREDIT_EXT VARCHAR2 (35)
Customer letter of credit with international bank guaranteeing payment for international shipments
LINE_REFERENCE VARCHAR2 (50)
Unique line identifier within an order for a transmission identifier.
LINK_TO_LINE_REF VARCHAR2 (50)
Link to Immediate Parent_line_reference within an order for a transmission identifier.
ORDER_HEADER_ID NUMBER

Order header identifier. FK to OE_ORDER_HEADERS.
ORG_ID NUMBER

Operating unit unique id. FK to HR_ORGANIZATION_UNITS.
OTHER_NAME_CODE_1 VARCHAR2 (3)
Other name code 1 included in customer EDI transaction
OTHER_NAME_CODE_2 VARCHAR2 (3)
Other name code 2 included in customer EDI transaction
OTHER_NAME_VALUE_1 VARCHAR2 (80)
Values associated with Other name code 1: concatenation of name, code, and number
OTHER_NAME_VALUE_2 VARCHAR2 (80)
Values associated with Other name code 2 : concatenation of name, code, and number
PACK_SIZE_EXT NUMBER

Size of supplier units in pack, as sent by the customer on the PO4 segment.
PACK_UNITS_PER_PACK_EXT NUMBER

Number of inner pack units per out pack unit, as sent by the customer on the PO4 segment.
PACK_UOM_CODE_EXT VARCHAR2 (3)
Unit of measure of supplier units in the pack, as sent by the customer in the PO4 segment.
PACKAGING_CODE_EXT VARCHAR2 (10)
The packaging code as sent by the customer on TD1 segment.
PARENT_LINK_LINE_REF VARCHAR2 (50)
Line reference of top model for a transmission identifier for an order
PRICE_LIST_ID NUMBER

Unique identifier for price list associated with customer item or agreement on which customer purchase order is associated. FK to RA_PRICE_LISTS
PRIMARY_QUANTITY NUMBER

Quantity in the primary UOM.
PRIMARY_UOM_CODE VARCHAR2 (3)
Primary unit of measure. FK to MTL_UNITS_OF_MEASURE
PRIME_CONTRCTR_PART_EXT VARCHAR2 (35)
The prime contractor part number, as sent by the customer on the LIN segment of the 862 segment.
PROCESS_STATUS NUMBER

Indicates The current processing status of a record (1=do not process, 2=waiting to be processed, 3=in process, 4=error, 5=processed, 6='processed with error(s)' for headers with lines in-error..)
CUST_PO_RELEASE_NUM VARCHAR2 (35)
Customer Purchase Order Release number included on schedule
CUST_PO_DATE DATE

Customer-specified effectivity date of Purchase Order number included on schedule
CUST_PO_LINE_NUM VARCHAR2 (35)
Customer Purchase Order line number included on schedule
CUST_PO_NUMBER VARCHAR2 (50)
Customer purchase order number
QTY_TYPE_CODE VARCHAR2 (30)
Actual or Cumulative. Validated against FND_LOOKUPS.LOOKUP_TYPE =RLM_QTY_TYPE_CODE
QTY_TYPE_CODE_EXT VARCHAR2 (30)
External value from which QTY_TYPE_CODE was derived in EDI Gateway Code Conversion.
RETURN_CONTAINER_EXT VARCHAR2 (35)
Returnable container specified by customer for item shipment
SCHEDULE_LINE_ID NUMBER

Schedule line unique identifier. FK to RLM_SCHEDULE_LINES, except for aggregated schedule lines.
ROUTING_DESC_EXT VARCHAR2 (35)
The routing description, as sent by the customer on the TD5 segment.
ROUTING_SEQ_CODE_EXT VARCHAR2 (3)
Code describing the relationship of a carrier to a specific shipment movement, as sent by the customer on the TD5 segment.
SCHEDULE_ITEM_NUM NUMBER

Schedule Item Number, the means to identify how item demand and information is grouped by the customer within the schedule. For sequenced schedules, it is equal to CUSTOMER_PROD_SEQ_NUM. For EDI planning and shipping schedules, it is incremented in the EDI Gateway when each 2000 record is encountered on an inbound SPSI or SSSI transaction. This number is assigned for manually entered schedules. All interface lines with the same Schedule Item number are validated together, and pass or fail validation as a group.
SHIP_DEL_PATTERN_EXT VARCHAR2 (3)
Customer ship delivery pattern code for this item; not integrated with delivery rules for date/qty calculation
SHIP_DEL_TIME_CODE_EXT VARCHAR2 (3)
Customer ship delivery time code for this item; not integrated with delivery rules for date/qty calculation
SHIP_DEL_RULE_NAME VARCHAR2 (30)
Shipment/delivery rule name for this schedule item. Initially populated only if a successful code conversion in the EDI Gateway has occurred. FK to RLM_SHIP_DELIVERY_CODES
SHIP_FROM_ADDRESS_1_EXT VARCHAR2 (35)
SHIP_FROM address line 1, as sent by the customer on the N3 segment.
SHIP_FROM_ADDRESS_2_EXT VARCHAR2 (35)
SHIP_FROM address line 2, as sent by the customer on the N3 segment.
SHIP_FROM_ADDRESS_3_EXT VARCHAR2 (35)
SHIP_FROM address line 3, as sent by the customer on the N3 segment.
SHIP_FROM_ADDRESS_4_EXT VARCHAR2 (35)
SHIP_FROM address line 4, as sent by the customer on the N3 segment.
SHIP_FROM_CITY_EXT VARCHAR2 (30)
SHIP_FROM address city, as sent by the customer on the N4 segment.
SHIP_FROM_COUNTRY_EXT VARCHAR2 (3)
SHIP_FROM country, as sent by the customer on the N4 segment.
SHIP_FROM_COUNTY_EXT VARCHAR2 (25)
SHIP_FROM county, as sent by the customer on the N4 segment.
SHIP_FROM_NAME_EXT VARCHAR2 (60)
SHIP_FROM Name, as sent by the customer in the N1 and/or N2 segment.
SHIP_FROM_ORG_ID NUMBER

Ship from organization identifier. FK to MTL_PARAMETERS and HR_ORGANIZATIONS.
SHIP_FROM_POSTAL_CD_EXT VARCHAR2 (15)
SHIP_FROM address postal code,as sent by the customer on the N4 segment.
SHIP_FROM_PROVINCE_EXT VARCHAR2 (10)
SHIP_FROM province, as sent by the customer on the N4 segment.
SHIP_FROM_STATE_EXT VARCHAR2 (10)
SHIP_FROM state, as sent by the customer on the N4 segment.
SHIP_LABEL_INFO_LINE_1 VARCHAR2 (80)
Pull signal bar-code label routing information - line 1
SHIP_LABEL_INFO_LINE_10 VARCHAR2 (80)
Pull signal bar-code label routing information - line 10
SHIP_LABEL_INFO_LINE_2 VARCHAR2 (80)
Pull signal bar-code label routing information - line 2
SHIP_LABEL_INFO_LINE_3 VARCHAR2 (80)
Pull signal bar-code label routing information - line 3
SHIP_LABEL_INFO_LINE_4 VARCHAR2 (80)
Pull signal bar-code label routing information - line 4
SHIP_LABEL_INFO_LINE_5 VARCHAR2 (80)
Pull signal bar-code label routing information - line 5
SHIP_LABEL_INFO_LINE_6 VARCHAR2 (80)
Pull signal bar-code label routing information - line 6
SHIP_LABEL_INFO_LINE_7 VARCHAR2 (80)
Pull signal bar-code label routing information - line 7
SHIP_LABEL_INFO_LINE_8 VARCHAR2 (80)
Pull signal bar-code label routing information - line 8
SHIP_LABEL_INFO_LINE_9 VARCHAR2 (80)
Pull signal bar-code label routing information - line 9
SHIP_TO_ADDRESS_1_EXT VARCHAR2 (35)
Ship to address line 1,as sent by the customer on the N3 segment.
SHIP_TO_ADDRESS_2_EXT VARCHAR2 (35)
Ship to address line 2, as sent by the customer on the N3 segment.
SHIP_TO_ADDRESS_3_EXT VARCHAR2 (35)
Ship to address line 3, as sent by the customer on the N3 segment.
SHIP_TO_ADDRESS_4_EXT VARCHAR2 (35)
Ship to address line 4, as sent by the customer on the N3 segment.
SHIP_TO_ADDRESS_ID NUMBER

Ship to address identifier. FK to RA_ADDRESSES.
DELIVER_TO_ORG_ID NUMBER

Unique identifier for ship-to organization which relates to SHIP_TO_ADDRESS_ID if there is no intermediate ship-to address, or to INTERMEDIATE_SHIP_TO_ID if intermediate ship-to address is specified. FK to HR_ORGANIZATIONS
SHIP_TO_CITY_EXT VARCHAR2 (30)
Ship to address city, as sent by the customer on the N4 segment.
SHIP_TO_COUNTRY_EXT VARCHAR2 (3)
Ship to country, as sent by the customer on the N4 segment.
SHIP_TO_COUNTY_EXT VARCHAR2 (25)
Ship to county, as sent by the customer on the N4 segment.
SHIP_TO_NAME_EXT VARCHAR2 (60)
Ship to name, as sent by the customer on the N1 or N2 segment.
SHIP_TO_POSTAL_CD_EXT VARCHAR2 (15)
Ship to address postal code, as sent by the customer on the N4 segment.
SHIP_TO_PROVINCE_EXT VARCHAR2 (10)
Ship to province, as sent by the customer on the N4 segment.
SHIP_TO_SITE_USE_ID NUMBER

Ship to site use identifier. FK to RA_SITE_USES.
SHIP_TO_STATE_EXT VARCHAR2 (10)
Ship to state, as sent by the customer on the N4 segment.
START_DATE_TIME DATE

Customer-specified date/time, as transmitted by the customer on the EDI transaction.
SUBLINE_ASSIGNED_ID_EXT VARCHAR2 (20)
Subline customer assigned identification from the SLN01. Related to but not necessarily equivalent to the baseline number, assigned identification from LIN01. For example, 1.1 or 1A might be used as a subline number to relate to baseline number 1.
SUBLINE_CONFIG_CODE_EXT VARCHAR2 (3)
The Subline Configuration Code, as sent by the customer on the SLN segment, indicating the relationship of the subline item to the baseline item.
SUBLINE_CUST_ITEM_EXT VARCHAR2 (50)
Subline customer item number, as sent by the customer on the SLN segment.
SUBLINE_CUST_ITEM_ID NUMBER

Customer Item unique identifier.
SUBLINE_MODEL_NUM_EXT VARCHAR2 (35)
Subline customer model number, as sent by the customer on the SLN segment.
SUBLINE_QUANTITY NUMBER

The subline quantity, as sent by the customer on the SLN segment.
SUBLINE_UOM_CODE VARCHAR2 (3)
The subline unit of measure (internal) cross-referenced from the UOM sent by the customer on the SLN segment. FK to MTL_UNITS_OF_MEASURE.
SUPPLIER_ITEM_EXT VARCHAR2 (35)
Supplier item number specified by customer
TRANSIT_TIME_EXT VARCHAR2 (22)
The transit time, as sent by the customer on the TD5 segment.
TRANSIT_TIME_QUAL_EXT VARCHAR2 (3)
The transit time qualifier, as sent by the customer on the TD-5 segment.
TRANSPORT_LOC_QUAL_EXT VARCHAR2 (3)
The shipping location qualifier, as sent by the customer on the TD5 segment. This identifies the type of location which specified in the corresponding shipping location.
TRANSPORT_LOCATION_EXT VARCHAR2 (35)
The specific shipping location (such as pool point or airport) corresponding to the shipping location qualifier, as sent by the customer on the TD5 segment. This corresponds to the shipping location qualifier.
TRANSPORT_METHOD_EXT VARCHAR2 (3)
The transportation method, as sent by the customer on the TD5 segment.
UOM_CODE VARCHAR2 (3)
Abbreviated unit of measure code. FK to MTL_UNITS_OF_MEASURE.
WEIGHT_EXT NUMBER

The weight, as sent by the customer on the TD1 segment.
WEIGHT_QUALIFIER_EXT VARCHAR2 (3)
The weight qualifier, as sent by the customer on the TD1 segment.
WEIGHT_UOM_EXT VARCHAR2 (3)
The unit of measure corresponding to shipment weight, as sent by the customer on the TD1 segment.
FBO_CONFIGURATION_KEY_1 VARCHAR2 (35)
For FBO Production Sequence schedules, the 1st sort key for identifying configurations indicated by the customer
FBO_CONFIGURATION_KEY_2 VARCHAR2 (35)
For FBO Production Sequence schedules, the 2nd sort key for identifying configurations indicated by the customer
FBO_CONFIGURATION_KEY_3 VARCHAR2 (35)
For FBO Production Sequence schedules, the 3rd sort key for identifying configurations indicated by the customer
FBO_CONFIGURATION_KEY_4 VARCHAR2 (35)
For FBO Production Sequence schedules, the 4th sort key for identifying configurations indicated by the customer
FBO_CONFIGURATION_KEY_5 VARCHAR2 (35)
For FBO Production Sequence schedules, the 5th sort key for identifying configurations indicated by the customer
MATCH_KEY_ACROSS VARCHAR2 (150)
Audit trail of match across key used when this schedule was processed.
MATCH_KEY_WITHIN VARCHAR2 (150)
Audit trail of match within key used when this schedule was processed.
CRITICAL_KEY_ATTRIBUTES VARCHAR2 (150)
Audit trail of critical attributes key used when this schedule was processed. An exception (warning) is generated if one of these is missing on Firm demand.
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield context column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
TP_ATTRIBUTE1 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE2 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE3 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE4 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE5 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE6 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE7 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE8 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE9 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE10 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE11 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE12 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE13 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE14 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE15 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Trading Partner Flexfield context column
LINE_NUMBER NUMBER

Unique identifier of a line within a schedule
INTMED_SHIP_TO_ORG_ID NUMBER

Unique identifier for intermediate ship-to organization which relates to INTERMEDIATE_SHIP_TO_ID if intermediate ship-to address is specified. FK to HR_ORGANIZATIONS
LINE_SOURCE VARCHAR2 (30)
Schedule Source at line level since lines can also be manually entered.
PREFERRED_GRADE VARCHAR2 (4)
Preferred Grade
CUST_PRODUCTION_SEQ_NUM_BEG VARCHAR2 (35)
For future use
CUST_PRODUCTION_SEQ_NUM_END VARCHAR2 (35)
For future use
ITEM_DETAIL_QUANTITY_MIN_EXT NUMBER

For future use
ITEM_DETAIL_QUANTITY_MAX_EXT NUMBER

For future use
ITEM_DETAIL_QUANTITY_PRIOR_EXT NUMBER

For future use
REQUIREMENT_PRIORITY_EXT NUMBER

For future use
PROJECT_NUMBER_EXT VARCHAR2 (50)
For future use
RESP_LINE_NUMBER VARCHAR2 (35)
For future use
TASK_NUMBER_EXT VARCHAR2 (50)
For future use
UPC_EXT VARCHAR2 (50)
For future use
ITEM_ENG_CNG_LVL_DATE_EXT DATE

For future use
AUTHORIZATION_CODE_EXT VARCHAR2 (50)
For future use
PACKAGING_DESC_EXT VARCHAR2 (80)
For future use
BILL_TO_ADDRESS_5_EXT VARCHAR2 (35)
For future use
BILL_TO_ADDRESS_6_EXT VARCHAR2 (35)
For future use
BILL_TO_ADDRESS_7_EXT VARCHAR2 (35)
For future use
BILL_TO_ADDRESS_8_EXT VARCHAR2 (35)
For future use
BILL_TO_ADDRESS_9_EXT VARCHAR2 (35)
For future use
ONE_TIME_BILL_TO_FLAG_EXT VARCHAR2 (35)
For future use
BILL_TO_DESCRIPTION_EXT VARCHAR2 (50)
For future use
BILL_TO_FAX_EXT VARCHAR2 (35)
For future use
BILL_TO_REGION_EXT VARCHAR2 (35)
For future use
BILL_TO_JURISDICTION_EXT VARCHAR2 (35)
For future use
BILL_TO_TEL_EXT VARCHAR2 (35)
For future use
INTRMD_ST_ADDRESS_5_EXT VARCHAR2 (35)
For future use
INTRMD_ST_ADDRESS_6_EXT VARCHAR2 (35)
For future use
INTRMD_ST_ADDRESS_7_EXT VARCHAR2 (35)
For future use
INTRMD_ST_ADDRESS_8_EXT VARCHAR2 (35)
For future use
INTRMD_ST_ADDRESS_9_EXT VARCHAR2 (35)
For future use
ONE_TIME_INTRMD_ST_FLAG_EXT VARCHAR2 (35)
For future use
INTRMD_ST_DESCRIPTION_EXT VARCHAR2 (50)
For future use
INTRMD_ST_FAX_EXT VARCHAR2 (35)
For future use
INTRMD_ST_REGION_EXT VARCHAR2 (35)
For future use
INTRMD_ST_JURISDICTION_EXT VARCHAR2 (35)
For future use
INTRMD_ST_TEL_EXT VARCHAR2 (35)
For future use
SHIP_TO_ADDRESS_5_EXT VARCHAR2 (35)
For future use
SHIP_TO_ADDRESS_6_EXT VARCHAR2 (35)
For future use
SHIP_TO_ADDRESS_7_EXT VARCHAR2 (35)
For future use
SHIP_TO_ADDRESS_8_EXT VARCHAR2 (35)
For future use
SHIP_TO_ADDRESS_9_EXT VARCHAR2 (35)
For future use
ONE_TIME_SHIP_TO_FLAG_EXT VARCHAR2 (35)
For future use
SHIP_TO_DESCRIPTION_EXT VARCHAR2 (50)
For future use
SHIP_TO_FAX_EXT VARCHAR2 (35)
For future use
SHIP_TO_REGION_EXT VARCHAR2 (35)
For future use
SHIP_TO_JURISDICTION_EXT VARCHAR2 (35)
For future use
SHIP_TO_TEL_EXT VARCHAR2 (35)
For future use
SHIP_FROM_ADDRESS_5_EXT VARCHAR2 (35)
For future use
SHIP_FROM_ADDRESS_6_EXT VARCHAR2 (35)
For future use
SHIP_FROM_ADDRESS_7_EXT VARCHAR2 (35)
For future use
SHIP_FROM_ADDRESS_8_EXT VARCHAR2 (35)
For future use
SHIP_FROM_ADDRESS_9_EXT VARCHAR2 (35)
For future use
ONE_TIME_SHIP_FROM_FLAG_EXT VARCHAR2 (35)
For future use
SHIP_FROM_DESCRIPTION_EXT VARCHAR2 (50)
For future use
SHIP_FROM_FAX_EXT VARCHAR2 (35)
For future use
SHIP_FROM_REGION_EXT VARCHAR2 (35)
For future use
SHIP_FROM_JURISDICTION_EXT VARCHAR2 (35)
For future use
SHIP_FROM_TEL_EXT VARCHAR2 (35)
For future use
FLEX_BKT_CODE VARCHAR2 (30)
Holds the value of flex bucket code that comes in on an XML SPSI schedule
FLEX_BKT_FLAG VARCHAR2 (2)
If this is set to Y, indicates that FLEXBKTID value was sent on the XML SPSI schedule.
BLANKET_NUMBER NUMBER

Blanket Sales Agreement associated with interface line
DSP_CHILD_PROCESS_INDEX NUMBER

Stores the DSP Child Process Index the Line is associated with
SHIP_TO_CUSTOMER_ID NUMBER

Related Ship To Customer ID

[top of page]

RLM.RLM_INTERFACE_LINES_ALL does not reference any database object

RLM.RLM_INTERFACE_LINES_ALL is referenced by following:

RLM
VIEW - RLM_INTERFACE_LINES_ALL#

[top of page]

Table: RLM_MESSAGE_CATEGORY

Description: Release Management Message Category, used by Exception Report
Primary Key: MESSAGE_CATEGORY_PK
  1. MESSAGE_CATEGORY_ID
Comments

This table stores the message category assigned for the exception messages. Assigning a category to the exception messages helps users to classify the exception messages when they run the Exception Report.

Columns
Name Datatype Length Mandatory Comments
MESSAGE_CATEGORY_ID NUMBER
Y Message Category Unique Identifier
MESSAGE_CATEGORY NUMBER
Y Message Category
MESSAGE_CATEGORY_DESC VARCHAR2 (240)
Message Category Description
MESSAGE_NAME VARCHAR2 (30) Y The exception code. FK to FND_NEW_MESSAGES.
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

RLM.RLM_MESSAGE_CATEGORY does not reference any database object

RLM.RLM_MESSAGE_CATEGORY is referenced by following:

RLM
VIEW - RLM_MESSAGE_CATEGORY#

[top of page]

Table: RLM_SCHEDULE_HEADERS_ALL

Description: This table stores the header level details of the Release Management schedules. It has details pertainig to the specific schedule and customer level information. Release Management demand Processor uses this table to maintain a current pict
Primary Key: SCHEDULE_HEADER_ID_PK
  1. HEADER_ID
Comments

This table stores the header level details of the Release Management schedules. It has details pertainig to the specific schedule and customer level information. Release Management demand Processor uses this table to maintain a current picture of demand schedule headers.

Indexes
Index Type Tablespace Column
RLM_SCHEDULE_HEADERS_U1 UNIQUE APPS_TS_TX_IDX HEADER_ID
RLM_SCHEDULE_HEADERS_N1 NONUNIQUE APPS_TS_TX_IDX SCHEDULE_REFERENCE_NUM
RLM_SCHEDULE_HEADERS_N2 NONUNIQUE APPS_TS_TX_IDX CUSTOMER_ID
SCHEDULE_TYPE
SCHED_HORIZON_START_DATE
RLM_SCHEDULE_HEADERS_N3 NONUNIQUE APPS_TS_TX_IDX ECE_TP_LOCATION_CODE_EXT
RLM_SCHEDULE_HEADERS_N4 NONUNIQUE APPS_TS_TX_IDX CUST_NAME_EXT
Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER
Y Schedule unique identifier
CUSTOMER_ID NUMBER
Y Ship-to Customer unique identifier. FK to RA_CUSTOMERS
SCHEDULE_TYPE VARCHAR2 (30) Y Schedule Type: Planning, Shipping or Sequenced Validated against FND_LOOKUPS.LOOKUP_TYPE = RLM_SCHEDULE_TYPE
SCHED_HORIZON_END_DATE DATE
Y Schedule horizon end date
SCHED_HORIZON_START_DATE DATE
Y Schedule horizon start date
SCHEDULE_SOURCE VARCHAR2 (30) Y EDI or manual transaction source identifier for this schedule, i.e. 830, 862, 866, DELFOR, MANUAL, etc.
SCHEDULE_PURPOSE VARCHAR2 (30) Y Schedule purpose code, i.e. Original, Replace, Cancellation, etc. Validated against FND_LOOKUPS.LOOKUP_TYPE = RLM_SCHEDULE_PURPOSE
SCHEDULE_REFERENCE_NUM VARCHAR2 (35) Y Customer assigned schedule reference or release number
CUST_ADDRESS_1_EXT VARCHAR2 (35)
Customer address line 1, as sent by the customer on the N3 segment.
CUST_ADDRESS_2_EXT VARCHAR2 (35)
Customer address line 2, as sent by the customer on the N3 segment.
CUST_ADDRESS_3_EXT VARCHAR2 (35)
Customer address line 3, as sent by the customer on the N3 segment.
CUST_ADDRESS_4_EXT VARCHAR2 (35)
Customer address line 4, as sent by the customer on the N3 segment.
CUST_CITY_EXT VARCHAR2 (30)
Customer address city, as sent by the customer on the N4 segment.
CUST_COUNTRY_EXT VARCHAR2 (3)
Customer country, as sent by the customer on the N4 segment.
CUST_COUNTY_EXT VARCHAR2 (25)
Customer county, as sent by the customer on the N4 segment.
CUSTOMER_EXT VARCHAR2 (35)
Customer external value
CUST_NAME_EXT VARCHAR2 (360)
Customer Name, as sent by the customer in the N1 and/or N2 segment.
CUST_POSTAL_CD_EXT VARCHAR2 (15)
Customer address postal code,as sent by the customer on the N4 segment.
CUST_PROVINCE_EXT VARCHAR2 (10)
Customer province, as sent by the customer on the N4 segment.
CUST_STATE_EXT VARCHAR2 (10)
Customer state, as sent by the customer on the N4 segment.
ECE_PRIMARY_ADDRESS_ID NUMBER

Customer Primary Address ID populated by EDI Gateway code conversion. FK to RA_ADDRESSES.
ECE_TP_LOCATION_CODE_EXT VARCHAR2 (35)
For EDI transactions only, external Trading Partner Location Code assigned to the transaction
ECE_TP_TRANSLATOR_CODE VARCHAR2 (35)
For EDI transactions only, EDI Gateway Trading Partner Code assigned to the transaction
EDI_CONTROL_NUM_1 VARCHAR2 (15)
EDI control number 1 (ISA) assigned by the customer EDI translator for audit.
EDI_CONTROL_NUM_2 VARCHAR2 (15)
EDI control number 2 (GS) assigned by the customer EDI translator for audit.
EDI_CONTROL_NUM_3 VARCHAR2 (15)
EDI control number 3 (ST) assigned by the customer EDI translator for audit.
EDI_TEST_INDICATOR VARCHAR2 (1)
EDI Test/Production transaction indicator (T or P), assigned by the customer EDI translator. EDI Gateway rules determine the handling of test transactions within the Demand Processor.
HEADER_CONTACT_CODE_1 VARCHAR2 (3)
Contact code 1 included in customer EDI transaction (not validated)
HEADER_CONTACT_CODE_2 VARCHAR2 (3)
Contact code 2 included in customer EDI transaction (not validated)
HEADER_CONTACT_VALUE_1 VARCHAR2 (80)
Values associated with Contact code 1: concatenation of name, communication code, and communication number
HEADER_CONTACT_VALUE_2 VARCHAR2 (80)
Values associated with Contact code 2 : concatenation of name, communication code, and communication number
HEADER_NOTE_TEXT VARCHAR2 (4000)
Free form note text included in the schedule at the header level
HEADER_REF_CODE_1 VARCHAR2 (3)
Reference code 1 included in customer EDI transaction.
HEADER_REF_CODE_2 VARCHAR2 (3)
Reference code 2 included in customer EDI transaction
HEADER_REF_CODE_3 VARCHAR2 (3)
Reference code 3 included in customer EDI transaction
HEADER_REF_VALUE_1 VARCHAR2 (35)
Value associated with Reference code 1
HEADER_REF_VALUE_2 VARCHAR2 (35)
Value associated with Reference code 2
HEADER_REF_VALUE_3 VARCHAR2 (35)
Value associated with Reference code 3
ORG_ID NUMBER

Operating unit unique ID. FK to HR_ORGANIZATION_UNITS.
SCHEDULE_TYPE_EXT VARCHAR2 (30)
External value from which RLM_SCHEDULE_TYPE was derived in EDI Gateway Code Conversion.
SCHED_GENERATION_DATE DATE

Date customer generated either the schedule or the planning information on the schedule.
SCHEDULE_PURPOSE_EXT VARCHAR2 (30)
External value from which SCHEDULE_PURPOSE was derived in EDI Gateway Code Conversion.
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield context column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
TP_ATTRIBUTE1 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE2 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE3 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE4 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE5 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE6 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE7 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE8 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE9 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE10 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE11 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE12 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE13 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE14 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE15 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Trading Partner flexfield context column
PROCESS_STATUS NUMBER

Indicates the current processing status of a record (1=do not process, 2=waiting to be processed, 3=in process, 4=error, 5=processed, 6='processed with error(s)' for headers with lines in-error.)
INTERFACE_HEADER_ID NUMBER

Foreign Key to SCHEDULE_HEADER_ID in interface table
CUST_ADDRESS_5_EXT VARCHAR2 (35)
For future use
CUST_ADDRESS_6_EXT VARCHAR2 (35)
For future use
CUST_ADDRESS_7_EXT VARCHAR2 (35)
For future use
CUST_ADDRESS_8_EXT VARCHAR2 (35)
For future use
CUST_ADDRESS_9_EXT VARCHAR2 (35)
For future use
ORIGINAL_DOCUMENT_DATE DATE

For future use
RESP_DOCUMENT_DATE DATE

For future use
DOCUMENT_DESCRIPTION VARCHAR2 (50)
For future use
DOCUMENT_REV_NUM VARCHAR2 (35)
For future use
RESP_SCHEDULE_ID VARCHAR2 (35)
For future use
RESP_DOCUMENT_REV_NUM VARCHAR2 (35)
For future use
ONE_TIME_CUST_FLAG_EXT VARCHAR2 (35)
For future use
CURRENCY_EXT VARCHAR2 (35)
For future use
TAX_EXEMPT_FLAG_EXT VARCHAR2 (35)
For future use
TAX_ID_EXT VARCHAR2 (35)
For future use
CUST_FAX_EXT VARCHAR2 (35)
For future use
CUST_REGION_EXT VARCHAR2 (35)
For future use
CUST_TAX_JURISDICTION_EXT VARCHAR2 (35)
For future use
CUST_TEL_EXT VARCHAR2 (35)
For future use
CUST_URL_EXT VARCHAR2 (100)
For future use
HEADER_CONTACT_EMAIL_1_EXT VARCHAR2 (50)
For future use
HEADER_CONTACT_EMAIL_2_EXT VARCHAR2 (50)
For future use
HEADER_CONTACT_FAX_1_EXT VARCHAR2 (35)
For future use
HEADER_CONTACT_FAX_2_EXT VARCHAR2 (35)
For future use
HEADER_CONTACT_TEL_1_EXT VARCHAR2 (50)
For future use
HEADER_CONTACT_TEL_2_EXT VARCHAR2 (50)
For future use
BUCKET_END_DATE DATE

For future use
BUCKET_START_DATE DATE

For future use
FLEX_BUCKET_CODE VARCHAR2 (30)
For future use
CUST_DESCRIPTION_EXT VARCHAR2 (35)
For future use
SUPPLIER_NAME_EXT VARCHAR2 (60)
For future use
ONE_TIME_SUPPLIER_FLAG_EXT VARCHAR2 (35)
For future use
SUPPLIER_ID NUMBER

For future use
SUPPLIER_CURRENCY_EXT VARCHAR2 (35)
For future use
SUPPLIER_DESCRIPTION_EXT VARCHAR2 (35)
For future use
SUPPLIER_TAX_EXEMPT_FLAG_EXT VARCHAR2 (35)
For future use
SUPPLIER_TAX_ID_EXT VARCHAR2 (35)
For future use
SUPPLIER_ADDRESS_1_EXT VARCHAR2 (35)
For future use
SUPPLIER_ADDRESS_2_EXT VARCHAR2 (35)
For future use
SUPPLIER_ADDRESS_3_EXT VARCHAR2 (35)
For future use
SUPPLIER_ADDRESS_4_EXT VARCHAR2 (35)
For future use
SUPPLIER_ADDRESS_5_EXT VARCHAR2 (35)
For future use
SUPPLIER_ADDRESS_6_EXT VARCHAR2 (35)
For future use
SUPPLIER_ADDRESS_7_EXT VARCHAR2 (35)
For future use
SUPPLIER_ADDRESS_8_EXT VARCHAR2 (35)
For future use
SUPPLIER_ADDRESS_9_EXT VARCHAR2 (35)
For future use
SUPPLIER_CITY_EXT VARCHAR2 (30)
For future use
SUPPLIER_COUNTY_EXT VARCHAR2 (25)
For future use
SUPPLIER_COUNTRY_EXT VARCHAR2 (3)
For future use
SUPPLIER_FAX_EXT VARCHAR2 (35)
For future use
SUPPLIER_POSTAL_CD_EXT VARCHAR2 (15)
For future use
SUPPLIER_REGION_EXT VARCHAR2 (35)
For future use
SUPPLIER_STATE_EXT VARCHAR2 (10)
For future use
SUPPLIER_PROVINCE_EXT VARCHAR2 (10)
For future use
SUPPLIER_TAX_JURISDICTION_EXT VARCHAR2 (35)
For future use
SUPPLIER_TEL_EXT VARCHAR2 (35)
For future use
SUPPLIER_URL_EXT VARCHAR2 (100)
For future use
SUP_HEADER_CONTACT_CODE_1 VARCHAR2 (3)
For future use
SUP_HEADER_CONTACT_CODE_2 VARCHAR2 (3)
For future use
SUP_HEADER_CONTACT_VALUE_1 VARCHAR2 (80)
For future use
SUP_HEADER_CONTACT_VALUE_2 VARCHAR2 (80)
For future use
SUP_HEADER_CONTACT_EMAIL_1_EXT VARCHAR2 (50)
For future use
SUP_HEADER_CONTACT_EMAIL_2_EXT VARCHAR2 (50)
For future use
SUP_HEADER_CONTACT_FAX_1_EXT VARCHAR2 (35)
For future use
SUP_HEADER_CONTACT_FAX_2_EXT VARCHAR2 (35)
For future use
SUP_HEADER_CONTACT_TEL_1_EXT VARCHAR2 (50)
For future use
SUP_HEADER_CONTACT_TEL_2_EXT VARCHAR2 (50)
For future use

[top of page]

RLM.RLM_SCHEDULE_HEADERS_ALL does not reference any database object

RLM.RLM_SCHEDULE_HEADERS_ALL is referenced by following:

RLM
VIEW - RLM_SCHEDULE_HEADERS_ALL#

[top of page]

Table: RLM_SCHEDULE_LINES_ALL

Description: This table stores the item and item detail level information associated with customer planning, shipping, or production sequenced schedules. For production sequence schedules, the item represents the feature, not the configuration.
Primary Key: SCHEDULE_LINE_ID_PK
  1. LINE_ID
Comments

This table stores the item and item detail level information associated with customer planning, shipping, or production sequenced schedules. For production sequence schedules, the item represents the feature, not the configuration.
This table stores all details for scheduled items: dated demand, authorizations, and customer shipment/receipt information. It has a child relationship to RLM_SCHEDULE_HEADERS.

Indexes
Index Type Tablespace Column
RLM_SCHEDULE_LINE_N1 NONUNIQUE APPS_TS_TX_IDX HEADER_ID
INTERFACE_LINE_ID
RLM_SCHEDULE_LINE_N2 NONUNIQUE APPS_TS_TX_IDX SHIP_FROM_ORG_ID
SHIP_TO_ORG_ID
CUSTOMER_ITEM_ID
RLM_SCHEDULE_LINE_N3 NONUNIQUE APPS_TS_TX_IDX HEADER_ID
CUSTOMER_ITEM_ID
SHIP_FROM_ORG_ID
SHIP_TO_ADDRESS_ID
RLM_SCHEDULE_LINE_U1 NONUNIQUE APPS_TS_TX_IDX LINE_ID
Columns
Name Datatype Length Mandatory Comments
LINE_ID NUMBER
Y Sequence Generated Unique Identifier for Schedule Line
CUSTOMER_ITEM_EXT VARCHAR2 (50)
Customer item number
CUSTOMER_ITEM_ID NUMBER
Y Customer item unique identifier. FK to MTL_CUSTOMER_ITEMS
DATE_TYPE_CODE VARCHAR2 (30) Y Type of start/end date, e.g. ship, deliver, Pull signal, Cumulative. Validated against FND_LOOKUPS.LOOKUP_TYPE = RLM_DATE_TYPE_CODE
INVENTORY_ITEM_ID NUMBER
Y Inventory item unique identifier. FK to MTL_SYSTEM_ITEMS
ITEM_DETAIL_SUBTYPE VARCHAR2 (30) Y Schedule item detail row sub-type:For form or forecast demand, Bucket type associated with the demand date/quantity; for authorizations, the type of authorization; for shipment/receipt, cumulative or last. Validated against FND_LOOKUPS.LOOKUP_TYPE = RLM_DETAIL_TYPE_CODE
ITEM_DETAIL_TYPE VARCHAR2 (30) Y Schedule item detail row type: 0 = Past Due Firm1 = Firm Demand, 2 = Forecast Demand, 3 = Authorization, 4 = Shipment/Receipt Info, 5 = OtherValidated against FND_LOOKUPS.LOOKUP_TYPE = RLM_DETAIL_TYPE_CODE
QTY_TYPE_CODE VARCHAR2 (30) Y Actual or Cumulative. Validated against FND_LOOKUPS.LOOKUP_TYPE = RLM_QTY_TYPE_CODE
HEADER_ID NUMBER
Y Sequence Generated Unique Identifier foreign key to the RLM_SCHEDULE_HEADERS_ALL.
INTERFACE_LINE_ID NUMBER

Interface Line unique identifier. FK to RLM_INTERFACE_LINES
START_DATE_TIME DATE
Y Customer-specified start date/time, ; applicable whenever a discrete date/quantity is indicated
UOM_CODE VARCHAR2 (3) Y Customer-specified unit of measure. FK to MTL_UNITS_OF_MEASURE
ATO_DATA_TYPE VARCHAR2 (30)
Code to describe what type of data is included for the ATO item (1=Model and Options, 2=Model, 3=Options.) Validated against FND_LOOKUPS.LOOKUP_TYPE =RLM_ITEM_METHOD_TYPE
BILL_TO_ADDRESS_1_EXT VARCHAR2 (35)
Bill To address line 1, as sent by the customer on the N3 segment.
BILL_TO_ADDRESS_2_EXT VARCHAR2 (35)
Bill To address line 2, as sent by the customer on the N3 segment.
BILL_TO_ADDRESS_3_EXT VARCHAR2 (35)
Bill To address line 3, as sent by the customer on the N3 segment.
BILL_TO_ADDRESS_4_EXT VARCHAR2 (35)
Bill To address line 4, as sent by the customer on the N3 segment.
BILL_TO_ADDRESS_ID NUMBER

Bill To address identifier. FK to RA_ADDRESSES.
INVOICE_TO_ORG_ID NUMBER

Unique identifier for invoice-to organization which relates to BILL_TO_ADDRESS_ID. FK to HR_ORGANIZATIONS
BILL_TO_CITY_EXT VARCHAR2 (30)
Bill To address city, as sent by the customer on the N4 segment.
BILL_TO_COUNTRY_EXT VARCHAR2 (3)
Bill To country, as sent by the customer on the N4 segment.
BILL_TO_COUNTY_EXT VARCHAR2 (25)
Bill To county, as sent by the customer on the N4 segment.
BILL_TO_NAME_EXT VARCHAR2 (60)
Bill To Name, as sent by the customer in the N1 and/or N2 segment.
BILL_TO_POSTAL_CD_EXT VARCHAR2 (15)
Bill To address postal code,as sent by the customer on the N4 segment.
BILL_TO_PROVINCE_EXT VARCHAR2 (10)
Bill To province, as sent by the customer on the N4 segment.
BILL_TO_SITE_USE_ID NUMBER

Bill To site use identifier. FK to RA_SITE_USES.
BILL_TO_STATE_EXT VARCHAR2 (10)
Bill To state, as sent by the customer on the N4 segment.
CARRIER_ID_CODE_EXT VARCHAR2 (35)
The carrier id, as sent by the customer on the TD5 segment.
CARRIER_QUALIFIER_EXT VARCHAR2 (3)
The carrier qualifier, as sent by the customer on the TD5 segment.
COMMODITY_EXT VARCHAR2 (35)
Customer specified commodity code
COUNTRY_OF_ORIGIN_EXT VARCHAR2 (35)
Customer-specified country of origin
CUST_ASSEMBLY_EXT VARCHAR2 (30)
The customer assembly identification, as sent on the LIN segment of the 866 txn.
CUST_ASSIGNED_ID_EXT VARCHAR2 (20)
Customer assigned identification for differentiation within a transaction set, from LIN01.
CUST_BILL_TO_EXT VARCHAR2 (35)
External Customer Bill To Cross Reference
CUST_CONTRACT_NUM_EXT VARCHAR2 (35)
The customer contract number, as sent on the LIN segment of the 830 txn.
CUSTOMER_DOCK_CODE VARCHAR2 (50)
Customer dock code.
CUST_INTRMD_SHIP_TO_EXT VARCHAR2 (35)
External Intermediate ship to Cross Reference
CUST_ITEM_PRICE_EXT NUMBER

Price included on the customer EDI transaction.
CUST_ITEM_PRICE_UOM_EXT VARCHAR2 (3)
UOM corresponding to the price included ont eh customer EDI transaction.
CUSTOMER_ITEM_REVISION VARCHAR2 (3)
Customer part revision included on schedule
CUSTOMER_JOB VARCHAR2 (50)
Customer job number
CUST_MANUFACTURER_EXT VARCHAR2 (35)
The manufacturer, as sent by the customer on the LIN segment of the 866 txn.
CUST_MODEL_NUMBER_EXT VARCHAR2 (35)
Customer Model Number for this sequenced detail
CUST_MODEL_SERIAL_NUMBER VARCHAR2 (35)
Customer Vehicle Identification Number for this sequenced detail, e.g. VIN or Chassis ID.
CUST_ORDER_NUM_EXT VARCHAR2 (35)
The order number as sent by the customer on the LIN segment of the 866 and 830 txn.
CUST_PROCESS_NUM_EXT VARCHAR2 (35)
The process number, as sent by the customer on the LIN segment of the 866 and 862 transaction.
CUST_PRODUCTION_LINE VARCHAR2 (50)
Customer production line
CUST_SET_NUM_EXT VARCHAR2 (35)
The customer set number, as sent on the LIN segment of the 862 and 866 txns.
CUST_SHIP_FROM_ORG_EXT VARCHAR2 (80)
External Inventory Organization Cross Reference
CUST_SHIP_TO_EXT VARCHAR2 (35)
External Ship to address Cross Reference
CUST_UOM_EXT VARCHAR2 (10)
External Customer unit of measure cross reference
END_DATE_TIME DATE

Customer-specified optional end date/time, applicable for flexible bucketed requirements, and cumulative information such as authorizations and shipped/received
EQUIPMENT_CODE_EXT VARCHAR2 (3)
The equipment code, as sent by the customer on the TD3 segment.
EQUIPMENT_NUMBER_EXT VARCHAR2 (35)
The equipment number, as sent by the customer on the TD3 segment.
HANDLING_CODE_EXT VARCHAR2 (3)
Special handling code as sent by the customer in the TD4 segment.
HAZARD_CODE_EXT VARCHAR2 (10)
Hazardous Material Code corresponding to the Hazardous Material Code Qualifier as sent by the customer in the TD4 segment.
HAZARD_CODE_QUAL_EXT VARCHAR2 (3)
Hazardous Material Code Qualifier as sent by the customer in the TD4 segment.
HAZARD_DESCRIPTION_EXT VARCHAR2 (80)
Hazardous Material Description as sent by the customer in the TD4 segment.
IMPORT_LICENSE_DATE_EXT DATE

Customer Import License Date (included on the shipping schedule and must be sent back on the ship notice)
IMPORT_LICENSE_EXT VARCHAR2 (35)
Customer Import License for shipment destination country (included on the shipping schedule and must be sent back on the ship notice)
INDUSTRY_ATTRIBUTE1 VARCHAR2 (150)
Record keeping or model year.
INDUSTRY_ATTRIBUTE10 VARCHAR2 (150)
Industry Attribute Descriptive flexfield
INDUSTRY_ATTRIBUTE11 VARCHAR2 (150)
Industry Attribute Descriptive flexfield
INDUSTRY_ATTRIBUTE12 VARCHAR2 (150)
Industry Attribute Descriptive flexfield
INDUSTRY_ATTRIBUTE13 VARCHAR2 (150)
Industry Attribute Descriptive flexfield
INDUSTRY_ATTRIBUTE14 VARCHAR2 (150)
Industry Attribute Descriptive flexfield
INDUSTRY_ATTRIBUTE15 VARCHAR2 (150)
Industry Attribute Descriptive flexfield
INDUSTRY_ATTRIBUTE2 VARCHAR2 (150)
Unused
INDUSTRY_ATTRIBUTE3 VARCHAR2 (150)
Customer Schedule Number. Schedule_reference_num on the RLM_SCHEDULE_HEADERS.
INDUSTRY_ATTRIBUTE4 VARCHAR2 (150)
Industry Attribute Descriptive flexfield
INDUSTRY_ATTRIBUTE5 VARCHAR2 (150)
Industry Attribute Descriptive flexfield
INDUSTRY_ATTRIBUTE6 VARCHAR2 (150)
Industry Attribute Descriptive flexfield
INDUSTRY_ATTRIBUTE7 VARCHAR2 (150)
Calculated CUM. This is updated after an order line has been shipped. It will be used on the ASN and on the packing list to indicate the CUM.
INDUSTRY_ATTRIBUTE8 VARCHAR2 (150)
UOM for Calculated CUM in INDUSTRY_ATTRIBUTE7. This is updated after an order line has been shipped. It will be used on the ASN and on the packing list.
INDUSTRY_ATTRIBUTE9 VARCHAR2 (150)
Industry Attribute Descriptive flexfield
INDUSTRY_CONTEXT VARCHAR2 (30)
Industry Attribute Descriptive flexfield context column
INTRMD_SHIP_TO_ID NUMBER

Customer Intermediate Ship-to Destination unique identifier. FK to RA_ADDRESSES
SHIP_TO_ORG_ID NUMBER

Unique identifier for ship-to organization which relates to SHIP_TO_ADDRESS_ID. FK to HR_ORGANIZATIONS
INTRMD_ST_ADDRESS_1_EXT VARCHAR2 (35)
INTERMEDIATE SHIP TO address line 1, as sent by the customer on the N3 segment.
INTRMD_ST_ADDRESS_2_EXT VARCHAR2 (35)
INTERMEDIATE SHIP TO address line 2, as sent by the customer on the N3 segment.
INTRMD_ST_ADDRESS_3_EXT VARCHAR2 (35)
INTERMEDIATE SHIP TO address line 3, as sent by the customer on the N3 segment.
INTRMD_ST_ADDRESS_4_EXT VARCHAR2 (35)
INTERMEDIATE SHIP TO address line 4, as sent by the customer on the N3 segment.
INTRMD_ST_CITY_EXT VARCHAR2 (30)
INTERMEDIATE SHIP TO address city, as sent by the customer on the N4 segment.
INTRMD_ST_COUNTRY_EXT VARCHAR2 (3)
INTERMEDIATE SHIP TO country, as sent by the customer on the N4 segment.
INTRMD_ST_COUNTY_EXT VARCHAR2 (25)
INTERMEDIATE SHIP TO county, as sent by the customer on the N4 segment.
INTRMD_ST_NAME_EXT VARCHAR2 (60)
INTERMEDIATE SHIP TO Name, as sent by the customer in the N1 and/or N2 segment.
INTRMD_ST_POSTAL_CD_EXT VARCHAR2 (15)
INTERMEDIATE SHIP TO address postal code,as sent by the customer on the N4 segment.
INTRMD_ST_PROVINCE_EXT VARCHAR2 (10)
INTERMEDIATE SHIP TO province, as sent by the customer on the N4 segment.
INTRMD_ST_STATE_EXT VARCHAR2 (10)
INTERMEDIATE SHIP TO state, as sent by the customer on the N4 segment.
INTRMD_ST_SITE_USE_ID NUMBER

Intermediate ship to site use identifier, FK to RA_SITE_USES
ITEM_CONTACT_CODE_1 VARCHAR2 (3)
Contact code 1 included in customer EDI transaction
ITEM_CONTACT_CODE_2 VARCHAR2 (3)
Contact code 2 included in customer EDI transaction
ITEM_CONTACT_VALUE_1 VARCHAR2 (80)
Values associated with Contact code 1: concatenation of name, communication code, and communication number
ITEM_CONTACT_VALUE_2 VARCHAR2 (80)
Values associated with Contact code 2 : concatenation of name, communication code, and communication number
ITEM_DESCRIPTION_EXT VARCHAR2 (80)
Item description included on schedule
ITEM_DETAIL_QUANTITY NUMBER

Requested quantity. If Item_Detail_Type = 0,1,2, this is the demand quantity. If Item_Detail_Type = 3, this is the authorization quantity. If Item_Detail_Type = 4, this is the shipped, received or cum quantity. If Item_Detail_Type = 5, this is a miscellaneous quantity, such as ahead/behind, inventory balance, etc.
ITEM_DETAIL_REF_CODE_1 VARCHAR2 (3)
Reference code 1 included in customer EDI transaction
ITEM_DETAIL_REF_CODE_2 VARCHAR2 (3)
Reference code 2 included in customer EDI transaction
ITEM_DETAIL_REF_CODE_3 VARCHAR2 (3)
Reference code 3 included in customer EDI transaction
ITEM_DETAIL_REF_VALUE_1 VARCHAR2 (35)
Value associated with Reference code 1
ITEM_DETAIL_REF_VALUE_2 VARCHAR2 (35)
Value associated with Reference code 2
ITEM_DETAIL_REF_VALUE_3 VARCHAR2 (35)
Value associated with Reference code 3
ITEM_ENG_CNG_LVL_EXT VARCHAR2 (35)
Customer part engineering change level included on schedule
ITEM_MEASUREMENTS_EXT VARCHAR2 (240)
Item measurement information as sent by the customer on the MEA segments.
ITEM_NOTE_TEXT VARCHAR2 (4000)
Free form item note text included in the schedule
ITEM_REF_CODE_1 VARCHAR2 (3)
Reference code 1 included in customer EDI transaction
ITEM_REF_CODE_2 VARCHAR2 (3)
Reference code 2 included in customer EDI transaction
ITEM_REF_CODE_3 VARCHAR2 (3)
Reference code 3 included in customer EDI transaction
ITEM_REF_VALUE_1 VARCHAR2 (35)
Value associated with Reference code 1
ITEM_REF_VALUE_2 VARCHAR2 (35)
Value associated with Reference code 2
ITEM_REF_VALUE_3 VARCHAR2 (35)
Value associated with Reference code 3
ITEM_RELEASE_STATUS_EXT VARCHAR2 (3)
Customer part release status included on schedule
LADING_QUANTITY_EXT NUMBER

The lading quantity as sent by the customer on the TD1 segment.
LETTER_CREDIT_EXPDT_EXT DATE

Customer letter of credit expiration date (included on the shipping schedule and must be sent back on the ship notice)
LETTER_CREDIT_EXT VARCHAR2 (35)
Customer letter of credit with international bank guaranteeing payment for international shipments(included on the shipping schedule and must be sent back on the ship notice)
LINE_REFERENCE VARCHAR2 (50)
Unique line identifier within an order for a transmission identifier.
LINK_TO_LINE_REF VARCHAR2 (50)
Link to Immediate Parent_line_reference within an order for a transmission identifier.
ORG_ID NUMBER

Operating unit unique ID. Validated against HR_ORGANIZATION_UNITS
OTHER_NAME_CODE_1 VARCHAR2 (3)
Other name code 1 included in customer EDI transaction
OTHER_NAME_CODE_2 VARCHAR2 (3)
Other name code 2 included in customer EDI transaction
OTHER_NAME_VALUE_1 VARCHAR2 (80)
Values associated with Other name code 1: concatenation of name, code, and number
OTHER_NAME_VALUE_2 VARCHAR2 (80)
Values associated with Other name code 2 : concatenation of name, code, and number
PACK_SIZE_EXT NUMBER

Size of supplier units in pack, as sent by the customer on the PO4 segment.
PACK_UNITS_PER_PACK_EXT NUMBER

Number of inner pack units per out pack unit, as sent by the customer on the PO4 segment.
PACK_UOM_CODE_EXT VARCHAR2 (3)
Unit of measure of supplier units in the pack, as sent by the customer in the PO4 segment.
PACKAGING_CODE_EXT VARCHAR2 (10)
The packaging code as sent by the customer on TD1 segment.
PRIMARY_QUANTITY NUMBER

Quantity in the primary UOM. FK to MTL_UNITS_OF_MEASURE
PRIMARY_UOM_CODE VARCHAR2 (3)
Primary unit of measure. FK to MTL_UNITS_OF_MEASURE
PRIME_CONTRCTR_PART_EXT VARCHAR2 (35)
The prime contractor part number, as sent by the customer on the LIN segment of the 862 segment.
PROCESS_STATUS NUMBER

Indicates the current processing status of a record (1=do not process, 2=waiting to be processed, 3=in process, 4=error, 5=processed, 6='processed with error(s)' for headers with lines in-error..)
PULLSIGNAL_END_SERIAL VARCHAR2 (35)
Pull Signal Ending Serial Number.
PULLSIGNAL_REF_NUM VARCHAR2 (35)
Pull Signal Reference Number.
PULLSIGNAL_START_SERIAL VARCHAR2 (35)
Pull Signal Starting Serial Number.
CUST_PO_RELEASE_NUM VARCHAR2 (35)
Customer Purchase Order Release number included on schedule
CUST_PO_DATE DATE

Customer-specified effectivity date of Purchase Order number included on schedule
CUST_PO_LINE_NUM VARCHAR2 (35)
Customer Purchase Order line number included on schedule
CUST_PO_NUMBER VARCHAR2 (50)
Customer Purchase Order number included on schedule, should link to a valid agreement.
RETURN_CONTAINER_EXT VARCHAR2 (35)
Returnable container specified by customer for item shipment
ROUTING_DESC_EXT VARCHAR2 (35)
The routing description, as sent by the customer on the TD5 segment.
ROUTING_SEQ_CODE_EXT VARCHAR2 (3)
Code describing the relationship of a carrier to a specific shipment movement, as sent by the customer on the TD5 segment.
SCHEDULE_ITEM_NUM NUMBER

Schedule Item Number, the means to identify how item demand and information is grouped by the customer within the schedule. For sequenced schedules, it is equal to CUSTOMER_PROD_SEQ_NUM. For EDI planning and shipping schedules, it is incremented in the EDI Gateway when each 2000 record is encountered on an inbound SPSI or SSSI transaction. This number is assigned for manually entered schedules. All interface lines with the same Schedule Item number are validated together, and pass or fail validation as a group.
SHIP_DEL_PATTERN_EXT VARCHAR2 (3)
Customer ship delivery pattern code for this item; not integrated with delivery rules for date/qty calculation
SHIP_DEL_TIME_CODE_EXT VARCHAR2 (3)
Customer ship delivery time code for this item; not integrated with delivery rules for date/qty calculation
SHIP_FROM_ADDRESS_1_EXT VARCHAR2 (35)
SHIP_FROM address line 1, as sent by the customer on the N3 segment.
SHIP_FROM_ADDRESS_2_EXT VARCHAR2 (35)
SHIP_FROM address line 2, as sent by the customer on the N3 segment.
SHIP_FROM_ADDRESS_3_EXT VARCHAR2 (35)
SHIP_FROM address line 3, as sent by the customer on the N3 segment.
SHIP_FROM_ADDRESS_4_EXT VARCHAR2 (35)
SHIP_FROM address line 4, as sent by the customer on the N3 segment.
SHIP_FROM_CITY_EXT VARCHAR2 (30)
SHIP_FROM address city, as sent by the customer on the N4 segment.
SHIP_FROM_COUNTRY_EXT VARCHAR2 (3)
SHIP_FROM country, as sent by the customer on the N4 segment.
SHIP_FROM_COUNTY_EXT VARCHAR2 (25)
SHIP_FROM county, as sent by the customer on the N4 segment.
SHIP_FROM_NAME_EXT VARCHAR2 (60)
SHIP_FROM Name, as sent by the customer in the N1 and/or N2 segment.
SHIP_FROM_ORG_ID NUMBER

Ship-from organization ID derived from the ship-from code on the schedule or the customer site default warehouse. FK to MTL_PARAMETERS and HR_ORGANIZATIONS
SHIP_FROM_POSTAL_CD_EXT VARCHAR2 (15)
SHIP_FROM address postal code, as sent by the customer on the N4 segment.
SHIP_FROM_PROVINCE_EXT VARCHAR2 (10)
SHIP_FROM province, as sent by the customer on the N4 segment.
SHIP_FROM_STATE_EXT VARCHAR2 (10)
SHIP_FROM state, as sent by the customer on the N4 segment.
SHIP_LABEL_INFO_LINE_1 VARCHAR2 (80)
Pull signal bar-code label routing information - line 1
SHIP_LABEL_INFO_LINE_10 VARCHAR2 (80)
Pull signal bar-code label routing information - line 10
SHIP_LABEL_INFO_LINE_2 VARCHAR2 (80)
Pull signal bar-code label routing information - line 2
SHIP_LABEL_INFO_LINE_3 VARCHAR2 (80)
Pull signal bar-code label routing information - line 3
SHIP_LABEL_INFO_LINE_4 VARCHAR2 (80)
Pull signal bar-code label routing information - line 4
SHIP_LABEL_INFO_LINE_5 VARCHAR2 (80)
Pull signal bar-code label routing information - line 5
SHIP_LABEL_INFO_LINE_6 VARCHAR2 (80)
Pull signal bar-code label routing information - line 6
SHIP_LABEL_INFO_LINE_7 VARCHAR2 (80)
Pull signal bar-code label routing information - line 7
SHIP_LABEL_INFO_LINE_8 VARCHAR2 (80)
Pull signal bar-code label routing information - line 8
SHIP_LABEL_INFO_LINE_9 VARCHAR2 (80)
Pull signal bar-code label routing information - line 9
SHIP_TO_ADDRESS_1_EXT VARCHAR2 (35)
Ship to address line 1,as sent by the customer on the N3 segment.
SHIP_TO_ADDRESS_2_EXT VARCHAR2 (35)
Ship to address line 2,as sent by the customer on the N3 segment.
SHIP_TO_ADDRESS_3_EXT VARCHAR2 (35)
Ship to address line 3,as sent by the customer on the N3 segment.
SHIP_TO_ADDRESS_4_EXT VARCHAR2 (35)
Ship to address line 4,as sent by the customer on the N3 segment.
SHIP_TO_ADDRESS_ID NUMBER

Ship-to Customer Final Destination unique identifier. FK to RA_ADDRESSES
DELIVER_TO_ORG_ID NUMBER

Unique identifier for deliver-to organization which relates to SHIP_TO_ADDRESS_ID. FK to HR_ORGANIZATIONS
SHIP_TO_CITY_EXT VARCHAR2 (30)
Ship to address city, as sent by the customer on the N4 segment.
SHIP_TO_COUNTRY_EXT VARCHAR2 (3)
Ship to country, as sent by the customer on the N4 segment.
SHIP_TO_COUNTY_EXT VARCHAR2 (25)
Ship to county, as sent by the customer on the N4 segment.
SHIP_TO_NAME_EXT VARCHAR2 (60)
Ship to name, as sent by the customer on the N1 or N2 segment.
SHIP_TO_POSTAL_CD_EXT VARCHAR2 (15)
Ship to address postal code, as sent by the customer on the N4 segment.
SHIP_TO_PROVINCE_EXT VARCHAR2 (10)
Ship to province, as sent by the customer on the N4 segment.
SHIP_TO_SITE_USE_ID NUMBER

Ship-to Customer Site Use unique identifier. FK to RA_SITE_USES
SHIP_TO_STATE_EXT VARCHAR2 (10)
Ship to state, as sent by the customer on the N4 segment.
SUBLINE_ASSIGNED_ID_EXT VARCHAR2 (20)
Subline customer assigned identification from the SLN01. Related to but not necessarily equivalent to the baseline number, assigned identification from LIN01. For example, 1.1 or 1A might be used as a subline number to relate to baseline number 1.
SUBLINE_CONFIG_CODE_EXT VARCHAR2 (3)
The Subline Configuration Code, as sent by the customer on the SLN segment, indicating the relationship of th esubline item to the baseline item.
SUBLINE_CUST_ITEM_EXT VARCHAR2 (50)
Subline customer item number, as sent by the customer on the SLN segment.
SUBLINE_CUST_ITEM_ID NUMBER

Customer Item unique identifier. FK to RLM_SHIP_FROM_CUST_ITEM.
SUBLINE_MODEL_NUM_EXT VARCHAR2 (35)
Subline customer model number, as sent by the customer on the SLN segment.
SUBLINE_QUANTITY NUMBER

The subline quantity, as sent by the customer on the SLN segment.
SUBLINE_UOM_CODE VARCHAR2 (3)
The subline unit of measure (internal) cross-referenced from the UOM sent by the customer on the SLN segment. FK to MTL_UNITS_OF_MEASURE.
SUPPLIER_ITEM_EXT VARCHAR2 (35)
Supplier item number specified by customer
TRANSIT_TIME_EXT VARCHAR2 (22)
The transit time, as sent by the customer on the TD5 segment.
TRANSIT_TIME_QUAL_EXT VARCHAR2 (3)
The transit time qualifier, as sent by the customer on the TD-5 segment.
CUST_PRODUCTION_SEQ_NUM VARCHAR2 (35)
Customer Production Sequence Number
TRANSPORT_LOC_QUAL_EXT VARCHAR2 (3)
The shipping location qualifier, as sent by the customer on the TD5 segment. This identifies the type of location which specified in the corresponding shipping location.
TRANSPORT_LOCATION_EXT VARCHAR2 (35)
The specific shipping location (such as pool point or airport) corresponding to the shipping location qualifier, as sent by the customer on the TD5 segment. This corresponds to the shipping location qualifier.
TRANSPORT_METHOD_EXT VARCHAR2 (3)
The transportation method, as sent by the customer on the TD5 segment.
WEIGHT_EXT NUMBER

The weight, as sent by the customer on the TD1 segment.
WEIGHT_QUALIFIER_EXT VARCHAR2 (3)
The weight qualifier, as sent by the customer on the TD1 segment.
WEIGHT_UOM_EXT VARCHAR2 (3)
The unit of measure corresponding to shipment weight, as sent by the customer on the TD1 segment.
ITEM_DETAIL_SUBTYPE_EXT VARCHAR2 (30)
External value from which ITEM_DETAIL_SUBTYPE was derived in EDI Gateway Code Conversion.
ITEM_DETAIL_TYPE_EXT VARCHAR2 (30)
External value from which ITEM_DETAIL_TYPE was derived in EDI Gateway Code Conversion.
QTY_TYPE_CODE_EXT VARCHAR2 (30)
External value from which QTY_TYPE_CODE was derived in EDI Gateway Code Conversion.
DATE_TYPE_CODE_EXT VARCHAR2 (30)
External value from which DATE_TYPE_CODE was derived in EDI Gateway Code Conversion.
FBO_CONFIGURATION_KEY_1 VARCHAR2 (35)
For FBO Production Sequence schedules, the 1st sort key for identifying configurations indicated by the customer
FBO_CONFIGURATION_KEY_2 VARCHAR2 (35)
For FBO Production Sequence schedules, the 2nd sort key for identifying configurations indicated by the customer
FBO_CONFIGURATION_KEY_3 VARCHAR2 (35)
For FBO Production Sequence schedules, the 3rd sort key for identifying configurations indicated by the customer
FBO_CONFIGURATION_KEY_4 VARCHAR2 (35)
For FBO Production Sequence schedules, the 4th sort key for identifying configurations indicated by the customer
FBO_CONFIGURATION_KEY_5 VARCHAR2 (35)
For FBO Production Sequence schedules, the 5th sort key for identifying configurations indicated by the customer
MATCH_KEY_ACROSS VARCHAR2 (150)
Audit trail of match across key used when this schedule was processed.
MATCH_KEY_WITHIN VARCHAR2 (150)
Audit trail of match within key used when this schedule was processed.
CRITICAL_KEY_ATTRIBUTES VARCHAR2 (150)
Audit trail of critical attributes key used when this schedule was processed. An exception (warning) is generated if one of these is missing on Firm demand.
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield context column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
TP_ATTRIBUTE1 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE2 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE3 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE4 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE5 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE6 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE7 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE8 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE9 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE10 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE11 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE12 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE13 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE14 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE15 VARCHAR2 (150)
Trading Partner flexfield segment column
TP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Trading Partner flexfield context column
LINE_NUMBER NUMBER

Intermediate ship to address line 1, as sent by the customer on the N3 segment.
INTMED_SHIP_TO_ORG_ID NUMBER

Unique identifier for intermediate ship-to organization which relates to INTERMEDIATE_SHIP_TO_ID if intermediate ship-to address is specified. FK to HR_ORGANIZATIONS
LINE_SOURCE VARCHAR2 (30)
Schedule source for individual line since lines can entered manually too.
ORDER_HEADER_ID NUMBER

Unique Order Header identifier indicating the Order that the schedule line is linked to. FK to OE_ORDER_HEADERS
PREFERRED_GRADE VARCHAR2 (4)
Preferred Grade
SHIP_DEL_RULE_NAME VARCHAR2 (30)
Shipment/delivery rule name for this schedule item. Initially populated only if a successful code conversion in the EDI Gateway has occurred. FK to RLM_SHIP_DELIVERY_CODES
CUST_PRODUCTION_SEQ_NUM_BEG VARCHAR2 (35)
For future use
CUST_PRODUCTION_SEQ_NUM_END VARCHAR2 (35)
For future use
ITEM_DETAIL_QUANTITY_MIN_EXT NUMBER

For future use
ITEM_DETAIL_QUANTITY_MAX_EXT NUMBER

For future use
ITEM_DETAIL_QUANTITY_PRIOR_EXT NUMBER

For future use
REQUIREMENT_PRIORITY_EXT NUMBER

For future use
PROJECT_NUMBER_EXT VARCHAR2 (50)
For future use
RESP_LINE_NUMBER VARCHAR2 (35)
For future use
TASK_NUMBER_EXT VARCHAR2 (50)
For future use
UPC_EXT VARCHAR2 (50)
For future use
ITEM_ENG_CNG_LVL_DATE_EXT DATE

For future use
AUTHORIZATION_CODE_EXT VARCHAR2 (50)
For future use
PACKAGING_DESC_EXT VARCHAR2 (80)
For future use
BILL_TO_ADDRESS_5_EXT VARCHAR2 (35)
For future use
BILL_TO_ADDRESS_6_EXT VARCHAR2 (35)
For future use
BILL_TO_ADDRESS_7_EXT VARCHAR2 (35)
For future use
BILL_TO_ADDRESS_8_EXT VARCHAR2 (35)
For future use
BILL_TO_ADDRESS_9_EXT VARCHAR2 (35)
For future use
ONE_TIME_BILL_TO_FLAG_EXT VARCHAR2 (35)
For future use
BILL_TO_DESCRIPTION_EXT VARCHAR2 (35)
For future use
BILL_TO_FAX_EXT VARCHAR2 (35)
For future use
BILL_TO_REGION_EXT VARCHAR2 (35)
For future use
BILL_TO_JURISDICTION_EXT VARCHAR2 (35)
For future use
BILL_TO_TEL_EXT VARCHAR2 (35)
For future use
INTRMD_ST_ADDRESS_5_EXT VARCHAR2 (35)
For future use
INTRMD_ST_ADDRESS_6_EXT VARCHAR2 (35)
For future use
INTRMD_ST_ADDRESS_7_EXT VARCHAR2 (35)
For future use
INTRMD_ST_ADDRESS_8_EXT VARCHAR2 (35)
For future use
INTRMD_ST_ADDRESS_9_EXT VARCHAR2 (35)
For future use
ONE_TIME_INTRMD_ST_FLAG_EXT VARCHAR2 (35)
For future use
INTRMD_ST_DESCRIPTION_EXT VARCHAR2 (50)
For future use
INTRMD_ST_FAX_EXT VARCHAR2 (35)
For future use
INTRMD_ST_REGION_EXT VARCHAR2 (35)
For future use
INTRMD_ST_JURISDICTION_EXT VARCHAR2 (35)
For future use
INTRMD_ST_TEL_EXT VARCHAR2 (35)
For future use
SHIP_TO_ADDRESS_5_EXT VARCHAR2 (35)
For future use
SHIP_TO_ADDRESS_6_EXT VARCHAR2 (35)
For future use
SHIP_TO_ADDRESS_7_EXT VARCHAR2 (35)
For future use
SHIP_TO_ADDRESS_8_EXT VARCHAR2 (35)
For future use
SHIP_TO_ADDRESS_9_EXT VARCHAR2 (35)
For future use
ONE_TIME_SHIP_TO_FLAG_EXT VARCHAR2 (35)
For future use
SHIP_TO_DESCRIPTION_EXT VARCHAR2 (50)
For future use
SHIP_TO_FAX_EXT VARCHAR2 (35)
For future use
SHIP_TO_REGION_EXT VARCHAR2 (35)
For future use
SHIP_TO_JURISDICTION_EXT VARCHAR2 (35)
For future use
SHIP_TO_TEL_EXT VARCHAR2 (35)
For future use
SHIP_FROM_ADDRESS_5_EXT VARCHAR2 (35)
For future use
SHIP_FROM_ADDRESS_6_EXT VARCHAR2 (35)
For future use
SHIP_FROM_ADDRESS_7_EXT VARCHAR2 (35)
For future use
SHIP_FROM_ADDRESS_8_EXT VARCHAR2 (35)
For future use
SHIP_FROM_ADDRESS_9_EXT VARCHAR2 (35)
For future use
ONE_TIME_SHIP_FROM_FLAG_EXT VARCHAR2 (35)
For future use
SHIP_FROM_DESCRIPTION_EXT VARCHAR2 (50)
For future use
SHIP_FROM_FAX_EXT VARCHAR2 (35)
For future use
SHIP_FROM_REGION_EXT VARCHAR2 (35)
For future use
SHIP_FROM_JURISDICTION_EXT VARCHAR2 (35)
For future use
SHIP_FROM_TEL_EXT VARCHAR2 (35)
For future use
BLANKET_NUMBER NUMBER

Blanket Sales Agreement associated with schedule line
SHIP_TO_CUSTOMER_ID NUMBER

Related Ship To Customer ID

[top of page]

RLM.RLM_SCHEDULE_LINES_ALL does not reference any database object

RLM.RLM_SCHEDULE_LINES_ALL is referenced by following:

RLM
VIEW - RLM_SCHEDULE_LINES_ALL#

[top of page]

Table: RLM_SHIP_DELIVERY_CODES

Description: Stores the shipment/delivery pattern rules
Primary Key: SHIP_DELIVERY_RULE_NAME_PK
  1. SHIP_DELIVERY_RULE_NAME
Comments

This table stores the optional Shipment/Delivery Pattern Rules which can then be associated with the customer/item/destination. They are used in the Demand Stream Processor for splitting or consolidating daily or weekly customer requirements from planning and shipping schedules into discrete shipment date/quantity groups which consistently and accurately reflect the customer?s expected shipment or delivery patterns. The Rule is in context of the customer-given date qualifier, i.e. delivery or shipment.

Columns
Name Datatype Length Mandatory Comments
SHIP_DELIVERY_RULE_NAME VARCHAR2 (30) Y Unique shipment/delivery rule name
DESCRIPTION VARCHAR2 (240)
Rule description
MONDAY_PERCENT NUMBER

If splitting weekly buckets, the percent of customer requirement quantity which is to be allocated to Monday
TUESDAY_PERCENT NUMBER

If splitting weekly buckets, the percent of customer requirement quantity which is to be allocated to Tuesday
WEDNESDAY_PERCENT NUMBER

If splitting weekly buckets, the percent of customer requirement quantity which is to be allocated to Wednesday
THURSDAY_PERCENT NUMBER

If splitting weekly buckets, the percent of customer requirement quantity which is to be allocated to Thursday
FRIDAY_PERCENT NUMBER

If splitting weekly buckets, the percent of customer requirement quantity which is to be allocated to Friday
SATURDAY_PERCENT NUMBER

If splitting weekly buckets, the percent of customer requirement quantity which is to be allocated to Saturday
SUNDAY_PERCENT NUMBER

If splitting weekly buckets, the percent of customer requirement quantity which is to be allocated to Sunday
USER_MAINTAINABLE_FLAG VARCHAR2 (1)
Y or N flag that indicates whether this seeded row can be updated by the users
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield context column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
TP_ATTRIBUTE1 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE2 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE3 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE4 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE5 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE6 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE7 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE8 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE9 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE10 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE11 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE12 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE13 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE14 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE15 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Trading Partner Flexfield segment column

[top of page]

RLM.RLM_SHIP_DELIVERY_CODES does not reference any database object

RLM.RLM_SHIP_DELIVERY_CODES is referenced by following:

RLM
VIEW - RLM_SHIP_DELIVERY_CODES#

[top of page]

Table: RLM_UI_QUERIES

Description: Stores the Queries used in Release Workbench
Primary Key: RLM_UI_QUERIES_U1
  1. QUERY_ID
Comments

This table stores the Names of all the Queries which are used in Release Workbench. It stores information about the Query such as the Owner of the Query, whether Query can be deleted or not.

Columns
Name Datatype Length Mandatory Comments
QUERY_ID NUMBER
Y Unique ID assigned to each Query.
QUERY_NAME VARCHAR2 (240) Y Name Assigned by User to the Query
USER_ID NUMBER

User id of the Application User who created the Query
DELETE_FLAG VARCHAR2 (1)
Flag which tells whether Query can be deleted or not
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER
Y Standard Who column

[top of page]

RLM.RLM_UI_QUERIES does not reference any database object

RLM.RLM_UI_QUERIES is referenced by following:

RLM
VIEW - RLM_UI_QUERIES#

[top of page]

Table: RLM_UI_QUERY_COLUMNS

Description: This table stores the details of Query Criteria for each of the Query in RLM_UI_QUERIES
Primary Key: RLM_UI_QUERY_COLUMNS_U1
  1. QUERY_ID
  2. COLUMN_NAME
Comments

This table stores the details of Query Criteria for each of the Query in RLM_UI_QUERIES. For each of the field in the Release Workbench Find Window, this table stores a record which has foreign key relationship with RLM_UI_QUERIES.

Indexes
Index Type Tablespace Column
RLM_UI_QUERY_COLUMNS_N1 NONUNIQUE APPS_TS_TX_IDX QUERY_ID
Columns
Name Datatype Length Mandatory Comments
QUERY_ID NUMBER
Y ID for the Query for which Criteria is being stored
COLUMN_NAME VARCHAR2 (240) Y Name of the field on Find Window whose criteria is being stored
COLUMN_TYPE VARCHAR2 (200)
Data Type of the Field on Find Window whose criteria is being stored
COLUMN_VALUE VARCHAR2 (2000)
Query Criteria for the Field (used on Find Window of Release Workbench)
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER
Y Standard Who column

[top of page]

RLM.RLM_UI_QUERY_COLUMNS does not reference any database object

RLM.RLM_UI_QUERY_COLUMNS is referenced by following:

RLM
VIEW - RLM_UI_QUERY_COLUMNS#

[top of page]

View: RLM_CUM_ADJ_DETAILS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
CUM_KEY_ID NUMBER
Y
TXN_DATE DATE
Y
TXN_QUANTITY NUMBER

QUANTITY_UOM VARCHAR2 (3)
SHIPMENT_NUMBER NUMBER

LAST_ADJUSTED_BY VARCHAR2 (100) Y
ADJUSTMENT_REASON VARCHAR2 (30)
ADJUSTMENT_REFERENCE VARCHAR2 (240)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER
Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER
Y
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 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)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
TP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
TP_ATTRIBUTE1 VARCHAR2 (150)
TP_ATTRIBUTE2 VARCHAR2 (150)
TP_ATTRIBUTE3 VARCHAR2 (150)
TP_ATTRIBUTE4 VARCHAR2 (150)
TP_ATTRIBUTE5 VARCHAR2 (150)
TP_ATTRIBUTE6 VARCHAR2 (150)
TP_ATTRIBUTE7 VARCHAR2 (150)
TP_ATTRIBUTE8 VARCHAR2 (150)
TP_ATTRIBUTE9 VARCHAR2 (150)
TP_ATTRIBUTE10 VARCHAR2 (150)
TP_ATTRIBUTE11 VARCHAR2 (150)
TP_ATTRIBUTE12 VARCHAR2 (150)
TP_ATTRIBUTE13 VARCHAR2 (150)
TP_ATTRIBUTE14 VARCHAR2 (150)
TP_ATTRIBUTE15 VARCHAR2 (150)
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

ORG_ID NUMBER

Operating Unit ID

[top of page]

APPS.RLM_CUM_ADJ_DETAILS_V references the following:

APPS
SYNONYM - FND_USER
SYNONYM - RLM_CUST_ITEM_CUM_ADJ_ALL
SYNONYM - RLM_CUST_ITEM_CUM_KEYS

APPS.RLM_CUM_ADJ_DETAILS_V is not referenced by any database object

[top of page]

View: RLM_CUM_SHIPFR_CUST_ITEMS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
CUSTOMER_ITEM_ID NUMBER
Y
CUSTOMER_ID NUMBER
Y
CUSTOMER_ITEM_NUMBER VARCHAR2 (50) Y
CUSTOMER_ITEM_DESC VARCHAR2 (240)
ADDRESS_ID NUMBER

ITEM_DEFINITION_LEVEL VARCHAR2 (1) Y
CUSTOMER_CATEGORY_CODE VARCHAR2 (30)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER
Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER
Y
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

[top of page]

APPS.RLM_CUM_SHIPFR_CUST_ITEMS_V references the following:

APPS
SYNONYM - MTL_CUSTOMER_ITEMS
SYNONYM - RLM_CUST_ITEM_CUM_KEYS

APPS.RLM_CUM_SHIPFR_CUST_ITEMS_V is not referenced by any database object

[top of page]

View: RLM_CUM_SHIPFR_SHIPTO_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ADDRESS_ID NUMBER (15) Y
LOCATION VARCHAR2 (40) Y
CUSTOMER_ID NUMBER

SHIP_TO_CUSTOMER_ID NUMBER (15) Y
CUSTOMER_NAME VARCHAR2 (360) Y
CUSTOMER_NUMBER VARCHAR2 (30) Y
ECE_TP_LOCATION_CODE VARCHAR2 (40)
CUSTOMER_CATEGORY_CODE VARCHAR2 (30)
ORGANIZATION_CODE VARCHAR2 (3)
SITE_USE_ID NUMBER (15) Y
SITE_USE_CODE VARCHAR2 (30) Y
SHIP_FROM_ORG_ID NUMBER
Y
CUM_CONTROL_CODE VARCHAR2 (30) Y
CUM_CONTROL_CODE_MN VARCHAR2 (30) Y
CUM_ORG_LEVEL_CODE VARCHAR2 (30)
CUM_ORG_LEVEL_CODE_MN VARCHAR2 (30)
CUM_CURRENT_START_DATE DATE

CUM_CURRENT_RECORD_YEAR VARCHAR2 (35)
CUM_SHIPMENT_RULE_CODE VARCHAR2 (30)
CUM_SHIPMENT_RULE_CODE_MN VARCHAR2 (30)
CUM_YESTERD_TIME_CUTOFF NUMBER

LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER
Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER
Y
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 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)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
TP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
TP_ATTRIBUTE1 VARCHAR2 (150)
TP_ATTRIBUTE2 VARCHAR2 (150)
TP_ATTRIBUTE3 VARCHAR2 (150)
TP_ATTRIBUTE4 VARCHAR2 (150)
TP_ATTRIBUTE5 VARCHAR2 (150)
TP_ATTRIBUTE6 VARCHAR2 (150)
TP_ATTRIBUTE7 VARCHAR2 (150)
TP_ATTRIBUTE8 VARCHAR2 (150)
TP_ATTRIBUTE9 VARCHAR2 (150)
TP_ATTRIBUTE10 VARCHAR2 (150)
TP_ATTRIBUTE11 VARCHAR2 (150)
TP_ATTRIBUTE12 VARCHAR2 (150)
TP_ATTRIBUTE13 VARCHAR2 (150)
TP_ATTRIBUTE14 VARCHAR2 (150)
TP_ATTRIBUTE15 VARCHAR2 (150)
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

ORG_ID NUMBER

Operating Unit ID

[top of page]

APPS.RLM_CUM_SHIPFR_SHIPTO_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCT_RELATE_ALL
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - HZ_PARTIES
VIEW - ORG_ORGANIZATION_DEFINITIONS
SYNONYM - RLM_CUST_SHIPTO_TERMS
SYNONYM - RLM_CUST_SHIPTO_TERMS_ALL
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.RLM_CUM_SHIPFR_SHIPTO_V is not referenced by any database object

[top of page]

View: RLM_CUM_SHIP_DETAILS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
CUM_KEY_ID NUMBER

SHIP_FROM_ORG_ID NUMBER

SHIP_TO_ORG_ID NUMBER

INVOICE_TO_ORG_ID NUMBER

INTMED_SHIP_TO_ORG_ID NUMBER

CUM_QUANTITY VARCHAR2 (240)
TXN_DATE DATE

TXN_QUANTITY NUMBER

QUANTITY_UOM VARCHAR2 (3)
SHIPMENT_NUMBER NUMBER
Y
LINE_ID NUMBER
Y
LAST_SHIPPED_BY VARCHAR2 (100) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER
Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER
Y
ATTRIBUTE_CATEGORY VARCHAR2 (0)
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)
TP_ATTRIBUTE_CATEGORY VARCHAR2 (0)
TP_ATTRIBUTE1 VARCHAR2 (0)
TP_ATTRIBUTE2 VARCHAR2 (0)
TP_ATTRIBUTE3 VARCHAR2 (0)
TP_ATTRIBUTE4 VARCHAR2 (0)
TP_ATTRIBUTE5 VARCHAR2 (0)
TP_ATTRIBUTE6 VARCHAR2 (0)
TP_ATTRIBUTE7 VARCHAR2 (0)
TP_ATTRIBUTE8 VARCHAR2 (0)
TP_ATTRIBUTE9 VARCHAR2 (0)
TP_ATTRIBUTE10 VARCHAR2 (0)
TP_ATTRIBUTE11 VARCHAR2 (0)
TP_ATTRIBUTE12 VARCHAR2 (0)
TP_ATTRIBUTE13 VARCHAR2 (0)
TP_ATTRIBUTE14 VARCHAR2 (0)
TP_ATTRIBUTE15 VARCHAR2 (0)
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

INVENTORY_ITEM_ID NUMBER
Y Stores the inventory_item_id of an item.
ORG_ID NUMBER

Operating Unit ID

[top of page]

APPS.RLM_CUM_SHIP_DETAILS_V references the following:

APPS
SYNONYM - FND_USER
SYNONYM - OE_ORDER_LINES_ALL
SYNONYM - RLM_CUST_ITEM_CUM_KEYS

APPS.RLM_CUM_SHIP_DETAILS_V is not referenced by any database object

[top of page]

View: RLM_CUM_SITE_USES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
SITE_USE_ID NUMBER (15) Y
CUSTOMER_ID NUMBER (15) Y
ADDRESS_ID NUMBER (15) Y
LOCATION VARCHAR2 (40) Y
CITY VARCHAR2 (60)
STATE VARCHAR2 (60)
SITE_USE_CODE VARCHAR2 (30) Y
SITE_USE_MEANING VARCHAR2 (80) Y
CUM_ORG_LEVEL_CODE VARCHAR2 (30)
ORG_ID NUMBER

Operating Unit ID

[top of page]

APPS.RLM_CUM_SITE_USES_V references the following:

APPS
VIEW - AR_LOOKUPS
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTY_SITES
SYNONYM - RLM_CUST_SHIPTO_TERMS

APPS.RLM_CUM_SITE_USES_V is not referenced by any database object

[top of page]

View: RLM_CUSTOMERS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
CUSTOMER_ID NUMBER

SHIP_FROM_ORG_ID NUMBER
Y
CUSTOMER_NAME VARCHAR2 (360) Y
CUSTOMER_NUMBER VARCHAR2 (30) Y
ORGANIZATION_CODE VARCHAR2 (3)
ORGANIZATION_NAME VARCHAR2 (240) Y
ORG_ID NUMBER

Operating Unit ID

[top of page]

APPS.RLM_CUSTOMERS_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
VIEW - ORG_ORGANIZATION_DEFINITIONS
SYNONYM - RLM_CUST_SHIPTO_TERMS

APPS.RLM_CUSTOMERS_V is not referenced by any database object

[top of page]

View: RLM_CUSTOMER_TERMS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_NAME VARCHAR2 (240) Y
ORGANIZATION_CODE VARCHAR2 (3)
CUSTOMER_NAME VARCHAR2 (360) Y
CUSTOMER_NUMBER VARCHAR2 (30) Y
CUST_SHIPTO_TERMS_ID NUMBER
Y
ADDRESS_ID NUMBER

CUSTOMER_ID NUMBER

SHIP_FROM_ORG_ID NUMBER
Y
CUM_CONTROL_CODE VARCHAR2 (30) Y
SHIP_METHOD VARCHAR2 (30)
INTRANSIT_TIME NUMBER

TIME_UOM_CODE VARCHAR2 (3)
SHIP_DELIVERY_RULE_NAME VARCHAR2 (30) Y
CUM_CURRENT_RECORD_YEAR VARCHAR2 (35)
CUM_PREVIOUS_RECORD_YEAR VARCHAR2 (240)
CUM_CURRENT_START_DATE DATE

CUM_PREVIOUS_START_DATE DATE

CUM_ORG_LEVEL_CODE VARCHAR2 (30)
CUM_SHIPMENT_RULE_CODE VARCHAR2 (30)
CUM_YESTERD_TIME_CUTOFF NUMBER

CUST_ASSIGN_SUPPLIER_CD VARCHAR2 (35)
CUSTOMER_RCV_CALENDAR_CD VARCHAR2 (10)
FREIGHT_CODE VARCHAR2 (25)
SUPPLIER_SHP_CALENDAR_CD VARCHAR2 (10)
UNSHIP_FIRM_CUTOFF_DAYS NUMBER

UNSHIPPED_FIRM_DISP_CD VARCHAR2 (30)
USE_EDI_SDP_CODE_FLAG VARCHAR2 (1) Y
DEMAND_TOLERANCE_ABOVE NUMBER

DEMAND_TOLERANCE_BELOW NUMBER

INACTIVE_DATE DATE

MATCH_ACROSS_KEY VARCHAR2 (240)
MATCH_WITHIN_KEY VARCHAR2 (240)
HEADER_ID NUMBER

PRICE_LIST_ID NUMBER

CRITICAL_ATTRIBUTE_KEY VARCHAR2 (80)
CUSTOMER_CONTACT_ID NUMBER

PLN_FIRM_DAY_FROM NUMBER

PLN_FIRM_DAY_TO NUMBER

PLN_FORECAST_DAY_FROM NUMBER

PLN_FORECAST_DAY_TO NUMBER

PLN_FROZEN_DAY_TO NUMBER

PLN_FROZEN_DAY_FROM NUMBER

SEQ_FIRM_DAY_FROM NUMBER

SEQ_FIRM_DAY_TO NUMBER

SEQ_FORECAST_DAY_TO NUMBER

SEQ_FORECAST_DAY_FROM NUMBER

SEQ_FROZEN_DAY_FROM NUMBER

SEQ_FROZEN_DAY_TO NUMBER

SHP_FIRM_DAY_FROM NUMBER

SHP_FIRM_DAY_TO NUMBER

SHP_FROZEN_DAY_TO NUMBER

SHP_FROZEN_DAY_FROM NUMBER

SHP_FORECAST_DAY_TO NUMBER

ROUND_TO_STD_PACK_FLAG VARCHAR2 (1)
SUPPLIER_CONTACT_ID NUMBER

AGREEMENT_ID NUMBER

AGREEMENT_NAME VARCHAR2 (240)
STD_PACK_QTY NUMBER

FUTURE_AGREEMENT_ID NUMBER

FUTURE_AGREEMENT_NAME VARCHAR2 (240)
SHP_FORECAST_DAY_FROM NUMBER

SCHEDULE_HIERARCHY_CODE VARCHAR2 (240)
COMMENTS VARCHAR2 (240)
LAST_UPDATED_BY NUMBER
Y
LAST_UPDATE_DATE DATE
Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER
Y
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 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)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

TP_ATTRIBUTE1 VARCHAR2 (150)
TP_ATTRIBUTE2 VARCHAR2 (150)
TP_ATTRIBUTE3 VARCHAR2 (150)
TP_ATTRIBUTE4 VARCHAR2 (150)
TP_ATTRIBUTE5 VARCHAR2 (150)
TP_ATTRIBUTE6 VARCHAR2 (150)
TP_ATTRIBUTE7 VARCHAR2 (150)
TP_ATTRIBUTE8 VARCHAR2 (150)
TP_ATTRIBUTE9 VARCHAR2 (150)
TP_ATTRIBUTE10 VARCHAR2 (150)
TP_ATTRIBUTE11 VARCHAR2 (150)
TP_ATTRIBUTE12 VARCHAR2 (150)
TP_ATTRIBUTE13 VARCHAR2 (150)
TP_ATTRIBUTE14 VARCHAR2 (150)
TP_ATTRIBUTE15 VARCHAR2 (150)
TP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
PLN_MRP_FORECAST_DAY_FROM NUMBER

PLN_MRP_FORECAST_DAY_TO NUMBER

SHP_MRP_FORECAST_DAY_FROM NUMBER

SHP_MRP_FORECAST_DAY_TO NUMBER

SEQ_MRP_FORECAST_DAY_FROM NUMBER

SEQ_MRP_FORECAST_DAY_TO NUMBER

INTRANSIT_CALC_BASIS VARCHAR2 (15)
DEFAULT_SHIP_FROM VARCHAR2 (1)
Used to designate default processing rule when multiple Ship-From organizations exist at customer level
PLN_FROZEN_FLAG VARCHAR2 (1)
SHP_FROZEN_FLAG VARCHAR2 (1)
SEQ_FROZEN_FLAG VARCHAR2 (1)
ISSUE_WARNING_DROP_PARTS_FLAG VARCHAR2 (1)
ORG_ID NUMBER

Operating Unit ID
BLANKET_NUMBER NUMBER

Blanket Sales Agreement
RELEASE_RULE VARCHAR2 (2)
Release Rule
RELEASE_TIME_FRAME NUMBER

Release Time Frame
RELEASE_TIME_FRAME_UOM VARCHAR2 (3)
Release Time Frame UOM
EXCLUDE_NON_WORKDAYS_FLAG VARCHAR2 (1)
DISABLE_CREATE_CUM_KEY_FLAG VARCHAR2 (1)

[top of page]

APPS.RLM_CUSTOMER_TERMS_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
VIEW - ORG_ORGANIZATION_DEFINITIONS
SYNONYM - RLM_CUST_SHIPTO_TERMS

APPS.RLM_CUSTOMER_TERMS_V is not referenced by any database object

[top of page]

View: RLM_CUST_INV_ITEM_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ITEM_NUMBER VARCHAR2 (50)
ITEM_ID NUMBER

DESCRIPTION VARCHAR2 (240)
CUSTOMER_ID NUMBER

ORGANIZATION_ID NUMBER

INT_EXT_CODE CHAR (8)

[top of page]

APPS.RLM_CUST_INV_ITEM_V references the following:

APPS
SYNONYM - MTL_CUSTOMER_ITEMS
VIEW - MTL_ITEM_FLEXFIELDS

APPS.RLM_CUST_INV_ITEM_V is not referenced by any database object

[top of page]

View: RLM_CUST_ITEM_CUM_ADJ_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
CUM_ADJ_ID NUMBER
Y
CUM_KEY_ID NUMBER
Y
TRANSACTION_DATE_TIME DATE
Y
TRANSACTION_QTY NUMBER

ADJUSTMENT_REFERENCE VARCHAR2 (240)
ADJUSTMENT_REASON VARCHAR2 (30)
CUST_UOM_CODE VARCHAR2 (3)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER
Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER
Y
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 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)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

ORG_ID NUMBER

Operating Unit ID

[top of page]

APPS.RLM_CUST_ITEM_CUM_ADJ_V references the following:

APPS
SYNONYM - RLM_CUST_ITEM_CUM_ADJ_ALL
SYNONYM - RLM_CUST_ITEM_CUM_KEYS

APPS.RLM_CUST_ITEM_CUM_ADJ_V is not referenced by any database object

[top of page]

View: RLM_CUST_ITEM_CUM_DETAILS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
TXN_TYPE VARCHAR2 (10)
CUM_KEY_ID NUMBER

SHIP_FROM VARCHAR2 (3)
SHIP_TO VARCHAR2 (40)
DELIVER_TO VARCHAR2 (40)
BILL_TO VARCHAR2 (40)
TXN_DATE DATE

TXN_QUANTITY NUMBER

QUANTITY_UOM VARCHAR2 (3)
SHIPMENT_NUMBER NUMBER

LAST_ADJUSTED_BY VARCHAR2 (100)
LAST_SHIPPED_BY VARCHAR2 (100)
ADJUSTMENT_REASON VARCHAR2 (30)
ADJUSTMENT_REFERENCE VARCHAR2 (240)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

ATTRIBUTE_CATEGORY 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)
TP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
TP_ATTRIBUTE1 VARCHAR2 (150)
TP_ATTRIBUTE2 VARCHAR2 (150)
TP_ATTRIBUTE3 VARCHAR2 (150)
TP_ATTRIBUTE4 VARCHAR2 (150)
TP_ATTRIBUTE5 VARCHAR2 (150)
TP_ATTRIBUTE6 VARCHAR2 (150)
TP_ATTRIBUTE7 VARCHAR2 (150)
TP_ATTRIBUTE8 VARCHAR2 (150)
TP_ATTRIBUTE9 VARCHAR2 (150)
TP_ATTRIBUTE10 VARCHAR2 (150)
TP_ATTRIBUTE11 VARCHAR2 (150)
TP_ATTRIBUTE12 VARCHAR2 (150)
TP_ATTRIBUTE13 VARCHAR2 (150)
TP_ATTRIBUTE14 VARCHAR2 (150)
TP_ATTRIBUTE15 VARCHAR2 (150)
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

ORG_ID NUMBER

Operating Unit ID

[top of page]

APPS.RLM_CUST_ITEM_CUM_DETAILS_V references the following:

APPS
SYNONYM - FND_USER
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - OE_ORDER_LINES_ALL
VIEW - ORG_ORGANIZATION_DEFINITIONS
SYNONYM - RLM_CUST_ITEM_CUM_ADJ_ALL
SYNONYM - RLM_CUST_ITEM_CUM_KEYS

APPS.RLM_CUST_ITEM_CUM_DETAILS_V is not referenced by any database object

[top of page]

View: RLM_CUST_ITEM_CUM_KEYS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
CUM_KEY_ID NUMBER
Y
CUSTOMER_ITEM_ID NUMBER
Y
SHIP_FROM_ORG_ID NUMBER

CUM_START_DATE DATE

CUST_RECORD_YEAR VARCHAR2 (35)
CUST_UOM_CODE VARCHAR2 (3)
CUM_QTY NUMBER

CUM_QTY_TO_BE_ACCUMULATED NUMBER

CUM_QTY_AFTER_CUTOFF NUMBER

LAST_CUM_QTY_UPDATE_DATE DATE

PURCHASE_ORDER_NUMBER VARCHAR2 (50)
SHIP_TO_ADDRESS_ID NUMBER

BILL_TO_ADDRESS_ID NUMBER

INTRMD_SHIP_TO_ID NUMBER

LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER
Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER
Y
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 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)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
TP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
TP_ATTRIBUTE1 VARCHAR2 (150)
TP_ATTRIBUTE2 VARCHAR2 (150)
TP_ATTRIBUTE3 VARCHAR2 (150)
TP_ATTRIBUTE4 VARCHAR2 (150)
TP_ATTRIBUTE5 VARCHAR2 (150)
TP_ATTRIBUTE6 VARCHAR2 (150)
TP_ATTRIBUTE7 VARCHAR2 (150)
TP_ATTRIBUTE8 VARCHAR2 (150)
TP_ATTRIBUTE9 VARCHAR2 (150)
TP_ATTRIBUTE10 VARCHAR2 (150)
TP_ATTRIBUTE11 VARCHAR2 (150)
TP_ATTRIBUTE12 VARCHAR2 (150)
TP_ATTRIBUTE13 VARCHAR2 (150)
TP_ATTRIBUTE14 VARCHAR2 (150)
TP_ATTRIBUTE15 VARCHAR2 (150)
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

INACTIVE_FLAG VARCHAR2 (1)
CUM_NOTE_TEXT VARCHAR2 (4000)
ORG_ID NUMBER

Operating Unit ID

[top of page]

APPS.RLM_CUST_ITEM_CUM_KEYS_V references the following:

APPS
SYNONYM - RLM_CUST_ITEM_CUM_KEYS

APPS.RLM_CUST_ITEM_CUM_KEYS_V is not referenced by any database object

[top of page]

View: RLM_CUST_ITEM_TERMS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
CUSTOMER_NAME VARCHAR2 (360) Y
CUSTOMER_NUMBER VARCHAR2 (30) Y
CUSTOMER_ITEM_NUMBER VARCHAR2 (50) Y
CUSTOMER_ITEM_DESC VARCHAR2 (240)
COMMODITY_CODE VARCHAR2 (30) Y
CUST_ITEM_TERMS_ID NUMBER
Y
CUSTOMER_ITEM_ID NUMBER
Y
SHIP_FROM_ORG_ID NUMBER
Y
ADDRESS_ID NUMBER

HEADER_ID NUMBER

AGREEMENT_ID NUMBER

AGREEMENT_NAME VARCHAR2 (240)
FUTURE_AGREEMENT_ID NUMBER

FUTURE_AGREEMENT_NAME VARCHAR2 (240)
CALC_CUM_FLAG VARCHAR2 (1)
CUM_CURRENT_START_DATE DATE

CUM_PREVIOUS_START_DATE DATE

CUST_ITEM_STATUS_CODE VARCHAR2 (25)
ROUND_TO_STD_PACK_FLAG VARCHAR2 (1)
SHIP_DELIVERY_RULE_NAME VARCHAR2 (30)
SHIP_METHOD VARCHAR2 (30)
INTRANSIT_TIME NUMBER

TIME_UOM_CODE VARCHAR2 (3)
STD_PACK_QTY NUMBER

PRICE_LIST_ID NUMBER

DEMAND_TOLERANCE_ABOVE NUMBER

USE_EDI_SDP_CODE_FLAG VARCHAR2 (1) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER
Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER
Y
PLN_FIRM_DAY_TO NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (30)
PLN_FORECAST_DAY_FROM NUMBER

PLN_FORECAST_DAY_TO NUMBER

PLN_FROZEN_DAY_TO NUMBER

PLN_FROZEN_DAY_FROM NUMBER

ATTRIBUTE1 VARCHAR2 (150)
SEQ_FIRM_DAY_FROM NUMBER

SEQ_FIRM_DAY_TO NUMBER

ATTRIBUTE2 VARCHAR2 (150)
SEQ_FORECAST_DAY_TO NUMBER

SEQ_FORECAST_DAY_FROM NUMBER

ATTRIBUTE3 VARCHAR2 (150)
SEQ_FROZEN_DAY_FROM NUMBER

SEQ_FROZEN_DAY_TO NUMBER

ATTRIBUTE4 VARCHAR2 (150)
SHP_FIRM_DAY_FROM NUMBER

SHP_FIRM_DAY_TO NUMBER

ATTRIBUTE5 VARCHAR2 (150)
SHP_FROZEN_DAY_TO NUMBER

SHP_FROZEN_DAY_FROM NUMBER

ATTRIBUTE6 VARCHAR2 (150)
SHP_FORECAST_DAY_TO NUMBER

SHP_FORECAST_DAY_FROM NUMBER

ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

DEMAND_TOLERANCE_BELOW NUMBER

CUSTOMER_CONTACT_ID NUMBER

CUSTOMER_ID NUMBER
Y
FREIGHT_CODE VARCHAR2 (25)
PLN_FIRM_DAY_FROM NUMBER

SUPPLIER_CONTACT_ID NUMBER

INACTIVE_DATE DATE

COMMENTS VARCHAR2 (240)
DEFAULT_SHIP_FROM VARCHAR2 (1)
Used to designate a default processing rule when multiple Ship-From organizations exist at item level
TP_ATTRIBUTE1 VARCHAR2 (150)
TP_ATTRIBUTE2 VARCHAR2 (150)
TP_ATTRIBUTE3 VARCHAR2 (150)
TP_ATTRIBUTE4 VARCHAR2 (150)
TP_ATTRIBUTE5 VARCHAR2 (150)
TP_ATTRIBUTE6 VARCHAR2 (150)
TP_ATTRIBUTE7 VARCHAR2 (150)
TP_ATTRIBUTE8 VARCHAR2 (150)
TP_ATTRIBUTE9 VARCHAR2 (150)
TP_ATTRIBUTE10 VARCHAR2 (150)
TP_ATTRIBUTE11 VARCHAR2 (150)
TP_ATTRIBUTE12 VARCHAR2 (150)
TP_ATTRIBUTE13 VARCHAR2 (150)
TP_ATTRIBUTE14 VARCHAR2 (150)
TP_ATTRIBUTE15 VARCHAR2 (150)
TP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
PLN_MRP_FORECAST_DAY_FROM NUMBER

PLN_MRP_FORECAST_DAY_TO NUMBER

SHP_MRP_FORECAST_DAY_FROM NUMBER

SHP_MRP_FORECAST_DAY_TO NUMBER

SEQ_MRP_FORECAST_DAY_FROM NUMBER

SEQ_MRP_FORECAST_DAY_TO NUMBER

PLN_FROZEN_FLAG VARCHAR2 (1)
SHP_FROZEN_FLAG VARCHAR2 (1)
SEQ_FROZEN_FLAG VARCHAR2 (1)
ORG_ID NUMBER

Operating Unit ID
BLANKET_NUMBER NUMBER

Blanket Sales Agreement
RELEASE_RULE VARCHAR2 (2)
Release Rule
RELEASE_TIME_FRAME NUMBER

Release Time Frame
RELEASE_TIME_FRAME_UOM VARCHAR2 (3)
Release Time Frame UOM
EXCLUDE_NON_WORKDAYS_FLAG VARCHAR2 (1)
ITEM_NUMBER VARCHAR2 (40)
DESCRIPTION VARCHAR2 (240)

[top of page]

APPS.RLM_CUST_ITEM_TERMS_V references the following:

APPS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
SYNONYM - MTL_COMMODITY_CODES
SYNONYM - MTL_CUSTOMER_ITEMS
SYNONYM - MTL_CUSTOMER_ITEM_XREFS
VIEW - MTL_ITEM_FLEXFIELDS
SYNONYM - RLM_CUST_ITEM_TERMS

APPS.RLM_CUST_ITEM_TERMS_V is not referenced by any database object

[top of page]

View: RLM_CUST_SHIPTO_TERMS_UNIQUE

Comments
View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
CUST_SHIPTO_TERMS_ID NUMBER

ADDRESS_ID NUMBER

CUSTOMER_ID NUMBER

SHIP_FROM_ORG_ID NUMBER

CUM_CONTROL_CODE VARCHAR2 (30)
SHIP_METHOD VARCHAR2 (30)
INTRANSIT_TIME NUMBER

TIME_UOM_CODE VARCHAR2 (3)
SHIP_DELIVERY_RULE_NAME VARCHAR2 (30)
CUM_CURRENT_RECORD_YEAR VARCHAR2 (35)
CUM_PREVIOUS_RECORD_YEAR VARCHAR2 (240)
CUM_CURRENT_START_DATE DATE

CUM_PREVIOUS_START_DATE DATE

CUM_ORG_LEVEL_CODE VARCHAR2 (30)
CUM_SHIPMENT_RULE_CODE VARCHAR2 (30)
CUM_YESTERD_TIME_CUTOFF NUMBER

CUST_ASSIGN_SUPPLIER_CD VARCHAR2 (35)
CUSTOMER_RCV_CALENDAR_CD VARCHAR2 (10)
FREIGHT_CODE VARCHAR2 (25)
SUPPLIER_SHP_CALENDAR_CD VARCHAR2 (10)
UNSHIP_FIRM_CUTOFF_DAYS NUMBER

UNSHIPPED_FIRM_DISP_CD VARCHAR2 (30)
USE_EDI_SDP_CODE_FLAG VARCHAR2 (1)
DEMAND_TOLERANCE_ABOVE NUMBER

DEMAND_TOLERANCE_BELOW NUMBER

INACTIVE_DATE DATE

HEADER_ID NUMBER

PRICE_LIST_ID NUMBER

CRITICAL_ATTRIBUTE_KEY VARCHAR2 (80)
CUSTOMER_CONTACT_ID NUMBER

PLN_FIRM_DAY_FROM NUMBER

PLN_FIRM_DAY_TO NUMBER

PLN_FORECAST_DAY_FROM NUMBER

PLN_FORECAST_DAY_TO NUMBER

PLN_FROZEN_DAY_TO NUMBER

PLN_FROZEN_DAY_FROM NUMBER

SEQ_FIRM_DAY_FROM NUMBER

SEQ_FIRM_DAY_TO NUMBER

SEQ_FORECAST_DAY_TO NUMBER

SEQ_FORECAST_DAY_FROM NUMBER

SEQ_FROZEN_DAY_FROM NUMBER

SEQ_FROZEN_DAY_TO NUMBER

SHP_FIRM_DAY_FROM NUMBER

SHP_FIRM_DAY_TO NUMBER

SHP_FROZEN_DAY_TO NUMBER

SHP_FROZEN_DAY_FROM NUMBER

SHP_FORECAST_DAY_TO NUMBER

ROUND_TO_STD_PACK_FLAG VARCHAR2 (1)
SUPPLIER_CONTACT_ID NUMBER

AGREEMENT_ID NUMBER

AGREEMENT_NAME VARCHAR2 (240)
STD_PACK_QTY NUMBER

FUTURE_AGREEMENT_ID NUMBER

FUTURE_AGREEMENT_NAME VARCHAR2 (240)
SHP_FORECAST_DAY_FROM NUMBER

SCHEDULE_HIERARCHY_CODE VARCHAR2 (240)
COMMENTS VARCHAR2 (240)
LAST_UPDATED_BY NUMBER

LAST_UPDATE_DATE DATE

CREATION_DATE DATE

CREATED_BY NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 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)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

TP_ATTRIBUTE1 VARCHAR2 (150)
TP_ATTRIBUTE2 VARCHAR2 (150)
TP_ATTRIBUTE3 VARCHAR2 (150)
TP_ATTRIBUTE4 VARCHAR2 (150)
TP_ATTRIBUTE5 VARCHAR2 (150)
TP_ATTRIBUTE6 VARCHAR2 (150)
TP_ATTRIBUTE7 VARCHAR2 (150)
TP_ATTRIBUTE8 VARCHAR2 (150)
TP_ATTRIBUTE9 VARCHAR2 (150)
TP_ATTRIBUTE10 VARCHAR2 (150)
TP_ATTRIBUTE11 VARCHAR2 (150)
TP_ATTRIBUTE12 VARCHAR2 (150)
TP_ATTRIBUTE13 VARCHAR2 (150)
TP_ATTRIBUTE14 VARCHAR2 (150)
TP_ATTRIBUTE15 VARCHAR2 (150)
TP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
MATCH_ACROSS_KEY VARCHAR2 (240)
MATCH_WITHIN_KEY VARCHAR2 (240)
PLN_MRP_FORECAST_DAY_FROM NUMBER

PLN_MRP_FORECAST_DAY_TO NUMBER

SHP_MRP_FORECAST_DAY_FROM NUMBER

SHP_MRP_FORECAST_DAY_TO NUMBER

SEQ_MRP_FORECAST_DAY_FROM NUMBER

SEQ_MRP_FORECAST_DAY_TO NUMBER

INTRANSIT_CALC_BASIS VARCHAR2 (15)
Used to choose between shipment or receipt info to calculate intransit quantities
DEFAULT_SHIP_FROM VARCHAR2 (1)
Used to designate a default processing rule when multiple Ship-From organizations exist at customer or address level setup.
DATA_LEVEL VARCHAR2 (8)

[top of page]

APPS.RLM_CUST_SHIPTO_TERMS_UNIQUE references the following:

APPS
SYNONYM - RLM_CUST_SHIPTO_TERMS

APPS.RLM_CUST_SHIPTO_TERMS_UNIQUE is not referenced by any database object

[top of page]

View: RLM_CUST_SHIPTO_TERMS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
CUSTOMER_NAME VARCHAR2 (360) Y
CUSTOMER_NUMBER VARCHAR2 (30) Y
ECE_LOCATION_CODE VARCHAR2 (40)
CITY VARCHAR2 (60)
POSTAL_CODE VARCHAR2 (60)
PROVINCE VARCHAR2 (60)
COUNTY VARCHAR2 (60)
ADDRESS VARCHAR2 (960)
CUST_SHIPTO_TERMS_ID NUMBER
Y
ADDRESS_ID NUMBER

CUSTOMER_ID NUMBER

SHIP_FROM_ORG_ID NUMBER
Y
CUM_CONTROL_CODE VARCHAR2 (30) Y
SHIP_METHOD VARCHAR2 (30)
INTRANSIT_TIME NUMBER

TIME_UOM_CODE VARCHAR2 (3)
SHIP_DELIVERY_RULE_NAME VARCHAR2 (30) Y
CUM_CURRENT_RECORD_YEAR VARCHAR2 (35)
CUM_PREVIOUS_RECORD_YEAR VARCHAR2 (240)
CUM_CURRENT_START_DATE DATE

CUM_PREVIOUS_START_DATE DATE

CUM_ORG_LEVEL_CODE VARCHAR2 (30)
CUM_SHIPMENT_RULE_CODE VARCHAR2 (30)
CUM_YESTERD_TIME_CUTOFF NUMBER

CUST_ASSIGN_SUPPLIER_CD VARCHAR2 (35)
CUSTOMER_RCV_CALENDAR_CD VARCHAR2 (10)
FREIGHT_CODE VARCHAR2 (25)
SUPPLIER_SHP_CALENDAR_CD VARCHAR2 (10)
UNSHIP_FIRM_CUTOFF_DAYS NUMBER

UNSHIPPED_FIRM_DISP_CD VARCHAR2 (30)
USE_EDI_SDP_CODE_FLAG VARCHAR2 (1) Y
DEMAND_TOLERANCE_ABOVE NUMBER

DEMAND_TOLERANCE_BELOW NUMBER

INACTIVE_DATE DATE

MATCH_ACROSS_KEY VARCHAR2 (240)
MATCH_WITHIN_KEY VARCHAR2 (240)
HEADER_ID NUMBER

PRICE_LIST_ID NUMBER

CRITICAL_ATTRIBUTE_KEY VARCHAR2 (80)
CUSTOMER_CONTACT_ID NUMBER

PLN_FIRM_DAY_FROM NUMBER

PLN_FIRM_DAY_TO NUMBER

PLN_FORECAST_DAY_FROM NUMBER

PLN_FORECAST_DAY_TO NUMBER

PLN_FROZEN_DAY_TO NUMBER

PLN_FROZEN_DAY_FROM NUMBER

SEQ_FIRM_DAY_FROM NUMBER

SEQ_FIRM_DAY_TO NUMBER

SEQ_FORECAST_DAY_TO NUMBER

SEQ_FORECAST_DAY_FROM NUMBER

SEQ_FROZEN_DAY_FROM NUMBER

SEQ_FROZEN_DAY_TO NUMBER

SHP_FIRM_DAY_FROM NUMBER

SHP_FIRM_DAY_TO NUMBER

SHP_FROZEN_DAY_TO NUMBER

SHP_FROZEN_DAY_FROM NUMBER

SHP_FORECAST_DAY_TO NUMBER

ROUND_TO_STD_PACK_FLAG VARCHAR2 (1)
SUPPLIER_CONTACT_ID NUMBER

AGREEMENT_ID NUMBER

AGREEMENT_NAME VARCHAR2 (240)
STD_PACK_QTY NUMBER

FUTURE_AGREEMENT_ID NUMBER

FUTURE_AGREEMENT_NAME VARCHAR2 (240)
SHP_FORECAST_DAY_FROM NUMBER

SCHEDULE_HIERARCHY_CODE VARCHAR2 (240)
COMMENTS VARCHAR2 (240)
LAST_UPDATED_BY NUMBER
Y
LAST_UPDATE_DATE DATE
Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER
Y
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 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)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

TP_ATTRIBUTE1 VARCHAR2 (150)
TP_ATTRIBUTE2 VARCHAR2 (150)
TP_ATTRIBUTE3 VARCHAR2 (150)
TP_ATTRIBUTE4 VARCHAR2 (150)
TP_ATTRIBUTE5 VARCHAR2 (150)
TP_ATTRIBUTE6 VARCHAR2 (150)
TP_ATTRIBUTE7 VARCHAR2 (150)
TP_ATTRIBUTE8 VARCHAR2 (150)
TP_ATTRIBUTE9 VARCHAR2 (150)
TP_ATTRIBUTE10 VARCHAR2 (150)
TP_ATTRIBUTE11 VARCHAR2 (150)
TP_ATTRIBUTE12 VARCHAR2 (150)
TP_ATTRIBUTE13 VARCHAR2 (150)
TP_ATTRIBUTE14 VARCHAR2 (150)
TP_ATTRIBUTE15 VARCHAR2 (150)
TP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
PLN_MRP_FORECAST_DAY_FROM NUMBER

PLN_MRP_FORECAST_DAY_TO NUMBER

SHP_MRP_FORECAST_DAY_FROM NUMBER

SHP_MRP_FORECAST_DAY_TO NUMBER

SEQ_MRP_FORECAST_DAY_FROM NUMBER

SEQ_MRP_FORECAST_DAY_TO NUMBER

INTRANSIT_CALC_BASIS VARCHAR2 (15)
DEFAULT_SHIP_FROM VARCHAR2 (1)
Used to designate a default processing rule when multiple Ship-From organizations exist at address level setup
PLN_FROZEN_FLAG VARCHAR2 (1)
SHP_FROZEN_FLAG VARCHAR2 (1)
SEQ_FROZEN_FLAG VARCHAR2 (1)
ORG_ID NUMBER

Organization Id
BLANKET_NUMBER NUMBER

Blanket Sales Agreement
RELEASE_RULE VARCHAR2 (2)
Release Rule
RELEASE_TIME_FRAME NUMBER

Release Time Frame
RELEASE_TIME_FRAME_UOM VARCHAR2 (3)
Release Time Frame UOM
EXCLUDE_NON_WORKDAYS_FLAG VARCHAR2 (1)
DISABLE_CREATE_CUM_KEY_FLAG VARCHAR2 (1)

[top of page]

APPS.RLM_CUST_SHIPTO_TERMS_V references the following:

APPS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
SYNONYM - RLM_CUST_SHIPTO_TERMS

APPS.RLM_CUST_SHIPTO_TERMS_V is not referenced by any database object

[top of page]

View: RLM_HRZ_SCHEDULE_LINES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER

CUSTOMER_ITEM_ID NUMBER

SHIP_TO_ADDRESS_ID NUMBER

SHIP_FROM_ORG_ID NUMBER

CUST_SHIP_FROM_ORG_EXT VARCHAR2 (80)
CUST_SHIP_TO_EXT VARCHAR2 (35)
CUSTOMER_ITEM_EXT VARCHAR2 (50)
ITEM_DETAIL_TYPE VARCHAR2 (30)
ITEM_DETAIL_SUBTYPE VARCHAR2 (30)
START_DATE_TIME DATE

ITEM_DETAIL_QUANTITY NUMBER

QTY_TYPE_CODE VARCHAR2 (30)
UOM_CODE VARCHAR2 (3)
ORIGIN_TABLE VARCHAR2 (9)
ORG_ID NUMBER

Operating Unit ID

[top of page]

APPS.RLM_HRZ_SCHEDULE_LINES_V references the following:

- RLM_SCHEDULE_INTERFACE_LINES_V

APPS.RLM_HRZ_SCHEDULE_LINES_V is not referenced by any database object

[top of page]

View: RLM_MESSAGE_CATEGORY_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
MESSAGE_CATEGORY_ID NUMBER

MESSAGE_CATEGORY NUMBER

MESSAGE_CATEGORY_DESC VARCHAR2 (240)
MESSAGE_NAME VARCHAR2 (30)
MESSAGE_NUMBER NUMBER (9)
MESSAGE_TEXT VARCHAR2 (2000)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)

[top of page]

APPS.RLM_MESSAGE_CATEGORY_V references the following:

APPS
SYNONYM - FND_APPLICATION
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - FND_NEW_MESSAGES
SYNONYM - RLM_MESSAGE_CATEGORY

APPS.RLM_MESSAGE_CATEGORY_V is not referenced by any database object

[top of page]

View: RLM_OE_ORDER_LINES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
SHIP_FROM_ORG_ID NUMBER

SHIP_TO_ORG_ID NUMBER

CUSTOMER_ITEM_ID NUMBER

INVENTORY_ITEM_ID NUMBER

EVENT_DATE DATE

AUTHORIZED_TO_SHIP_FLAG NUMBER

DEMAND_BUCKET_TYPE_CODE VARCHAR2 (30)
UOM_CODE VARCHAR2 (3)
ORDERED_QTY NUMBER

SHIPPED_QTY NUMBER

OPEN_QTY NUMBER

TOLERANCE_QTY NUMBER

ORG_ID NUMBER

Operating Unit ID

[top of page]

APPS.RLM_OE_ORDER_LINES_V references the following:

APPS
PACKAGE - INV_CONVERT
SYNONYM - OE_ORDER_LINES_ALL

APPS.RLM_OE_ORDER_LINES_V is not referenced by any database object

[top of page]

View: RLM_SCHEDULE_DATES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER

ORIGIN_TABLE VARCHAR2 (9)
CUST_SHIP_FROM_ORG_EXT VARCHAR2 (80)
SHIP_FROM_ORG_ID NUMBER

SHIP_TO_ORG_ID NUMBER

CUST_SHIP_TO_EXT VARCHAR2 (35)
SHIP_TO_ADDRESS_ID NUMBER

START_DATE_TIME DATE

SHIP_TO_CUSTOMER_ID NUMBER

Related Ship To Customer ID
ORG_ID NUMBER

Operating Unit ID

[top of page]

APPS.RLM_SCHEDULE_DATES_V references the following:

APPS
SYNONYM - RLM_INTERFACE_LINES_ALL
SYNONYM - RLM_SCHEDULE_LINES_ALL
- RLM_SCHEDULE_INTERFACE_HDR_V

APPS.RLM_SCHEDULE_DATES_V is not referenced by any database object

[top of page]

View: RLM_SCHEDULE_INTERFACE_HDR_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER

CUSTOMER_ID NUMBER

SCHEDULE_TYPE VARCHAR2 (30)
SCHED_HORIZON_END_DATE DATE

SCHED_HORIZON_START_DATE DATE

SCHEDULE_SOURCE VARCHAR2 (30)
SCHEDULE_PURPOSE VARCHAR2 (30)
SCHEDULE_REFERENCE_NUM VARCHAR2 (35)
CUST_ADDRESS_1_EXT VARCHAR2 (35)
CUST_ADDRESS_2_EXT VARCHAR2 (35)
CUST_ADDRESS_3_EXT VARCHAR2 (35)
CUST_ADDRESS_4_EXT VARCHAR2 (35)
CUST_CITY_EXT VARCHAR2 (30)
CUST_COUNTRY_EXT VARCHAR2 (3)
CUST_COUNTY_EXT VARCHAR2 (25)
CUSTOMER_EXT VARCHAR2 (35)
CUST_NAME_EXT VARCHAR2 (360)
CUST_POSTAL_CD_EXT VARCHAR2 (15)
CUST_PROVINCE_EXT VARCHAR2 (10)
CUST_STATE_EXT VARCHAR2 (10)
ECE_PRIMARY_ADDRESS_ID NUMBER

ECE_TP_LOCATION_CODE_EXT VARCHAR2 (35)
ECE_TP_TRANSLATOR_CODE VARCHAR2 (35)
EDI_CONTROL_NUM_1 VARCHAR2 (15)
EDI_CONTROL_NUM_2 VARCHAR2 (15)
EDI_CONTROL_NUM_3 VARCHAR2 (15)
EDI_TEST_INDICATOR VARCHAR2 (1)
HEADER_CONTACT_CODE_1 VARCHAR2 (3)
HEADER_CONTACT_CODE_2 VARCHAR2 (3)
HEADER_CONTACT_VALUE_1 VARCHAR2 (80)
HEADER_CONTACT_VALUE_2 VARCHAR2 (80)
HEADER_NOTE_TEXT VARCHAR2 (4000)
HEADER_REF_CODE_1 VARCHAR2 (3)
HEADER_REF_CODE_2 VARCHAR2 (3)
HEADER_REF_CODE_3 VARCHAR2 (3)
HEADER_REF_VALUE_1 VARCHAR2 (35)
HEADER_REF_VALUE_2 VARCHAR2 (35)
HEADER_REF_VALUE_3 VARCHAR2 (35)
SCHEDULE_TYPE_EXT VARCHAR2 (30)
SCHED_GENERATION_DATE DATE

SCHEDULE_PURPOSE_EXT VARCHAR2 (30)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 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)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

TP_ATTRIBUTE1 VARCHAR2 (150)
TP_ATTRIBUTE2 VARCHAR2 (150)
TP_ATTRIBUTE3 VARCHAR2 (150)
TP_ATTRIBUTE4 VARCHAR2 (150)
TP_ATTRIBUTE5 VARCHAR2 (150)
TP_ATTRIBUTE6 VARCHAR2 (150)
TP_ATTRIBUTE7 VARCHAR2 (150)
TP_ATTRIBUTE8 VARCHAR2 (150)
TP_ATTRIBUTE9 VARCHAR2 (150)
TP_ATTRIBUTE10 VARCHAR2 (150)
TP_ATTRIBUTE11 VARCHAR2 (150)
TP_ATTRIBUTE12 VARCHAR2 (150)
TP_ATTRIBUTE13 VARCHAR2 (150)
TP_ATTRIBUTE14 VARCHAR2 (150)
TP_ATTRIBUTE15 VARCHAR2 (150)
TP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
PROCESS_STATUS NUMBER

ORIGIN_TABLE VARCHAR2 (9)
SCHEDULE_HEADER_ID NUMBER

ORG_ID NUMBER

Operating Unit ID

[top of page]

APPS.RLM_SCHEDULE_INTERFACE_HDR_V references the following:

APPS
SYNONYM - RLM_INTERFACE_HEADERS
SYNONYM - RLM_INTERFACE_HEADERS_ALL
SYNONYM - RLM_SCHEDULE_HEADERS

APPS.RLM_SCHEDULE_INTERFACE_HDR_V is not referenced by any database object

[top of page]

View: RLM_SCHEDULE_INTERFACE_LINES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
PRIMARY_UOM_CODE VARCHAR2 (3)
LINE_ID NUMBER

LINE_NUMBER NUMBER

CUSTOMER_ITEM_EXT VARCHAR2 (50)
CUSTOMER_ITEM_ID NUMBER

DATE_TYPE_CODE VARCHAR2 (30)
INVENTORY_ITEM_ID NUMBER

ITEM_DETAIL_SUBTYPE VARCHAR2 (30)
ITEM_DETAIL_TYPE VARCHAR2 (30)
QTY_TYPE_CODE VARCHAR2 (30)
HEADER_ID NUMBER

START_DATE_TIME DATE

START_DATE DATE

UOM_CODE VARCHAR2 (3)
ATO_DATA_TYPE VARCHAR2 (30)
CUST_PO_RELEASE_NUM VARCHAR2 (35)
CUST_PO_DATE DATE

CUST_PO_LINE_NUM VARCHAR2 (35)
CUST_PO_NUMBER VARCHAR2 (50)
RETURN_CONTAINER_EXT VARCHAR2 (35)
ROUTING_DESC_EXT VARCHAR2 (35)
ROUTING_SEQ_CODE_EXT VARCHAR2 (3)
SCHEDULE_ITEM_NUM NUMBER

SHIP_DEL_PATTERN_EXT VARCHAR2 (3)
SHIP_DEL_RULE_NAME VARCHAR2 (30)
SHIP_DEL_TIME_CODE_EXT VARCHAR2 (3)
SHIP_FROM_ADDRESS_1_EXT VARCHAR2 (35)
SHIP_FROM_ADDRESS_2_EXT VARCHAR2 (35)
SHIP_FROM_ADDRESS_3_EXT VARCHAR2 (35)
SHIP_FROM_ADDRESS_4_EXT VARCHAR2 (35)
SHIP_FROM_CITY_EXT VARCHAR2 (30)
SHIP_FROM_COUNTRY_EXT VARCHAR2 (3)
SHIP_FROM_COUNTY_EXT VARCHAR2 (25)
SHIP_FROM_NAME_EXT VARCHAR2 (60)
SHIP_FROM_ORG_ID NUMBER

SHIP_FROM_POSTAL_CD_EXT VARCHAR2 (15)
SHIP_FROM_PROVINCE_EXT VARCHAR2 (10)
SHIP_FROM_STATE_EXT VARCHAR2 (10)
SHIP_LABEL_INFO_LINE_1 VARCHAR2 (80)
SHIP_LABEL_INFO_LINE_10 VARCHAR2 (80)
SHIP_LABEL_INFO_LINE_2 VARCHAR2 (80)
SHIP_LABEL_INFO_LINE_3 VARCHAR2 (80)
SHIP_LABEL_INFO_LINE_4 VARCHAR2 (80)
SHIP_LABEL_INFO_LINE_5 VARCHAR2 (80)
SHIP_LABEL_INFO_LINE_6 VARCHAR2 (80)
SHIP_LABEL_INFO_LINE_7 VARCHAR2 (80)
SHIP_LABEL_INFO_LINE_8 VARCHAR2 (80)
SHIP_LABEL_INFO_LINE_9 VARCHAR2 (80)
SHIP_TO_ADDRESS_1_EXT VARCHAR2 (35)
SHIP_TO_ADDRESS_2_EXT VARCHAR2 (35)
SHIP_TO_ADDRESS_3_EXT VARCHAR2 (35)
SHIP_TO_ADDRESS_4_EXT VARCHAR2 (35)
SHIP_TO_ADDRESS_ID NUMBER

SHIP_TO_ORG_ID NUMBER

INVOICE_TO_ORG_ID NUMBER

INTMED_SHIP_TO_ORG_ID NUMBER

DELIVER_TO_ORG_ID NUMBER

SHIP_TO_CITY_EXT VARCHAR2 (30)
SHIP_TO_COUNTRY_EXT VARCHAR2 (3)
SHIP_TO_COUNTY_EXT VARCHAR2 (25)
SHIP_TO_NAME_EXT VARCHAR2 (60)
SHIP_TO_POSTAL_CD_EXT VARCHAR2 (15)
SHIP_TO_PROVINCE_EXT VARCHAR2 (10)
SHIP_TO_SITE_USE_ID NUMBER

SHIP_TO_STATE_EXT VARCHAR2 (10)
SUBLINE_ASSIGNED_ID_EXT VARCHAR2 (20)
SUBLINE_CONFIG_CODE_EXT VARCHAR2 (3)
SUBLINE_CUST_ITEM_EXT VARCHAR2 (50)
SUBLINE_CUST_ITEM_ID NUMBER

SUBLINE_MODEL_NUM_EXT VARCHAR2 (35)
SUBLINE_QUANTITY NUMBER

SUBLINE_UOM_CODE VARCHAR2 (3)
SUPPLIER_ITEM_EXT VARCHAR2 (35)
TRANSIT_TIME_EXT VARCHAR2 (22)
TRANSIT_TIME_QUAL_EXT VARCHAR2 (3)
CUST_PRODUCTION_SEQ_NUM VARCHAR2 (35)
TRANSPORT_LOC_QUAL_EXT VARCHAR2 (3)
TRANSPORT_LOCATION_EXT VARCHAR2 (35)
TRANSPORT_METHOD_EXT VARCHAR2 (3)
WEIGHT_EXT NUMBER

WEIGHT_QUALIFIER_EXT VARCHAR2 (3)
WEIGHT_UOM_EXT VARCHAR2 (3)
ITEM_DETAIL_SUBTYPE_EXT VARCHAR2 (30)
ITEM_DETAIL_TYPE_EXT VARCHAR2 (30)
QTY_TYPE_CODE_EXT VARCHAR2 (30)
DATE_TYPE_CODE_EXT VARCHAR2 (30)
FBO_CONFIGURATION_KEY_1 VARCHAR2 (35)
FBO_CONFIGURATION_KEY_2 VARCHAR2 (35)
FBO_CONFIGURATION_KEY_3 VARCHAR2 (35)
FBO_CONFIGURATION_KEY_4 VARCHAR2 (35)
FBO_CONFIGURATION_KEY_5 VARCHAR2 (35)
MATCH_KEY_ACROSS VARCHAR2 (150)
MATCH_KEY_WITHIN VARCHAR2 (150)
CRITICAL_KEY_ATTRIBUTES VARCHAR2 (150)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 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)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

BILL_TO_ADDRESS_1_EXT VARCHAR2 (35)
BILL_TO_ADDRESS_2_EXT VARCHAR2 (35)
BILL_TO_ADDRESS_3_EXT VARCHAR2 (35)
BILL_TO_ADDRESS_4_EXT VARCHAR2 (35)
BILL_TO_ADDRESS_ID NUMBER

BILL_TO_CITY_EXT VARCHAR2 (30)
BILL_TO_COUNTRY_EXT VARCHAR2 (3)
BILL_TO_COUNTY_EXT VARCHAR2 (25)
BILL_TO_NAME_EXT VARCHAR2 (60)
BILL_TO_POSTAL_CD_EXT VARCHAR2 (15)
BILL_TO_PROVINCE_EXT VARCHAR2 (10)
BILL_TO_SITE_USE_ID NUMBER

BILL_TO_STATE_EXT VARCHAR2 (10)
CARRIER_ID_CODE_EXT VARCHAR2 (35)
CARRIER_QUALIFIER_EXT VARCHAR2 (3)
COMMODITY_EXT VARCHAR2 (35)
COUNTRY_OF_ORIGIN_EXT VARCHAR2 (35)
CUST_ASSEMBLY_EXT VARCHAR2 (30)
CUST_ASSIGNED_ID_EXT VARCHAR2 (20)
CUST_BILL_TO_EXT VARCHAR2 (35)
CUST_CONTRACT_NUM_EXT VARCHAR2 (35)
CUSTOMER_DOCK_CODE VARCHAR2 (50)
CUST_INTRMD_SHIP_TO_EXT VARCHAR2 (35)
CUST_ITEM_PRICE_EXT NUMBER

CUST_ITEM_PRICE_UOM_EXT VARCHAR2 (3)
CUSTOMER_ITEM_REVISION VARCHAR2 (3)
CUSTOMER_JOB VARCHAR2 (50)
CUST_MANUFACTURER_EXT VARCHAR2 (35)
CUST_MODEL_NUMBER_EXT VARCHAR2 (35)
CUST_MODEL_SERIAL_NUMBER VARCHAR2 (35)
CUST_ORDER_NUM_EXT VARCHAR2 (35)
CUST_PROCESS_NUM_EXT VARCHAR2 (35)
CUST_PRODUCTION_LINE VARCHAR2 (50)
CUST_SET_NUM_EXT VARCHAR2 (35)
CUST_SHIP_FROM_ORG_EXT VARCHAR2 (80)
CUST_SHIP_TO_EXT VARCHAR2 (35)
CUST_UOM_EXT VARCHAR2 (10)
END_DATE_TIME DATE

EQUIPMENT_CODE_EXT VARCHAR2 (3)
EQUIPMENT_NUMBER_EXT VARCHAR2 (35)
HANDLING_CODE_EXT VARCHAR2 (3)
HAZARD_CODE_EXT VARCHAR2 (10)
HAZARD_CODE_QUAL_EXT VARCHAR2 (3)
HAZARD_DESCRIPTION_EXT VARCHAR2 (80)
IMPORT_LICENSE_DATE_EXT DATE

IMPORT_LICENSE_EXT VARCHAR2 (35)
INDUSTRY_ATTRIBUTE1 VARCHAR2 (150)
INDUSTRY_ATTRIBUTE10 VARCHAR2 (150)
INDUSTRY_ATTRIBUTE11 VARCHAR2 (150)
INDUSTRY_ATTRIBUTE12 VARCHAR2 (150)
INDUSTRY_ATTRIBUTE13 VARCHAR2 (150)
INDUSTRY_ATTRIBUTE14 VARCHAR2 (150)
INDUSTRY_ATTRIBUTE15 VARCHAR2 (150)
INDUSTRY_ATTRIBUTE2 VARCHAR2 (150)
INDUSTRY_ATTRIBUTE3 VARCHAR2 (150)
INDUSTRY_ATTRIBUTE4 VARCHAR2 (150)
INDUSTRY_ATTRIBUTE5 VARCHAR2 (150)
INDUSTRY_ATTRIBUTE6 VARCHAR2 (150)
INDUSTRY_ATTRIBUTE7 VARCHAR2 (150)
INDUSTRY_ATTRIBUTE8 VARCHAR2 (150)
INDUSTRY_ATTRIBUTE9 VARCHAR2 (150)
INDUSTRY_CONTEXT VARCHAR2 (30)
INTRMD_SHIP_TO_ID NUMBER

INTRMD_ST_ADDRESS_1_EXT VARCHAR2 (35)
INTRMD_ST_ADDRESS_2_EXT VARCHAR2 (35)
INTRMD_ST_ADDRESS_3_EXT VARCHAR2 (35)
INTRMD_ST_ADDRESS_4_EXT VARCHAR2 (35)
INTRMD_ST_CITY_EXT VARCHAR2 (30)
INTRMD_ST_COUNTRY_EXT VARCHAR2 (3)
INTRMD_ST_COUNTY_EXT VARCHAR2 (25)
INTRMD_ST_NAME_EXT VARCHAR2 (60)
INTRMD_ST_POSTAL_CD_EXT VARCHAR2 (15)
INTRMD_ST_PROVINCE_EXT VARCHAR2 (10)
INTRMD_ST_STATE_EXT VARCHAR2 (10)
INTRMD_ST_SITE_USE_ID NUMBER

ITEM_CONTACT_CODE_1 VARCHAR2 (3)
ITEM_CONTACT_CODE_2 VARCHAR2 (3)
ITEM_CONTACT_VALUE_1 VARCHAR2 (80)
ITEM_CONTACT_VALUE_2 VARCHAR2 (80)
ITEM_DESCRIPTION_EXT VARCHAR2 (80)
ITEM_DETAIL_QUANTITY NUMBER

ITEM_DETAIL_REF_CODE_1 VARCHAR2 (3)
ITEM_DETAIL_REF_CODE_2 VARCHAR2 (3)
ITEM_DETAIL_REF_CODE_3 VARCHAR2 (3)
ITEM_DETAIL_REF_VALUE_1 VARCHAR2 (35)
ITEM_DETAIL_REF_VALUE_2 VARCHAR2 (35)
ITEM_DETAIL_REF_VALUE_3 VARCHAR2 (35)
ITEM_ENG_CNG_LVL_EXT VARCHAR2 (35)
ITEM_MEASUREMENTS_EXT VARCHAR2 (240)
ITEM_NOTE_TEXT VARCHAR2 (4000)
ITEM_REF_CODE_1 VARCHAR2 (3)
ITEM_REF_CODE_2 VARCHAR2 (3)
ITEM_REF_CODE_3 VARCHAR2 (3)
ITEM_REF_VALUE_1 VARCHAR2 (35)
ITEM_REF_VALUE_2 VARCHAR2 (35)
ITEM_REF_VALUE_3 VARCHAR2 (35)
ITEM_RELEASE_STATUS_EXT VARCHAR2 (3)
LADING_QUANTITY_EXT NUMBER

LETTER_CREDIT_EXPDT_EXT DATE

LETTER_CREDIT_EXT VARCHAR2 (35)
LINE_REFERENCE VARCHAR2 (50)
LINK_TO_LINE_REF VARCHAR2 (50)
OTHER_NAME_CODE_1 VARCHAR2 (3)
OTHER_NAME_CODE_2 VARCHAR2 (3)
OTHER_NAME_VALUE_1 VARCHAR2 (80)
OTHER_NAME_VALUE_2 VARCHAR2 (80)
PACK_SIZE_EXT NUMBER

PACK_UNITS_PER_PACK_EXT NUMBER

PACK_UOM_CODE_EXT VARCHAR2 (3)
PACKAGING_CODE_EXT VARCHAR2 (10)
PRIMARY_QUANTITY NUMBER

PRIME_CONTRCTR_PART_EXT VARCHAR2 (35)
PROCESS_STATUS NUMBER

TP_ATTRIBUTE1 VARCHAR2 (150)
TP_ATTRIBUTE2 VARCHAR2 (150)
TP_ATTRIBUTE3 VARCHAR2 (150)
TP_ATTRIBUTE4 VARCHAR2 (150)
TP_ATTRIBUTE5 VARCHAR2 (150)
TP_ATTRIBUTE6 VARCHAR2 (150)
TP_ATTRIBUTE7 VARCHAR2 (150)
TP_ATTRIBUTE8 VARCHAR2 (150)
TP_ATTRIBUTE9 VARCHAR2 (150)
TP_ATTRIBUTE10 VARCHAR2 (150)
TP_ATTRIBUTE11 VARCHAR2 (150)
TP_ATTRIBUTE12 VARCHAR2 (150)
TP_ATTRIBUTE13 VARCHAR2 (150)
TP_ATTRIBUTE14 VARCHAR2 (150)
TP_ATTRIBUTE15 VARCHAR2 (150)
TP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
ORIGIN_TABLE VARCHAR2 (9)
LINE_SOURCE VARCHAR2 (30)
SHIP_TO_CUSTOMER_ID NUMBER

Related Ship To Customer ID
ORG_ID NUMBER

Operating Unit ID

[top of page]

APPS.RLM_SCHEDULE_INTERFACE_LINES_V references the following:

APPS
SYNONYM - RLM_INTERFACE_HEADERS
SYNONYM - RLM_INTERFACE_HEADERS_ALL
SYNONYM - RLM_INTERFACE_LINES
SYNONYM - RLM_SCHEDULE_HEADERS
SYNONYM - RLM_SCHEDULE_LINES_ALL

APPS.RLM_SCHEDULE_INTERFACE_LINES_V is not referenced by any database object

[top of page]

View: RLM_SCHEDULE_ITEMS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
SCHEDULE_ITEM_NUM NUMBER

ITEM_DESCRIPTION_EXT VARCHAR2 (80)
HEADER_ID NUMBER

ORIGIN_TABLE VARCHAR2 (9)
CUST_SHIP_FROM_ORG_EXT VARCHAR2 (80)
CUST_SHIP_TO_EXT VARCHAR2 (35)
CUSTOMER_ITEM_EXT VARCHAR2 (50)
CUSTOMER_ITEM_ID NUMBER

INVENTORY_ITEM_ID NUMBER

SUPPLIER_ITEM_EXT VARCHAR2 (35)
CUST_ASSIGNED_ID_EXT VARCHAR2 (20)
COUNTRY_OF_ORIGIN_EXT VARCHAR2 (35)
COMMODITY_EXT VARCHAR2 (35)
CUST_MODEL_NUMBER_EXT VARCHAR2 (35)
ITEM_ENG_CNG_LVL_EXT VARCHAR2 (35)
CUSTOMER_ITEM_REVISION VARCHAR2 (3)
ITEM_RELEASE_STATUS_EXT VARCHAR2 (3)
ITEM_MEASUREMENTS_EXT VARCHAR2 (240)
SHIP_DEL_PATTERN_EXT VARCHAR2 (3)
SHIP_DEL_RULE_NAME VARCHAR2 (30)
SHIP_DEL_TIME_CODE_EXT VARCHAR2 (3)
CUST_PO_NUMBER VARCHAR2 (50)
CUST_PO_DATE DATE

CUST_PO_RELEASE_NUM VARCHAR2 (35)
CUST_PO_LINE_NUM VARCHAR2 (35)
CUST_CONTRACT_NUM_EXT VARCHAR2 (35)
IMPORT_LICENSE_EXT VARCHAR2 (35)
IMPORT_LICENSE_DATE_EXT DATE

LETTER_CREDIT_EXT VARCHAR2 (35)
LETTER_CREDIT_EXPDT_EXT DATE

CUST_ITEM_PRICE_EXT NUMBER

CUST_ITEM_PRICE_UOM_EXT VARCHAR2 (3)
PACK_UNITS_PER_PACK_EXT NUMBER

PACK_SIZE_EXT NUMBER

PACK_UOM_CODE_EXT VARCHAR2 (3)
HAZARD_CODE_QUAL_EXT VARCHAR2 (3)
HAZARD_CODE_EXT VARCHAR2 (10)
HAZARD_DESCRIPTION_EXT VARCHAR2 (80)
HANDLING_CODE_EXT VARCHAR2 (3)
RETURN_CONTAINER_EXT VARCHAR2 (35)
SHIP_LABEL_INFO_LINE_1 VARCHAR2 (80)
SHIP_LABEL_INFO_LINE_2 VARCHAR2 (80)
SHIP_LABEL_INFO_LINE_3 VARCHAR2 (80)
SHIP_LABEL_INFO_LINE_4 VARCHAR2 (80)
SHIP_LABEL_INFO_LINE_5 VARCHAR2 (80)
SHIP_LABEL_INFO_LINE_6 VARCHAR2 (80)
SHIP_LABEL_INFO_LINE_7 VARCHAR2 (80)
SHIP_LABEL_INFO_LINE_8 VARCHAR2 (80)
SHIP_LABEL_INFO_LINE_9 VARCHAR2 (80)
SHIP_LABEL_INFO_LINE_10 VARCHAR2 (80)
CUST_BILL_TO_EXT VARCHAR2 (35)
CUST_INTRMD_SHIP_TO_EXT VARCHAR2 (35)
OTHER_NAME_CODE_1 VARCHAR2 (3)
OTHER_NAME_VALUE_1 VARCHAR2 (80)
OTHER_NAME_CODE_2 VARCHAR2 (3)
OTHER_NAME_VALUE_2 VARCHAR2 (80)
ITEM_REF_CODE_1 VARCHAR2 (3)
ITEM_REF_VALUE_1 VARCHAR2 (35)
ITEM_REF_CODE_2 VARCHAR2 (3)
ITEM_REF_VALUE_2 VARCHAR2 (35)
ITEM_REF_CODE_3 VARCHAR2 (3)
ITEM_REF_VALUE_3 VARCHAR2 (35)
ITEM_CONTACT_CODE_1 VARCHAR2 (3)
ITEM_CONTACT_VALUE_1 VARCHAR2 (80)
ITEM_CONTACT_CODE_2 VARCHAR2 (3)
ITEM_CONTACT_VALUE_2 VARCHAR2 (80)
SHIP_FROM_NAME_EXT VARCHAR2 (60)
SHIP_FROM_ADDRESS_1_EXT VARCHAR2 (35)
SHIP_FROM_ADDRESS_2_EXT VARCHAR2 (35)
SHIP_FROM_ADDRESS_3_EXT VARCHAR2 (35)
SHIP_FROM_ADDRESS_4_EXT VARCHAR2 (35)
SHIP_FROM_CITY_EXT VARCHAR2 (30)
SHIP_FROM_COUNTY_EXT VARCHAR2 (25)
SHIP_FROM_POSTAL_CD_EXT VARCHAR2 (15)
SHIP_FROM_PROVINCE_EXT VARCHAR2 (10)
SHIP_FROM_STATE_EXT VARCHAR2 (10)
SHIP_FROM_COUNTRY_EXT VARCHAR2 (3)
SHIP_FROM_ORG_ID NUMBER

SHIP_TO_NAME_EXT VARCHAR2 (60)
SHIP_TO_ADDRESS_1_EXT VARCHAR2 (35)
SHIP_TO_ADDRESS_2_EXT VARCHAR2 (35)
SHIP_TO_ADDRESS_3_EXT VARCHAR2 (35)
SHIP_TO_ADDRESS_4_EXT VARCHAR2 (35)
SHIP_TO_CITY_EXT VARCHAR2 (30)
SHIP_TO_COUNTY_EXT VARCHAR2 (25)
SHIP_TO_POSTAL_CD_EXT VARCHAR2 (15)
SHIP_TO_PROVINCE_EXT VARCHAR2 (10)
SHIP_TO_STATE_EXT VARCHAR2 (10)
SHIP_TO_COUNTRY_EXT VARCHAR2 (3)
SHIP_TO_ADDRESS_ID NUMBER

SHIP_TO_ORG_ID NUMBER

INVOICE_TO_ORG_ID NUMBER

INTMED_SHIP_TO_ORG_ID NUMBER

DELIVER_TO_ORG_ID NUMBER

BILL_TO_NAME_EXT VARCHAR2 (60)
BILL_TO_ADDRESS_1_EXT VARCHAR2 (35)
BILL_TO_ADDRESS_2_EXT VARCHAR2 (35)
BILL_TO_ADDRESS_3_EXT VARCHAR2 (35)
BILL_TO_ADDRESS_4_EXT VARCHAR2 (35)
BILL_TO_CITY_EXT VARCHAR2 (30)
BILL_TO_COUNTY_EXT VARCHAR2 (25)
BILL_TO_POSTAL_CD_EXT VARCHAR2 (15)
BILL_TO_PROVINCE_EXT VARCHAR2 (10)
BILL_TO_STATE_EXT VARCHAR2 (10)
BILL_TO_COUNTRY_EXT VARCHAR2 (3)
BILL_TO_ADDRESS_ID NUMBER

INTRMD_ST_NAME_EXT VARCHAR2 (60)
INTRMD_ST_ADDRESS_1_EXT VARCHAR2 (35)
INTRMD_ST_ADDRESS_2_EXT VARCHAR2 (35)
INTRMD_ST_ADDRESS_3_EXT VARCHAR2 (35)
INTRMD_ST_ADDRESS_4_EXT VARCHAR2 (35)
INTRMD_ST_CITY_EXT VARCHAR2 (30)
INTRMD_ST_COUNTY_EXT VARCHAR2 (25)
INTRMD_ST_POSTAL_CD_EXT VARCHAR2 (15)
INTRMD_ST_PROVINCE_EXT VARCHAR2 (10)
INTRMD_ST_STATE_EXT VARCHAR2 (10)
INTRMD_ST_COUNTRY_EXT VARCHAR2 (3)
ITEM_NOTE_TEXT VARCHAR2 (4000)
INDUSTRY_ATTRIBUTE1 VARCHAR2 (150)
INTRMD_SHIP_TO_ID NUMBER

CUSTOMER_DOCK_CODE VARCHAR2 (50)
CARRIER_QUALIFIER_EXT VARCHAR2 (3)
CARRIER_ID_CODE_EXT VARCHAR2 (35)
TRANSIT_TIME_QUAL_EXT VARCHAR2 (3)
TRANSIT_TIME_EXT VARCHAR2 (22)
TRANSPORT_LOC_QUAL_EXT VARCHAR2 (3)
TRANSPORT_METHOD_EXT VARCHAR2 (3)
TRANSPORT_LOCATION_EXT VARCHAR2 (35)
WEIGHT_QUALIFIER_EXT VARCHAR2 (3)
WEIGHT_EXT NUMBER

WEIGHT_UOM_EXT VARCHAR2 (3)
ROUTING_DESC_EXT VARCHAR2 (35)
ROUTING_SEQ_CODE_EXT VARCHAR2 (3)
EQUIPMENT_CODE_EXT VARCHAR2 (3)
EQUIPMENT_NUMBER_EXT VARCHAR2 (35)
CUST_ASSEMBLY_EXT VARCHAR2 (30)
CUST_MANUFACTURER_EXT VARCHAR2 (35)
CUST_MODEL_SERIAL_NUMBER VARCHAR2 (35)
CUST_ORDER_NUM_EXT VARCHAR2 (35)
CUST_PROCESS_NUM_EXT VARCHAR2 (35)
CUST_PRODUCTION_LINE VARCHAR2 (50)
CUST_PRODUCTION_SEQ_NUM VARCHAR2 (35)
CUST_SET_NUM_EXT VARCHAR2 (35)
CUSTOMER_JOB VARCHAR2 (50)
LADING_QUANTITY_EXT NUMBER

PRIME_CONTRCTR_PART_EXT VARCHAR2 (35)
SHIP_TO_CUSTOMER_ID NUMBER

Related Ship To Customer ID
ORG_ID NUMBER

Operating Unit ID

[top of page]

APPS.RLM_SCHEDULE_ITEMS_V references the following:

APPS
SYNONYM - RLM_INTERFACE_LINES_ALL
SYNONYM - RLM_SCHEDULE_LINES_ALL
- RLM_SCHEDULE_INTERFACE_HDR_V

APPS.RLM_SCHEDULE_ITEMS_V is not referenced by any database object

[top of page]

View: RLM_SCHEDULE_LINE_CUM_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
CUM_START_DATE DATE
Y
CUM_KEY_ID NUMBER
Y
SCHEDULE_REFERENCE_NUM VARCHAR2 (35) Y
ITEM_DETAIL_SUBTYPE VARCHAR2 (30) Y
DATE_TYPE_CODE VARCHAR2 (30) Y
START_DATE_TIME DATE
Y
END_DATE_TIME DATE

QTY_TYPE_CODE VARCHAR2 (30) Y
ITEM_DETAIL_QUANTITY NUMBER

UOM_CODE VARCHAR2 (3) Y
SHIP_FROM_ORG_ID NUMBER

SHIP_TO_ORG_ID NUMBER

CUSTOMER_ITEM_ID NUMBER
Y
ORG_ID NUMBER

Operating Unit ID

[top of page]

APPS.RLM_SCHEDULE_LINE_CUM_V references the following:

APPS
SYNONYM - RLM_CUST_ITEM_CUM_KEYS
SYNONYM - RLM_SCHEDULE_HEADERS_ALL
SYNONYM - RLM_SCHEDULE_LINES_ALL

APPS.RLM_SCHEDULE_LINE_CUM_V is not referenced by any database object

[top of page]

View: RLM_SHIPTO_ITEM_TERMS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
CUSTOMER_NAME VARCHAR2 (360) Y
CUSTOMER_NUMBER VARCHAR2 (30) Y
ECE_LOCATION_CODE VARCHAR2 (40)
CITY VARCHAR2 (60)
POSTAL_CODE VARCHAR2 (60)
PROVINCE VARCHAR2 (60)
COUNTY VARCHAR2 (60)
ADDRESS VARCHAR2 (960)
CUSTOMER_ITEM_NUMBER VARCHAR2 (50) Y
CUSTOMER_ITEM_DESC VARCHAR2 (240)
COMMODITY_CODE VARCHAR2 (30) Y
CUSTOMER_ID NUMBER
Y
CUST_ITEM_TERMS_ID NUMBER
Y
CUSTOMER_ITEM_ID NUMBER
Y
SHIP_FROM_ORG_ID NUMBER
Y
ADDRESS_ID NUMBER

HEADER_ID NUMBER

AGREEMENT_ID NUMBER

AGREEMENT_NAME VARCHAR2 (240)
FUTURE_AGREEMENT_ID NUMBER

FUTURE_AGREEMENT_NAME VARCHAR2 (240)
CALC_CUM_FLAG VARCHAR2 (1)
CUM_CURRENT_START_DATE DATE

CUM_PREVIOUS_START_DATE DATE

CUST_ITEM_STATUS_CODE VARCHAR2 (25)
ROUND_TO_STD_PACK_FLAG VARCHAR2 (1)
SHIP_DELIVERY_RULE_NAME VARCHAR2 (30)
SHIP_METHOD VARCHAR2 (30)
INTRANSIT_TIME NUMBER

TIME_UOM_CODE VARCHAR2 (3)
STD_PACK_QTY NUMBER

PRICE_LIST_ID NUMBER

DEMAND_TOLERANCE_ABOVE NUMBER

USE_EDI_SDP_CODE_FLAG VARCHAR2 (1) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER
Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER
Y
PLN_FIRM_DAY_TO NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (30)
PLN_FORECAST_DAY_FROM NUMBER

PLN_FORECAST_DAY_TO NUMBER

PLN_FROZEN_DAY_TO NUMBER

PLN_FROZEN_DAY_FROM NUMBER

ATTRIBUTE1 VARCHAR2 (150)
SEQ_FIRM_DAY_FROM NUMBER

SEQ_FIRM_DAY_TO NUMBER

ATTRIBUTE2 VARCHAR2 (150)
SEQ_FORECAST_DAY_TO NUMBER

SEQ_FORECAST_DAY_FROM NUMBER

ATTRIBUTE3 VARCHAR2 (150)
SEQ_FROZEN_DAY_FROM NUMBER

SEQ_FROZEN_DAY_TO NUMBER

ATTRIBUTE4 VARCHAR2 (150)
SHP_FIRM_DAY_FROM NUMBER

SHP_FIRM_DAY_TO NUMBER

ATTRIBUTE5 VARCHAR2 (150)
SHP_FROZEN_DAY_TO NUMBER

SHP_FROZEN_DAY_FROM NUMBER

ATTRIBUTE6 VARCHAR2 (150)
SHP_FORECAST_DAY_TO NUMBER

SHP_FORECAST_DAY_FROM NUMBER

ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

DEMAND_TOLERANCE_BELOW NUMBER

CUSTOMER_CONTACT_ID NUMBER

FREIGHT_CODE VARCHAR2 (25)
PLN_FIRM_DAY_FROM NUMBER

SUPPLIER_CONTACT_ID NUMBER

INACTIVE_DATE DATE

COMMENTS VARCHAR2 (240)
DEFAULT_SHIP_FROM VARCHAR2 (1)
Used to designate a default processing rule when multiple Ship-From organizations exist at item level
TP_ATTRIBUTE1 VARCHAR2 (150)
TP_ATTRIBUTE2 VARCHAR2 (150)
TP_ATTRIBUTE3 VARCHAR2 (150)
TP_ATTRIBUTE4 VARCHAR2 (150)
TP_ATTRIBUTE5 VARCHAR2 (150)
TP_ATTRIBUTE6 VARCHAR2 (150)
TP_ATTRIBUTE7 VARCHAR2 (150)
TP_ATTRIBUTE8 VARCHAR2 (150)
TP_ATTRIBUTE9 VARCHAR2 (150)
TP_ATTRIBUTE10 VARCHAR2 (150)
TP_ATTRIBUTE11 VARCHAR2 (150)
TP_ATTRIBUTE12 VARCHAR2 (150)
TP_ATTRIBUTE13 VARCHAR2 (150)
TP_ATTRIBUTE14 VARCHAR2 (150)
TP_ATTRIBUTE15 VARCHAR2 (150)
TP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
PLN_MRP_FORECAST_DAY_FROM NUMBER

PLN_MRP_FORECAST_DAY_TO NUMBER

SHP_MRP_FORECAST_DAY_FROM NUMBER

SHP_MRP_FORECAST_DAY_TO NUMBER

SEQ_MRP_FORECAST_DAY_FROM NUMBER

SEQ_MRP_FORECAST_DAY_TO NUMBER

PLN_FROZEN_FLAG VARCHAR2 (1)
SHP_FROZEN_FLAG VARCHAR2 (1)
SEQ_FROZEN_FLAG VARCHAR2 (1)
ORG_ID NUMBER

BLANKET_NUMBER NUMBER

Blanket Sales Agreement
RELEASE_RULE VARCHAR2 (2)
Release Rule
RELEASE_TIME_FRAME NUMBER

Release Time Frame
RELEASE_TIME_FRAME_UOM VARCHAR2 (3)
Release Time Frame UOM
EXCLUDE_NON_WORKDAYS_FLAG VARCHAR2 (1)
ITEM_NUMBER VARCHAR2 (40)
DESCRIPTION VARCHAR2 (240)

[top of page]

APPS.RLM_SHIPTO_ITEM_TERMS_V references the following:

APPS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
SYNONYM - MTL_COMMODITY_CODES
SYNONYM - MTL_CUSTOMER_ITEMS
SYNONYM - MTL_CUSTOMER_ITEM_XREFS
VIEW - MTL_ITEM_FLEXFIELDS
SYNONYM - RLM_CUST_ITEM_TERMS

APPS.RLM_SHIPTO_ITEM_TERMS_V is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract