VIEW: APPS.OP_ORDR_TYP_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')