VIEW: APPS.GML_GASNO_SHIPMENT_TEXT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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