View: IC_TRAN_PND_VW3

Product:	GMI - Process Manufacturing Inventory
Description:	Selects completed and pending transactions from IC_TRAN_PND.
Implementation/DBA Data:	APPS.IC_TRAN_PND_VW3

View Text

SELECT 0
, PND.WHSE_CODE
, PND.LOT_ID
, PND.LOCATION
, PND.REASON_CODE
, PND.TRANS_DATE
, SUM(PND.TRANS_QTY)
, SUM( PND.TRANS_QTY2)
, PND.QC_GRADE
, PND.LOT_STATUS
, LOT.LOT_NO
, LOT.SUBLOT_NO
, PND.LINE_ID
, PND.ITEM_ID
, 1
FROM IC_TRAN_PND PND
, IC_LOTS_MST LOT
WHERE PND.LOT_ID = LOT.LOT_ID
AND PND.ITEM_ID = LOT.ITEM_ID
AND PND.COMPLETED_IND = 1
AND PND.DELETE_MARK = 0 GROUP BY PND.WHSE_CODE
, PND.LOT_ID
, PND.LOCATION
, PND.REASON_CODE
, PND.TRANS_DATE
, PND.QC_GRADE
, PND.LOT_STATUS
, LOT.LOT_NO
, LOT.SUBLOT_NO
, PND.LINE_ID
, PND.ITEM_ID UNION SELECT TRANS_ID
, PND.WHSE_CODE
, PND.LOT_ID
, PND.LOCATION
, PND.REASON_CODE
, PND.TRANS_DATE
, PND.TRANS_QTY
, PND.TRANS_QTY2
, PND.QC_GRADE
, PND.LOT_STATUS
, LOT.LOT_NO
, LOT.SUBLOT_NO
, PND.LINE_ID
, PND.ITEM_ID
, 0
FROM IC_TRAN_PND PND
, IC_LOTS_MST LOT
WHERE PND.LOT_ID = LOT.LOT_ID
AND PND.ITEM_ID = LOT.ITEM_ID
AND PND.COMPLETED_IND = 0
AND PND.DELETE_MARK = 0

Columns