[Home] [Help]
View: GML_GASNO_SHIPMENT_TEXT_V
View Text
SELECT BL.BOL_ID BOL_ID
, TT.LANG_CODE LANG_CODE_INT
, TT.PARAGRAPH_CODE PARA_CODE_INT
, TT.SUB_PARACODE SUB_PARACODE
, TT.LINE_NO LINE_NO
, TT.TEXT TEXT
FROM OP_TEXT_TBL TT
, OP_BILL_LAD BL
WHERE BL.TEXT_CODE = TT.TEXT_CODE
AND BL.DELETE_MARK = 0
Columns
Name |
BOL_ID |
LANG_CODE_INT |
PARA_CODE_INT |
SUB_PARACODE |
LINE_NO |
TEXT |