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

TABLE: GMI.GMI_DISCRETE_TRANSFER_LINES

Object Details
Object Name: GMI_DISCRETE_TRANSFER_LINES
Object Type: TABLE
Owner: GMI
FND Design Data: TableGMI.GMI_DISCRETE_TRANSFER_LINES
Subobject Name:
Status: VALID


Process to/from Discrete inventory transfer lines table. Holds transfer lines information


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMI_DISCRETE_TRANSFER_LINES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSFER_ID
ColumnLINE_ID
Columns
Name Datatype Length Mandatory Comments
TRANSFER_ID NUMBER
Yes Surrogate key for the transfer
LINE_ID NUMBER
Yes Surrogate key for the transfer line
LINE_NO NUMBER (10) Yes Line number for the transfer
OPM_ITEM_ID NUMBER
Yes OPM item id. joins to ic_item_mst
OPM_WHSE_CODE VARCHAR2 (4) Yes OPM warehouse code. joins to ic_whse_mst
OPM_LOCATION VARCHAR2 (16) Yes OPM location. joins to ic_loct_mst
OPM_LOT_ID NUMBER

OPM lot id. joins to ic_lots_mst
OPM_LOT_EXPIRATION_DATE DATE

Discrete Lot expiration Date
OPM_LOT_STATUS VARCHAR2 (4)
OPM lot status. joins to ic_lots_sts
OPM_GRADE VARCHAR2 (4)
Grade of the OPM lot. joins to qc_grad_mst
OPM_CHARGE_ACCT_ID NUMBER
Yes Charge account id for OPM
OPM_CHARGE_AU_ID NUMBER
Yes Charge accouting unit id for OPM
OPM_REASON_CODE VARCHAR2 (4) Yes Reason code in OPM. joins to sy_reas_mst.
ODM_INV_ORGANIZATION_ID NUMBER
Yes Discrete organization id. joins to mtl_parameters
ODM_ITEM_ID NUMBER
Yes Discrete item id. joins to mtl_system_items
ODM_ITEM_REVISION VARCHAR2 (3)
Discrete item revision
ODM_SUBINVENTORY VARCHAR2 (10) Yes Discrete subinventory
ODM_LOCATOR_ID NUMBER

Discrete locator id
ODM_LOT_NUMBER VARCHAR2 (80)
Discrete Lot numbre
ODM_LOT_EXPIRATION_DATE DATE

Discrete Lot expiration Date
ODM_CHARGE_ACCOUNT_ID NUMBER
Yes Discrete account code combination id
ODM_PERIOD_ID NUMBER
Yes Discrete Period id.
ODM_UNIT_COST NUMBER

Discrete unit cost. Used only for actual costing and when subinventory and item are assets
ODM_REASON_ID NUMBER

Discrete reason id
QUANTITY NUMBER
Yes Total Transaction quantity for the transfer line
QUANTITY_UM VARCHAR2 (4) Yes Transaction UOM
QUANTITY2 NUMBER

Total Transaction quantity in OPM item's secondary UOM
OPM_PRIMARY_QUANTITY NUMBER
Yes Total transaction quantity in OPM item's primary UOM
ODM_PRIMARY_QUANTITY NUMBER
Yes Total transaction quantity in Discrete item's primary UOM
LOT_LEVEL NUMBER
Yes Where lots are defined. 0=Line or item is not lot controlled; 1=lot records in gmi_discrete_transfer_lots
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard flexfield column
ATTRIBUTE1 VARCHAR2 (240)
Standard flexfield column
ATTRIBUTE2 VARCHAR2 (240)
Standard flexfield column
ATTRIBUTE3 VARCHAR2 (240)
Standard flexfield column
ATTRIBUTE4 VARCHAR2 (240)
Standard flexfield column
ATTRIBUTE5 VARCHAR2 (240)
Standard flexfield column
ATTRIBUTE6 VARCHAR2 (240)
Standard flexfield column
ATTRIBUTE7 VARCHAR2 (240)
Standard flexfield column
ATTRIBUTE8 VARCHAR2 (240)
Standard flexfield column
ATTRIBUTE9 VARCHAR2 (240)
Standard flexfield column
ATTRIBUTE10 VARCHAR2 (240)
Standard flexfield column
ATTRIBUTE11 VARCHAR2 (240)
Standard flexfield column
ATTRIBUTE12 VARCHAR2 (240)
Standard flexfield column
ATTRIBUTE13 VARCHAR2 (240)
Standard flexfield column
ATTRIBUTE14 VARCHAR2 (240)
Standard flexfield column
ATTRIBUTE15 VARCHAR2 (240)
Standard flexfield column
ATTRIBUTE16 VARCHAR2 (240)
Standard flexfield column
ATTRIBUTE17 VARCHAR2 (240)
Standard flexfield column
ATTRIBUTE18 VARCHAR2 (240)
Standard flexfield column
ATTRIBUTE19 VARCHAR2 (240)
Standard flexfield column
ATTRIBUTE20 VARCHAR2 (240)
Standard flexfield column
ATTRIBUTE21 VARCHAR2 (240)
Standard flexfield column
ATTRIBUTE22 VARCHAR2 (240)
Standard flexfield column
ATTRIBUTE23 VARCHAR2 (240)
Standard flexfield column
ATTRIBUTE24 VARCHAR2 (240)
Standard flexfield column
ATTRIBUTE25 VARCHAR2 (240)
Standard flexfield column
ATTRIBUTE26 VARCHAR2 (240)
Standard flexfield column
ATTRIBUTE27 VARCHAR2 (240)
Standard flexfield column
ATTRIBUTE28 VARCHAR2 (240)
Standard flexfield column
ATTRIBUTE29 VARCHAR2 (240)
Standard flexfield column
ATTRIBUTE30 VARCHAR2 (240)
Standard flexfield column
CREATED_BY NUMBER
Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER
Yes Standard WHO column
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
DELETE_MARK NUMBER (5) Yes Standard: 0=Active record (default); 1=Marked for (logical) deletion
TEXT_CODE NUMBER

Text code; joins to text table ic_text_hdr
Query Text

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


SELECT TRANSFER_ID
,      LINE_ID
,      LINE_NO
,      OPM_ITEM_ID
,      OPM_WHSE_CODE
,      OPM_LOCATION
,      OPM_LOT_ID
,      OPM_LOT_EXPIRATION_DATE
,      OPM_LOT_STATUS
,      OPM_GRADE
,      OPM_CHARGE_ACCT_ID
,      OPM_CHARGE_AU_ID
,      OPM_REASON_CODE
,      ODM_INV_ORGANIZATION_ID
,      ODM_ITEM_ID
,      ODM_ITEM_REVISION
,      ODM_SUBINVENTORY
,      ODM_LOCATOR_ID
,      ODM_LOT_NUMBER
,      ODM_LOT_EXPIRATION_DATE
,      ODM_CHARGE_ACCOUNT_ID
,      ODM_PERIOD_ID
,      ODM_UNIT_COST
,      ODM_REASON_ID
,      QUANTITY
,      QUANTITY_UM
,      QUANTITY2
,      OPM_PRIMARY_QUANTITY
,      ODM_PRIMARY_QUANTITY
,      LOT_LEVEL
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DELETE_MARK
,      TEXT_CODE
FROM GMI.GMI_DISCRETE_TRANSFER_LINES;

Dependencies

[top of page]

GMI.GMI_DISCRETE_TRANSFER_LINES does not reference any database object

GMI.GMI_DISCRETE_TRANSFER_LINES is referenced by following:

SchemaGMI
ViewGMI_DISCRETE_TRANSFER_LINES#