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.OP_ALOT_PRM

Object Details

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

OP_ALOT_PRM is the table for allocation parameters by customers and item class. This table is used when automatic lot allocation is done in OP. You can specify customer-related fields such as cust_id; lot-related fields such as alloc_method,shelf_days,alloc_type,alloc_horizon,partial_ind; and item-related fields such as prefqc_grade,alloc_class.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OP_ALOT_PRM_PK	NORMAL	UNIQUE	APPS_TS_SEED	ALLOCRULE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ALLOCRULE_ID	NUMBER	(15)	Yes	Surrogate key to uniquely identify record
ALLOC_METHOD	NUMBER	(5)	Yes	Allocation method flag. Defaults to 0. Value of 0 means that the fifo (first in, first out) method of allocation is used to select lots; a value of 1 means that the fefo method (first to expire, first out) is used to select lots.
SHELF_DAYS	NUMBER	(5)	Yes	Number of lead or shelf days required for use. These days are added to the scheduled ship date to allow extra lead time for comparison to the lot expiration date. (i.e., lot expiration date > sched ship date + shelf days). A value of 0
ALLOC_HORIZON	NUMBER	(5)	Yes	Number of days which comprise the period that lots will be allocated to orders. These days are added to the current date and compared to the scheduled ship date. If the scheduled ship date falls within this period, then automatic lot all
ALLOC_TYPE	NUMBER	(5)	Yes	Defaults to 0 and indicates the way in which lot allocation will be invoked. A value of 0 means that the user must initiate automatic allocation; a value of 1 means that the system will automatically allocate lots when an order or shipmen
LOT_QTY	NUMBER	(5)	Yes	Indicates the number of lots to be allocated. Defaults to 0 which means that multiple lots may be allocated. A value of 1 means that only a single lot may be allocated for an order line.
ALLOC_CLASS	VARCHAR2	(8)		Allocation class (of items) to which these allocation parameters; fk to ic_allc_cls.
PARTIAL_IND	NUMBER	(5)	Yes	Indicates if part of the order quantity may be allocated. A value of 0 (default) indicates that the entire order or ship quantity must be allocated; a value of 1 indicates that partial allocation (of less than the order or ship qty) may b
PREFQC_GRADE	VARCHAR2	(4)		The preferred qc grade for allocation can be indicated. If blank, then any grade available will be allocated. If a grade is entered, then only that grade will be allocated. Fk to qc_grad_mst.
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
TRANS_CNT	NUMBER	(10)		Not currently used
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
CUST_ID	NUMBER	(15)		Surrogate key for customer master record. Fk to op_cust_mst. Customer for whom these allocation parameters apply. May be NULL, which means these parameters do not apply for one specific customer, but for all customers.
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
SOLD_TO_ORG_ID	NUMBER			For future use
SHIP_TO_ORG_ID	NUMBER			For future use
ALLOC_CATEGORY_ID	NUMBER			Category Id for ALLOC_CLASS
OPM_CUST_ID	NUMBER	(10)		Used by OM users only. Stores customer id to op_cust_mst (OPM customer table) for historical purposes.
CO_CODE	VARCHAR2	(4)		Company Code
ORG_ID	NUMBER			Customer operating unit identifier
GRADE_OR_QC_FLAG	NUMBER	(1)	Yes	If activated with value 1, this flag specifies that QC result should be considered as criteria for auto allocation. default value 0 = grade considered for auto allocation if either grade exists on op_alot_prm form or on the sales order line. QC match result is not considered. value 1 = QC match result considered for auto allocation. Grade is not considered.

Query Text

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


SELECT ALLOCRULE_ID
,      ALLOC_METHOD
,      SHELF_DAYS
,      ALLOC_HORIZON
,      ALLOC_TYPE
,      LOT_QTY
,      ALLOC_CLASS
,      PARTIAL_IND
,      PREFQC_GRADE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      DELETE_MARK
,      CUST_ID
,      TEXT_CODE
,      SOLD_TO_ORG_ID
,      SHIP_TO_ORG_ID
,      ALLOC_CATEGORY_ID
,      OPM_CUST_ID
,      CO_CODE
,      ORG_ID
,      GRADE_OR_QC_FLAG
FROM GML.OP_ALOT_PRM;

Dependencies

[top of page]

GML.OP_ALOT_PRM does not reference any database object

GML.OP_ALOT_PRM is referenced by following:

GML: OP_ALOT_PRM#