View: IC_TRAN_PND_VW2

Product:	GMI - Process Manufacturing Inventory
Description:	Selects transactions summaries for items from IC_TRAN_PND.
Implementation/DBA Data:	APPS.IC_TRAN_PND_VW2

View Text

SELECT PND.WHSE_CODE
, PND.LOT_ID
, PND.LOCATION
, PND.REASON_CODE
, PND.TRANS_DATE
, SUM(PND.TRANS_QTY)
, SUM( PND.TRANS_QTY2)
, PND.TRANS_UM
, PND.TRANS_UM2
, PND.QC_GRADE
, PND.LOT_STATUS
, LOT.LOT_NO
, LOT.SUBLOT_NO
, PND.LINE_ID
, PND.ITEM_ID
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.ITEM_ID
, PND.TRANS_DATE
, LOT.LOT_NO
, LOT.SUBLOT_NO
, PND.WHSE_CODE
, PND.LOCATION
, PND.LOT_ID
, PND.REASON_CODE
, PND.TRANS_UM
, PND.TRANS_UM2
, PND.QC_GRADE
, PND.LOT_STATUS
, PND.LINE_ID

Columns