View: GML_GASNO_DETAIL_TEXT_V

Product:	GML - Process Manufacturing Logistics
Description:	Sales Order Detail Text view
Implementation/DBA Data:	APPS.GML_GASNO_DETAIL_TEXT_V

View Text

SELECT OD.LINE_ID LINE_ID
, TT.TEXT_CODE TEXT_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_ORDR_DTL OD
WHERE OD.TEXT_CODE = TT.TEXT_CODE
AND OD.DELETE_MARK = 0
AND OD.LINE_STATUS != -1

Columns