[Home] [Help]
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
Name |
TRANS_ID |
WHSE_CODE |
LOT_ID |
LOCATION |
REASON_CODE |
TRANS_DATE |
SUM_TRANS_QTY |
SUM_TRANS_QTY2 |
QC_GRADE |
LOT_STATUS |
LOT_NO |
SUBLOT_NO |
LINE_ID |
ITEM_ID |
PND_CMP |