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


VIEW: APPS.GMI_XFER_MST_V

Object Details
Object Name: GMI_XFER_MST_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMI.GMI_XFER_MST_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view is used to populate the Inventory Transfer form. Its primary base table is ic_xfer_mst.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
TRANSFER_ID NUMBER
Yes
TRANSFER_NO VARCHAR2 (32) Yes
TRANSFER_BATCH VARCHAR2 (50)
ORGN_CODE VARCHAR2 (4) Yes
TRANSFER_STATUS VARCHAR2 (1) Yes
ITEM_ID NUMBER
Yes
LOT_ID NUMBER
Yes
LOT_STATUS VARCHAR2 (4)
RELEASE_REASON_CODE VARCHAR2 (4)
RECEIVE_REASON_CODE VARCHAR2 (4)
CANCEL_REASON_CODE VARCHAR2 (4)
FROM_WAREHOUSE VARCHAR2 (4) Yes
FROM_LOCATION VARCHAR2 (16)
TO_WAREHOUSE VARCHAR2 (4) Yes
TO_LOCATION VARCHAR2 (16)
RELEASE_QUANTITY1 NUMBER
Yes
RELEASE_QUANTITY2 NUMBER

RECEIVE_QUANTITY1 NUMBER
Yes
RECEIVE_QUANTITY2 NUMBER

SCHEDULED_RELEASE_DATE DATE

ACTUAL_RELEASE_DATE DATE

SCHEDULED_RECEIVE_DATE DATE

ACTUAL_RECEIVE_DATE DATE

CANCEL_DATE DATE

ATTRIBUTE1 VARCHAR2 (240)
ATTRIBUTE2 VARCHAR2 (240)
ATTRIBUTE3 VARCHAR2 (240)
ATTRIBUTE4 VARCHAR2 (240)
ATTRIBUTE5 VARCHAR2 (240)
ATTRIBUTE6 VARCHAR2 (240)
ATTRIBUTE7 VARCHAR2 (240)
ATTRIBUTE8 VARCHAR2 (240)
ATTRIBUTE9 VARCHAR2 (240)
ATTRIBUTE10 VARCHAR2 (240)
ATTRIBUTE11 VARCHAR2 (240)
ATTRIBUTE12 VARCHAR2 (240)
ATTRIBUTE13 VARCHAR2 (240)
ATTRIBUTE14 VARCHAR2 (240)
ATTRIBUTE15 VARCHAR2 (240)
ATTRIBUTE16 VARCHAR2 (240)
ATTRIBUTE17 VARCHAR2 (240)
ATTRIBUTE18 VARCHAR2 (240)
ATTRIBUTE19 VARCHAR2 (240)
ATTRIBUTE20 VARCHAR2 (240)
ATTRIBUTE21 VARCHAR2 (240)
ATTRIBUTE22 VARCHAR2 (240)
ATTRIBUTE23 VARCHAR2 (240)
ATTRIBUTE24 VARCHAR2 (240)
ATTRIBUTE25 VARCHAR2 (240)
ATTRIBUTE26 VARCHAR2 (240)
ATTRIBUTE27 VARCHAR2 (240)
ATTRIBUTE28 VARCHAR2 (240)
ATTRIBUTE29 VARCHAR2 (240)
ATTRIBUTE30 VARCHAR2 (240)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
DELETE_MARK NUMBER (5) Yes
RECEIVED_BY NUMBER

RELEASED_BY NUMBER

CANCELED_BY NUMBER

TEXT_CODE NUMBER (10)
COMMENTS VARCHAR2 (2000)
ITEM_NO VARCHAR2 (32) Yes
ITEM_DESC1 VARCHAR2 (70) Yes
ITEM_UM VARCHAR2 (4) Yes
ITEM_UM2 VARCHAR2 (4)
LOT_CTL NUMBER (5) Yes
LOT_INDIVISIBLE NUMBER (5) Yes
SUBLOT_CTL NUMBER (5) Yes
LOCT_CTL NUMBER (5) Yes
DUALUM_IND NUMBER (5) Yes
DEVIATION_LO NUMBER
Yes
DEVIATION_HI NUMBER
Yes
LOT_NO VARCHAR2 (32)
SUBLOT_NO VARCHAR2 (32)
LOT_STATUS_DESCRIPTION VARCHAR2 (40)
QC_GRADE VARCHAR2 (4)
QC_GRADE_DESCRIPTION VARCHAR2 (40)
FROM_WHSE_NAME VARCHAR2 (40) Yes
FROM_WHSE_LOCT_CTL NUMBER (5) Yes
TO_WHSE_NAME VARCHAR2 (40) Yes
TO_WHSE_LOCT_CTL NUMBER (5) Yes
RELEASE_REASON_CODE_DESC VARCHAR2 (40)
RECEIVE_REASON_CODE_DESC VARCHAR2 (40)
CANCEL_REASON_CODE_DESC VARCHAR2 (40)
RELEASER_USER_NAME VARCHAR2 (100)
RECEIVER_USER_NAME VARCHAR2 (100)
CANCELLER_USER_NAME VARCHAR2 (100)
Query Text

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


SELECT ROW_ID
,      TRANSFER_ID
,      TRANSFER_NO
,      TRANSFER_BATCH
,      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
,      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
,      LAST_UPDATE_LOGIN
,      DELETE_MARK
,      RECEIVED_BY
,      RELEASED_BY
,      CANCELED_BY
,      TEXT_CODE
,      COMMENTS
,      ITEM_NO
,      ITEM_DESC1
,      ITEM_UM
,      ITEM_UM2
,      LOT_CTL
,      LOT_INDIVISIBLE
,      SUBLOT_CTL
,      LOCT_CTL
,      DUALUM_IND
,      DEVIATION_LO
,      DEVIATION_HI
,      LOT_NO
,      SUBLOT_NO
,      LOT_STATUS_DESCRIPTION
,      QC_GRADE
,      QC_GRADE_DESCRIPTION
,      FROM_WHSE_NAME
,      FROM_WHSE_LOCT_CTL
,      TO_WHSE_NAME
,      TO_WHSE_LOCT_CTL
,      RELEASE_REASON_CODE_DESC
,      RECEIVE_REASON_CODE_DESC
,      CANCEL_REASON_CODE_DESC
,      RELEASER_USER_NAME
,      RECEIVER_USER_NAME
,      CANCELLER_USER_NAME
FROM APPS.GMI_XFER_MST_V;

Dependencies

[top of page]

APPS.GMI_XFER_MST_V references the following:

SchemaAPPS
SynonymFND_USER
SynonymIC_ITEM_MST
SynonymIC_LOTS_MST
SynonymIC_LOTS_STS
SynonymIC_WHSE_MST
SynonymIC_XFER_MST
SynonymQC_GRAD_MST
SynonymSY_REAS_CDS

APPS.GMI_XFER_MST_V is not referenced by any database object