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: GML.GML_BATCH_SO_RULES

Object Details

Object Name:	GML_BATCH_SO_RULES
Object Type:	TABLE
Owner:	GML
FND Design Data:	GML.GML_BATCH_SO_RULES
Subobject Name:
Status:	VALID

OM Batch reservations rules

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GML_BATCH_SO_RULES_PK	NORMAL	UNIQUE	APPS_TS_SEED	RULE_ID
GML_BATCH_SO_RULES_U1	NORMAL	UNIQUE	APPS_TS_SEED	RULE_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
RULE_ID	NUMBER	(15)	Yes	Primary Key
RULE_NAME	VARCHAR2	(30)	Yes	Rule Name
DAYS_BEFORE_SHIP_DATE	NUMBER			Days before scheduled ship date of the range of the available batch(s) should be searched. Null meaning, no limits.
DAYS_AFTER_SHIP_DATE	NUMBER			Days after scheduled ship date of the range of the available batch(s) should be searched. Null meaning, no limits.
BATCH_STATUS	VARCHAR2	(30)	Yes	Starting batch status for sales to reserve. When this status is specified batches from this status to WIP will be available for teh sales order to reserve.
ALLOCATION_TOLERANCE	NUMBER			The percentage of maximum quantity that sales orders can reserve above the planned quantity.
ALLOCATION_PRIORITY	NUMBER			Value of 1: meaning that is sorted by scheduled shipdate/shipment priority. Value of 2: means distributed evenly.
AUTO_PICK_CONFIRM	VARCHAR2	(1)		Y/N, Null meaning N, Y will kick off the pickconfirm process after allocation is made
BATCH_NOTIFICATION	VARCHAR2	(1)		Y/N, Null meaning N
ORDER_NOTIFICATION	VARCHAR2	(1)		Y/N, Null meaning N
ENABLE_FPO	VARCHAR2	(1)		Y/N, Null meaning N, a value of Y will have FPO available for orders to reserve.
DELETE_MARK	NUMBER	(5)		0 is active, 1 is deleted.
CREATION_DATE	DATE		Yes	Date created
CREATED_BY	NUMBER	(15)	Yes	User ID who created it.
PROGRAM_APPLICATION_ID	NUMBER			Program Application Id
PROGRAM_ID	NUMBER			Program ID
LAST_UPDATED_BY	NUMBER	(15)	Yes	The record was updated by last
LAST_UPDATE_DATE	DATE		Yes	The date the record was last updated by
RULE_TYPE	NUMBER		Yes	1-Create and Reserve, 0 Reserve Only, Prepopulated with 0
BATCH_TYPE_TO_CREATE	NUMBER			Indication wheter to create a Batch or an FPO
BATCH_CREATION_USER	NUMBER			Standard WHO
CHECK_AVAILABILITY	VARCHAR2	(1)		Y/N, Null Meaning N
AUTO_LOT_GENERATION	VARCHAR2	(1)		Y/N, Null Meaning N
FIRMED_IND	VARCHAR2	(1)		Y/N, Null Meaning N
RESERVE_MAX_TOLERANCE	VARCHAR2	(1)		Y/N, Null Meaning N
COPY_ATTACHMENTS	VARCHAR2	(1)		Y/N, Null Meaning N
SALES_ORDER_ATTACHMENT	NUMBER			Attachment ID on the SO to be copied to the Batch
BATCH_ATTACHMENT	NUMBER			Attachment id on the batch
BATCH_CREATION_NOTIFICATION	VARCHAR2	(1)		Y/N, Null meaning N

Query Text

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


SELECT RULE_ID
,      RULE_NAME
,      DAYS_BEFORE_SHIP_DATE
,      DAYS_AFTER_SHIP_DATE
,      BATCH_STATUS
,      ALLOCATION_TOLERANCE
,      ALLOCATION_PRIORITY
,      AUTO_PICK_CONFIRM
,      BATCH_NOTIFICATION
,      ORDER_NOTIFICATION
,      ENABLE_FPO
,      DELETE_MARK
,      CREATION_DATE
,      CREATED_BY
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      RULE_TYPE
,      BATCH_TYPE_TO_CREATE
,      BATCH_CREATION_USER
,      CHECK_AVAILABILITY
,      AUTO_LOT_GENERATION
,      FIRMED_IND
,      RESERVE_MAX_TOLERANCE
,      COPY_ATTACHMENTS
,      SALES_ORDER_ATTACHMENT
,      BATCH_ATTACHMENT
,      BATCH_CREATION_NOTIFICATION
FROM GML.GML_BATCH_SO_RULES;

Dependencies

[top of page]

GML.GML_BATCH_SO_RULES does not reference any database object

GML.GML_BATCH_SO_RULES is referenced by following:

GML: GML_BATCH_SO_RULES#