eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: RLM.RLM_SHIP_DELIVERY_CODES

Object Details

Object Name:	RLM_SHIP_DELIVERY_CODES
Object Type:	TABLE
Owner:	RLM
FND Design Data:	RLM.RLM_SHIP_DELIVERY_CODES
Subobject Name:
Status:	VALID

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.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
SHIP_DELIVERY_RULE_NAME	VARCHAR2	(30)	Yes	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		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
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

Query Text

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


SELECT SHIP_DELIVERY_RULE_NAME
,      DESCRIPTION
,      MONDAY_PERCENT
,      TUESDAY_PERCENT
,      WEDNESDAY_PERCENT
,      THURSDAY_PERCENT
,      FRIDAY_PERCENT
,      SATURDAY_PERCENT
,      SUNDAY_PERCENT
,      USER_MAINTAINABLE_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      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
FROM RLM.RLM_SHIP_DELIVERY_CODES;

Dependencies

[top of page]

RLM.RLM_SHIP_DELIVERY_CODES does not reference any database object

RLM.RLM_SHIP_DELIVERY_CODES is referenced by following:

RLM: RLM_SHIP_DELIVERY_CODES#