[Home] [Help]
View: GML_GPOAO_ORDER_TEXT_V
Product: | GML - Process Manufacturing Logistics |
Description: | Sales Order Header Text view |
Implementation/DBA Data: |
APPS.GML_GPOAO_ORDER_TEXT_V
|
View Text
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
Columns
Name |
ORDER_ID |
LANG_CODE_INT |
PARA_CODE_INT |
SUB_PARACODE |
LINE_NO |
TEXT |