Product: | GMI - Process Manufacturing Inventory |
---|---|
Description: | This view is used to populate the Inventory Transfer form. Its primary base table is ic_xfer_mst. |
Implementation/DBA Data: | APPS.GMI_XFER_MST_V |
SELECT XFER.ROWID ROW_ID
, XFER.TRANSFER_ID
, XFER.TRANSFER_NO
, XFER.TRANSFER_BATCH
, XFER.ORGN_CODE
, XFER.TRANSFER_STATUS
, XFER.ITEM_ID
, XFER.LOT_ID
, XFER.LOT_STATUS
, XFER.RELEASE_REASON_CODE
, XFER.RECEIVE_REASON_CODE
, XFER.CANCEL_REASON_CODE
, XFER.FROM_WAREHOUSE
, XFER.FROM_LOCATION
, XFER.TO_WAREHOUSE
, XFER.TO_LOCATION
, XFER.RELEASE_QUANTITY1
, XFER.RELEASE_QUANTITY2
, XFER.RECEIVE_QUANTITY1
, XFER.RECEIVE_QUANTITY2
, XFER.SCHEDULED_RELEASE_DATE
, XFER.ACTUAL_RELEASE_DATE
, XFER.SCHEDULED_RECEIVE_DATE
, XFER.ACTUAL_RECEIVE_DATE
, XFER.CANCEL_DATE
, XFER.ATTRIBUTE1
, XFER.ATTRIBUTE2
, XFER.ATTRIBUTE3
, XFER.ATTRIBUTE4
, XFER.ATTRIBUTE5
, XFER.ATTRIBUTE6
, XFER.ATTRIBUTE7
, XFER.ATTRIBUTE8
, XFER.ATTRIBUTE9
, XFER.ATTRIBUTE10
, XFER.ATTRIBUTE11
, XFER.ATTRIBUTE12
, XFER.ATTRIBUTE13
, XFER.ATTRIBUTE14
, XFER.ATTRIBUTE15
, XFER.ATTRIBUTE16
, XFER.ATTRIBUTE17
, XFER.ATTRIBUTE18
, XFER.ATTRIBUTE19
, XFER.ATTRIBUTE20
, XFER.ATTRIBUTE21
, XFER.ATTRIBUTE22
, XFER.ATTRIBUTE23
, XFER.ATTRIBUTE24
, XFER.ATTRIBUTE25
, XFER.ATTRIBUTE26
, XFER.ATTRIBUTE27
, XFER.ATTRIBUTE28
, XFER.ATTRIBUTE29
, XFER.ATTRIBUTE30
, XFER.ATTRIBUTE_CATEGORY
, XFER.CREATED_BY
, XFER.CREATION_DATE
, XFER.LAST_UPDATED_BY
, XFER.LAST_UPDATE_DATE
, XFER.LAST_UPDATE_LOGIN
, XFER.DELETE_MARK
, XFER.RECEIVED_BY
, XFER.RELEASED_BY
, XFER.CANCELED_BY
, XFER.TEXT_CODE
, XFER.COMMENTS
, ITEM.ITEM_NO
, ITEM.ITEM_DESC1
, ITEM.ITEM_UM
, ITEM.ITEM_UM2
, ITEM.LOT_CTL
, ITEM.LOT_INDIVISIBLE
, ITEM.SUBLOT_CTL
, ITEM.LOCT_CTL
, ITEM.DUALUM_IND
, ITEM.DEVIATION_LO
, ITEM.DEVIATION_HI
, LOT.LOT_NO
, LOT.SUBLOT_NO
, LOT_STAT.STATUS_DESC
, LOT.QC_GRADE
, GRADE.QC_GRADE_DESC
, FWAREHOUSE.WHSE_NAME
, FWAREHOUSE.LOCT_CTL
, TWAREHOUSE.WHSE_NAME
, TWAREHOUSE.LOCT_CTL
, RELREASON.REASON_DESC1
, RECREASON.REASON_DESC1
, CANREASON.REASON_DESC1
, RELUSER.USER_NAME RELEASER_USER_NAME
, RECUSER.USER_NAME RECEIVER_USER_NAME
, CANUSER.USER_NAME CANCELLER_USER_NAME
FROM IC_XFER_MST XFER
, IC_ITEM_MST ITEM
, IC_LOTS_MST LOT
, IC_WHSE_MST FWAREHOUSE
, IC_WHSE_MST TWAREHOUSE
, IC_LOTS_STS LOT_STAT
, QC_GRAD_MST GRADE
, SY_REAS_CDS RELREASON
, SY_REAS_CDS RECREASON
, SY_REAS_CDS CANREASON
, FND_USER RELUSER
, FND_USER RECUSER
, FND_USER CANUSER
WHERE XFER.ITEM_ID = ITEM.ITEM_ID
AND XFER.LOT_ID = LOT.LOT_ID(+)
AND XFER.ITEM_ID = LOT.ITEM_ID(+)
AND XFER.LOT_STATUS = LOT_STAT.LOT_STATUS(+)
AND LOT.QC_GRADE = GRADE.QC_GRADE(+)
AND XFER.FROM_WAREHOUSE = FWAREHOUSE.WHSE_CODE
AND XFER.TO_WAREHOUSE = TWAREHOUSE.WHSE_CODE
AND XFER.RELEASE_REASON_CODE = RELREASON.REASON_CODE(+)
AND XFER.RECEIVE_REASON_CODE = RECREASON.REASON_CODE(+)
AND XFER.CANCEL_REASON_CODE = CANREASON.REASON_CODE(+)
AND XFER.RELEASED_BY = RELUSER.USER_ID(+)
AND XFER.RECEIVED_BY = RECUSER.USER_ID(+)
AND XFER.CANCELED_BY = CANUSER.USER_ID(+)