VIEW: APPS.GML_GPOAO_ORDER_TEXT_V

Source

View Text - Preformatted

SELECT oh.order_id ORDER_ID, lang_code LANG_CODE_INT, paragraph_code PARA_CODE_INT, sub_paracode SUB_PARACODE, line_no LINE_NO, text TEXT FROM op_text_tbl tt, op_ordr_hdr oh WHERE oh.text_code = tt.text_code AND oh.delete_mark = 0 AND oh.order_status != -1

View Text - HTML Formatted

SELECT OH.ORDER_ID ORDER_ID
, LANG_CODE LANG_CODE_INT
, PARAGRAPH_CODE PARA_CODE_INT
, SUB_PARACODE SUB_PARACODE
, LINE_NO LINE_NO
, TEXT TEXT
FROM OP_TEXT_TBL TT
, OP_ORDR_HDR OH
WHERE OH.TEXT_CODE = TT.TEXT_CODE
AND OH.DELETE_MARK = 0
AND OH.ORDER_STATUS != -1