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_RULE_ASSIGNMENTS

Object Details

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

OM Batch Reservation Rule Assignments

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GML_BATCH_SO_RULE_ASSIGN_PK	NORMAL	UNIQUE	APPS_TS_SEED	RULE_ASSIGN_ID
GML_BATCH_SO_RULE_ASSIGN_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	WHSE_CODE ALLOCATION_CLASS ITEM_ID CUSTOMER_ID SITE_USE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RULE_ASSIGN_ID	NUMBER	(15)	Yes	Primary Key
RULE_ID	NUMBER	(15)	Yes	Reference to GML_batch_so_rules.rule_id
WHSE_CODE	VARCHAR2	(5)	Yes	Warehouse code that rule has assigned to, required field
CUSTOMER_ID	NUMBER	(15)		Customer id that rule has assigned to
SITE_USE_ID	NUMBER	(15)		Ship to customer site use id
ITEM_ID	NUMBER	(15)		Item that this rules might be applied
ALLOCATION_CLASS	VARCHAR2	(30)		Allocation class value this rule will be applied
DELETE_MARK	NUMBER	(5)		Value of 0 meaning the record is active, 1 meaning deleted
ORGANIZATION_ID	NUMBER	(15)	Yes	Inventory organisation id for the warehouse
CREATION_DATE	DATE		Yes	The date record is created
CREATED_BY	NUMBER	(15)	Yes	User id who created the record
PROGRAM_APPLICATION_ID	NUMBER			Program application id
PROGRAM_ID	NUMBER	(15)		Program ID
LAST_UPDATED_BY	NUMBER		Yes	The user id who last updated the record
LAST_UPDATE_LOGIN	NUMBER	(15)		Last update login
LAST_UPDATE_DATE	DATE		Yes	The date the record is last updated

Query Text

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


SELECT RULE_ASSIGN_ID
,      RULE_ID
,      WHSE_CODE
,      CUSTOMER_ID
,      SITE_USE_ID
,      ITEM_ID
,      ALLOCATION_CLASS
,      DELETE_MARK
,      ORGANIZATION_ID
,      CREATION_DATE
,      CREATED_BY
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
FROM GML.GML_BATCH_SO_RULE_ASSIGNMENTS;

Dependencies

[top of page]

GML.GML_BATCH_SO_RULE_ASSIGNMENTS does not reference any database object

GML.GML_BATCH_SO_RULE_ASSIGNMENTS is referenced by following:

APPS: GML_BATCH_SO_RULE_ASSIGNMENTS