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_XFER_MST

Object Details

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

Inventory transfer master

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IC_XFER_MST_I1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSFER_BATCH ORGN_CODE TRANSFER_NO
IC_XFER_MST_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSFER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSFER_ID	NUMBER		Yes	Generated Number Surrogate ID for the Transfer Table. Doc ID to be used on transactions.
TRANSFER_NO	VARCHAR2	(32)	Yes	Document Number for the Transfer.
ORGN_CODE	VARCHAR2	(4)	Yes	Organization Code for which the Transfer was Created
TRANSFER_STATUS	VARCHAR2	(1)	Yes	Status of the Transfer. Values are 1 = PENDING 2 = IN-TRANSIT 3 = COMPLETE 4 - DELETED 5 = CANCELED
ITEM_ID	NUMBER		Yes	Surrogate key for the item that is transferred
LOT_ID	NUMBER		Yes	Surrogate key for the Lot that is transferred
LOT_STATUS	VARCHAR2	(4)		Status of the Lot
RELEASE_REASON_CODE	VARCHAR2	(4)		Reason Code associated with a Release of this Transfer
RECEIVE_REASON_CODE	VARCHAR2	(4)		Reason Code associated with a Receive of this Transfer.
CANCEL_REASON_CODE	VARCHAR2	(4)		Reason Code associated with a Cancel of this Transfer
FROM_WAREHOUSE	VARCHAR2	(4)	Yes	Warehouse the transfer is originating from
FROM_LOCATION	VARCHAR2	(16)		Location the transfer is originating from
TO_WAREHOUSE	VARCHAR2	(4)	Yes	Warehouse the transfer is to be received at.
TO_LOCATION	VARCHAR2	(16)		Location the transfer is to be received at.
RELEASE_QUANTITY1	NUMBER		Yes	Primary Quantity that will be Transferred.
RELEASE_QUANTITY2	NUMBER			Secondary Quantity that will be Transferred.
RELEASE_UOM1	VARCHAR2	(4)	Yes	Primary Unit of Measure for the Transfer Item
RELEASE_UOM2	VARCHAR2	(4)		Secondary Unit of Measure for the Transfer Item
RECEIVE_QUANTITY1	NUMBER		Yes	Primary Quantity that was received by this transfer.
RECEIVE_QUANTITY2	NUMBER			Secondary Quantity that was received by this transfer.
SCHEDULED_RELEASE_DATE	DATE			Date the transfer is scheduled to be Released
ACTUAL_RELEASE_DATE	DATE			Date the transer is actually Released
SCHEDULED_RECEIVE_DATE	DATE			Date the transfer is scheduled to be Received.
ACTUAL_RECEIVE_DATE	DATE			Date of the transfer is actually received
CANCEL_DATE	DATE			Date the transfer is actually Canceled
ATTRIBUTE1	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE2	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE3	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE4	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE5	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE6	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE7	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE8	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE9	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE10	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE11	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE12	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE13	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE14	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE15	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE16	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE17	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE18	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE19	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE20	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE21	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE22	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE23	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE24	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE25	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE26	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE27	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE28	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE29	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE30	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Segment
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
DELETE_MARK	NUMBER	(5)	Yes	Standard delete Mark
RECEIVED_BY	NUMBER			Surrogate ID of the User who performed a Receive action on this transfer.
RELEASED_BY	NUMBER			Surrogate ID of the User who performed a Release actin on this transfer.
CANCELED_BY	NUMBER			Surrogate ID of the User who performed a Cancel action on this transfer
TEXT_CODE	NUMBER	(10)		Text code
COMMENTS	VARCHAR2	(2000)		Freeform Text to document the transfer
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
TRANSFER_BATCH	VARCHAR2	(50)		Used to group transfers that the user arbitrairily feels belong together. This field is not edited for any particular value set.

Query Text

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


SELECT TRANSFER_ID
,      TRANSFER_NO
,      ORGN_CODE
,      TRANSFER_STATUS
,      ITEM_ID
,      LOT_ID
,      LOT_STATUS
,      RELEASE_REASON_CODE
,      RECEIVE_REASON_CODE
,      CANCEL_REASON_CODE
,      FROM_WAREHOUSE
,      FROM_LOCATION
,      TO_WAREHOUSE
,      TO_LOCATION
,      RELEASE_QUANTITY1
,      RELEASE_QUANTITY2
,      RELEASE_UOM1
,      RELEASE_UOM2
,      RECEIVE_QUANTITY1
,      RECEIVE_QUANTITY2
,      SCHEDULED_RELEASE_DATE
,      ACTUAL_RELEASE_DATE
,      SCHEDULED_RECEIVE_DATE
,      ACTUAL_RECEIVE_DATE
,      CANCEL_DATE
,      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
,      ATTRIBUTE_CATEGORY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      DELETE_MARK
,      RECEIVED_BY
,      RELEASED_BY
,      CANCELED_BY
,      TEXT_CODE
,      COMMENTS
,      LAST_UPDATE_LOGIN
,      TRANSFER_BATCH
FROM GMI.IC_XFER_MST;

Dependencies

[top of page]

GMI.IC_XFER_MST does not reference any database object

GMI.IC_XFER_MST is referenced by following:

GMI: IC_XFER_MST#