View: GML_GPOAO_DETAIL_ALLOCATIONS_V

Product:	GML - Process Manufacturing Logistics
Description:	Sales Order Detail Allocations view
Implementation/DBA Data:	APPS.GML_GPOAO_DETAIL_ALLOCATIONS_V

View Text

SELECT TP.LINE_ID LINE_ID
, TP.TRANS_ID TRANS_ID
, LM.LOT_NO LOT_NO
, LM.VENDOR_LOT_NO VENDOR_LOT_NO
, LM.SUBLOT_NO SUBLOT_NO
, LM.LOT_DESC LOT_DESCRIPTION
, TP.LOT_STATUS LOT_STATUS
, LS.STATUS_DESC STATUS_DESC
, TP.LOCATION LOCATION
, LCM.LOCT_DESC LOCT_DESC
, LM.QC_GRADE QC_GRADE
, GM.QC_GRADE_DESC QC_GRADE_DESC
, TP.REASON_CODE REASON_CODE
, LM.LOT_CREATED LOT_CREATED
, LM.EXPIRE_DATE EXPIRE_DATE
, TP.TRANS_QTY QUANTITY1
, TP.TRANS_UM UOM1_INT
, TP.TRANS_QTY2 QUANTITY2
, TP.TRANS_UM2 UOM2_INT
FROM IC_TRAN_PND TP
, IC_LOTS_MST LM
, IC_LOTS_STS LS
, IC_LOCT_MST LCM
, QC_GRAD_MST GM
WHERE TP.DOC_TYPE = 'OPSO'
AND TP.DELETE_MARK = 0
AND LM.LOT_ID = TP.LOT_ID
AND TP.LOT_ID != 0
AND LS.LOT_STATUS (+) = TP.LOT_STATUS
AND LCM.LOCATION = TP.LOCATION
AND LCM.WHSE_CODE = TP.WHSE_CODE
AND GM.QC_GRADE (+) = TP.QC_GRADE
AND TP.LOT_ID = LM.LOT_ID

Columns