VIEW: APPS.GMI_XFER_MST_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)