eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: OP_ORDR_TYP_VL

Product:	GML - Process Manufacturing Logistics
Description:	Order type view
Implementation/DBA Data:	APPS.OP_ORDR_TYP_VL

View Text

SELECT B.ROWID ROW_ID
, B.ORDER_TYPE
, T.LANGUAGE
, B.INVEN_TRANS_TYPE
, B.SHIPMENT_IND
, B.INVOICE_IND
, B.PICKINGLST_IND
, B.EXPORTDOC_IND
, B.TOTALORD_IND
, B.UPDATE_SALESHIST
, B.CREDITCHK_TYPE
, B.PRICE_ORDER
, B.CALC_COMM_IND
, B.CALC_TAX_IND
, B.PRODORDR_IND
, B.SHIPTO_REQUIRED
, B.UPDATE_AUDITTRAIL
, B.ORDER_LEADTIME
, B.CREATED_BY
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.TRANS_CNT
, B.TEXT_CODE
, B.DELETE_MARK
, T.ORDER_TYPE_CODE
, T.ORDER_TYPE_DESC
FROM OP_ORDR_TYP_TL T
, OP_ORDR_TYP_B B
WHERE B.ORDER_TYPE = T.ORDER_TYPE
AND T.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
ORDER_TYPE
LANG_CODE
INVEN_TRANS_TYPE
SHIPMENT_IND
INVOICE_IND
PICKINGLST_IND
EXPORTDOC_IND
TOTALORD_IND
UPDATE_SALESHIST
CREDITCHK_TYPE
PRICE_ORDER
CALC_COMM_IND
CALC_TAX_IND
PRODORDR_IND
SHIPTO_REQUIRED
UPDATE_AUDITTRAIL
ORDER_LEADTIME
CREATED_BY
LAST_UPDATED_BY
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
TRANS_CNT
TEXT_CODE
DELETE_MARK
ORDER_TYPE_CODE
ORDER_TYPE_DESC