DBA Data[Home] [Help] [Dependency Information]

TABLE: RLM.RLM_CUST_ITEM_TERMS_ALL

Object Details
Object Name: RLM_CUST_ITEM_TERMS_ALL
Object Type: TABLE
Owner: RLM
FND Design Data: TableRLM.RLM_CUST_ITEM_TERMS_ALL
Subobject Name:
Status: VALID


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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
RLM_CUST_ITEM_TERMS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUST_ITEM_TERMS_ID
RLM_CUST_ITEM_TERMS_U2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_ITEM_ID
ColumnSHIP_FROM_ORG_ID
ColumnCUSTOMER_ID
ColumnADDRESS_ID
ColumnORG_ID
Columns
Name Datatype Length Mandatory Comments
CUST_ITEM_TERMS_ID NUMBER
Yes Ship From Customer Item Unique Identifier
CUSTOMER_ITEM_ID NUMBER
Yes Customer Item unique identifier. FK to MTL_CUSTOMER_ITEMS.
SHIP_FROM_ORG_ID NUMBER
Yes 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) Yes 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
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes 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
Yes 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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CUST_ITEM_TERMS_ID
,      CUSTOMER_ITEM_ID
,      SHIP_FROM_ORG_ID
,      ADDRESS_ID
,      HEADER_ID
,      AGREEMENT_NAME
,      FUTURE_AGREEMENT_NAME
,      CALC_CUM_FLAG
,      CUM_CURRENT_START_DATE
,      CUM_PREVIOUS_START_DATE
,      CUST_ITEM_STATUS_CODE
,      ROUND_TO_STD_PACK_FLAG
,      SHIP_DELIVERY_RULE_NAME
,      SHIP_METHOD
,      INTRANSIT_TIME
,      STD_PACK_QTY
,      TIME_UOM_CODE
,      ORG_ID
,      PRICE_LIST_ID
,      DEMAND_TOLERANCE_ABOVE
,      USE_EDI_SDP_CODE_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      PLN_FIRM_DAY_TO
,      ATTRIBUTE_CATEGORY
,      PLN_FORECAST_DAY_FROM
,      PLN_FORECAST_DAY_TO
,      PLN_FROZEN_DAY_TO
,      PLN_FROZEN_DAY_FROM
,      ATTRIBUTE1
,      SEQ_FIRM_DAY_FROM
,      SEQ_FIRM_DAY_TO
,      ATTRIBUTE2
,      SEQ_FORECAST_DAY_TO
,      SEQ_FORECAST_DAY_FROM
,      ATTRIBUTE3
,      SEQ_FROZEN_DAY_FROM
,      SEQ_FROZEN_DAY_TO
,      ATTRIBUTE4
,      SHP_FIRM_DAY_FROM
,      SHP_FIRM_DAY_TO
,      ATTRIBUTE5
,      SHP_FROZEN_DAY_TO
,      SHP_FROZEN_DAY_FROM
,      ATTRIBUTE6
,      SHP_FORECAST_DAY_TO
,      SHP_FORECAST_DAY_FROM
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      DEMAND_TOLERANCE_BELOW
,      CUSTOMER_CONTACT_ID
,      CUSTOMER_ID
,      FREIGHT_CODE
,      PLN_FIRM_DAY_FROM
,      SUPPLIER_CONTACT_ID
,      TP_ATTRIBUTE1
,      TP_ATTRIBUTE2
,      TP_ATTRIBUTE3
,      TP_ATTRIBUTE4
,      TP_ATTRIBUTE5
,      TP_ATTRIBUTE6
,      TP_ATTRIBUTE7
,      TP_ATTRIBUTE8
,      TP_ATTRIBUTE9
,      TP_ATTRIBUTE10
,      TP_ATTRIBUTE11
,      TP_ATTRIBUTE12
,      TP_ATTRIBUTE13
,      TP_ATTRIBUTE14
,      TP_ATTRIBUTE15
,      TP_ATTRIBUTE_CATEGORY
,      INACTIVE_DATE
,      COMMENTS
,      PLN_MRP_FORECAST_DAY_FROM
,      PLN_MRP_FORECAST_DAY_TO
,      SHP_MRP_FORECAST_DAY_FROM
,      SHP_MRP_FORECAST_DAY_TO
,      SEQ_MRP_FORECAST_DAY_FROM
,      SEQ_MRP_FORECAST_DAY_TO
,      DEFAULT_SHIP_FROM
,      PLN_FROZEN_FLAG
,      SHP_FROZEN_FLAG
,      SEQ_FROZEN_FLAG
,      ISSUE_WARNING_DROP_PARTS_FLAG
,      BLANKET_NUMBER
,      RELEASE_RULE
,      RELEASE_TIME_FRAME
,      RELEASE_TIME_FRAME_UOM
,      AGREEMENT_ID
,      FUTURE_AGREEMENT_ID
,      EXCLUDE_NON_WORKDAYS_FLAG
,      DISABLE_CREATE_CUM_KEY_FLAG
FROM RLM.RLM_CUST_ITEM_TERMS_ALL;

Dependencies

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

SchemaAPPS
SynonymRLM_CUST_ITEM_TERMS
SynonymRLM_CUST_ITEM_TERMS_ALL