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