VIEW: APPS.GML_GASNO_DETAIL_ALLOCATIONS_V

Source

View Text - Preformatted

SELECT tp.line_id LINE_ID, tp.trans_id TRANS_ID, lm.lot_no LOT_NO, lm.vendor_lot_no VENDOR_LOT_NO, lm.sublot_no SUBLOT_NO, lm.lot_desc LOT_DESCRIPTION, tp.lot_status LOT_STATUS, ls.status_desc STATUS_DESC, tp.location LOCATION, lcm.loct_desc LOCT_DESC, lm.qc_grade QC_GRADE, gm.qc_grade_desc QC_GRADE_DESC, tp.reason_code REASON_CODE, lm.lot_created LOT_CREATED, lm.expire_date EXPIRE_DATE, tp.trans_qty QUANTITY1, tp.trans_um UOM1_INT, tp.trans_qty2 QUANTITY2, tp.trans_um2 UOM2_INT FROM ic_tran_pnd tp, ic_lots_mst lm, ic_lots_sts ls, ic_loct_mst lcm, qc_grad_mst gm, op_ordr_dtl od WHERE tp.doc_type = 'OPSO' AND tp.delete_mark = 0 AND lm.lot_id != 0 AND od.item_id = lm.item_id AND ls.lot_status (+) = tp.lot_status AND lcm.location (+) = tp.location AND lcm.whse_code = tp.whse_code AND gm.qc_grade (+) = tp.qc_grade AND od.line_id = tp.line_id AND tp.doc_id = od.order_id AND tp.lot_id = lm.lot_id

View Text - HTML Formatted

SELECT TP.LINE_ID LINE_ID
, TP.TRANS_ID TRANS_ID
, LM.LOT_NO LOT_NO
, LM.VENDOR_LOT_NO VENDOR_LOT_NO
, LM.SUBLOT_NO SUBLOT_NO
, LM.LOT_DESC LOT_DESCRIPTION
, TP.LOT_STATUS LOT_STATUS
, LS.STATUS_DESC STATUS_DESC
, TP.LOCATION LOCATION
, LCM.LOCT_DESC LOCT_DESC
, LM.QC_GRADE QC_GRADE
, GM.QC_GRADE_DESC QC_GRADE_DESC
, TP.REASON_CODE REASON_CODE
, LM.LOT_CREATED LOT_CREATED
, LM.EXPIRE_DATE EXPIRE_DATE
, TP.TRANS_QTY QUANTITY1
, TP.TRANS_UM UOM1_INT
, TP.TRANS_QTY2 QUANTITY2
, TP.TRANS_UM2 UOM2_INT
FROM IC_TRAN_PND TP
, IC_LOTS_MST LM
, IC_LOTS_STS LS
, IC_LOCT_MST LCM
, QC_GRAD_MST GM
, OP_ORDR_DTL OD
WHERE TP.DOC_TYPE = 'OPSO'
AND TP.DELETE_MARK = 0
AND LM.LOT_ID != 0
AND OD.ITEM_ID = LM.ITEM_ID
AND LS.LOT_STATUS (+) = TP.LOT_STATUS
AND LCM.LOCATION (+) = TP.LOCATION
AND LCM.WHSE_CODE = TP.WHSE_CODE
AND GM.QC_GRADE (+) = TP.QC_GRADE
AND OD.LINE_ID = TP.LINE_ID
AND TP.DOC_ID = OD.ORDER_ID
AND TP.LOT_ID = LM.LOT_ID