VIEW: APPS.IC_TRAN_PND_VW3

Source

View Text - Preformatted

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

View Text - HTML Formatted

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