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: GMI.IC_LOTS_STS

Object Details

Object Name:	IC_LOTS_STS
Object Type:	TABLE
Owner:	GMI
FND Design Data:	GMI.IC_LOTS_STS
Subobject Name:
Status:	VALID

Lot status table. Defines whether lots with a given status are usable
for certain functions (sales order processing, production, shipping).

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IC_LOTS_STS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	LOT_STATUS

Columns

Name	Datatype	Length	Mandatory	Comments
LOT_STATUS	VARCHAR2	(4)	Yes	Code for the lot status.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
STATUS_DESC	VARCHAR2	(40)	Yes	Description of status.
QCHOLD_RES_CODE	VARCHAR2	(4)		Reason code for qc hold.
NETTABLE_IND	NUMBER	(5)	Yes	Indicates whether lots with this status are considered by MRP. 0=Lots are not considered by MRP, 1=Lots are considered by MRP.
ORDER_PROC_IND	NUMBER	(5)	Yes	0=Not available for sales orders; 1=Available for sales orders if nettable and not rejected.
PROD_IND	NUMBER	(5)	Yes	0=Not available for production; 1=Available for production if nettable and not rejected.
SHIPPING_IND	NUMBER	(5)	Yes	0=Not available for shipping; 1=Available for shipping if nettable and not rejected.
REJECTED_IND	NUMBER	(5)	Yes	0=lot accepted; 1=lot rejected.
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	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.
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
STATUS_ID	NUMBER			The status_id of the migrated status in the material status table MTL_MATERIAL_STATUSES_b in discrete
MIGRATED_IND	NUMBER	(5)		Column indicating if the record has been migrated to discrete.1=yes, Null =no

Query Text

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


SELECT LOT_STATUS
,      LAST_UPDATE_LOGIN
,      STATUS_DESC
,      QCHOLD_RES_CODE
,      NETTABLE_IND
,      ORDER_PROC_IND
,      PROD_IND
,      SHIPPING_IND
,      REJECTED_IND
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      TRANS_CNT
,      DELETE_MARK
,      TEXT_CODE
,      STATUS_ID
,      MIGRATED_IND
FROM GMI.IC_LOTS_STS;

Dependencies

[top of page]

GMI.IC_LOTS_STS does not reference any database object

GMI.IC_LOTS_STS is referenced by following:

APPS: IC_LOTS_STS