VIEW: APPS.OEBV_SALES_ORDER_TYPES

Source

View Text - Preformatted

SELECT T.NAME , '_LA:ENFORCE_LINE_PRICES_FLAG:OE_LOOKUPS:YES_NO:MEANING' , '_LA:SHIPMENT_PRIORITY_CODE:OE_LOOKUPS:SHIPMENT_PRIORITY:MEANING' , '_LA:SHIPPING_METHOD_CODE:OE_LOOKUPS:SHIPPING_METHOD:MEANING' , '_LA:FREIGHT_TERMS_CODE:OE_LOOKUPS:FREIGHT_TERMS:MEANING' , '_LA:AGREEMENT_TYPE_CODE:QP_LOOKUPS:QP_AGREEMENT_TYPE:MEANING' , '_LA:AGREEMENT_REQUIRED_FLAG:OE_LOOKUPS:YES_NO:MEANING' , '_LA:INVOICING_CREDIT_METHOD_CODE:AR_LOOKUPS:CREDIT_METHOD_FOR_INSTALLMENTS:MEANING' , '_LA:ACCOUNTING_CREDIT_METHOD_CODE:AR_LOOKUPS:CREDIT_METHOD_FOR_RULES:MEANING' , B.CONVERSION_TYPE_CODE , B.START_DATE_ACTIVE , B.END_DATE_ACTIVE , T.DESCRIPTION , '_LA:ORDER_CATEGORY_CODE:OE_LOOKUPS:ORDER_CATEGORY:MEANING' , '_DF:ONT:OE_ORDER_TYPES:B' , B.CURRENCY_CODE , B.COST_OF_GOODS_SOLD_ACCOUNT , B.PRICE_LIST_ID , B.WAREHOUSE_ID , B.INVOICING_RULE_ID , B.ACCOUNTING_RULE_ID , B.ORG_ID , B.LAST_UPDATE_DATE , B.LAST_UPDATED_BY , B.CREATION_DATE , B.CREATED_BY FROM OE_TRANSACTION_TYPES_SYN B, OE_TRANSACTION_TYPES_TL T WHERE B.TRANSACTION_TYPE_ID = T.TRANSACTION_TYPE_ID AND T.LANGUAGE = userenv('LANG') AND '_SEC:B.ORG_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT T.NAME
, '_LA:ENFORCE_LINE_PRICES_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, '_LA:SHIPMENT_PRIORITY_CODE:OE_LOOKUPS:SHIPMENT_PRIORITY:MEANING'
, '_LA:SHIPPING_METHOD_CODE:OE_LOOKUPS:SHIPPING_METHOD:MEANING'
, '_LA:FREIGHT_TERMS_CODE:OE_LOOKUPS:FREIGHT_TERMS:MEANING'
, '_LA:AGREEMENT_TYPE_CODE:QP_LOOKUPS:QP_AGREEMENT_TYPE:MEANING'
, '_LA:AGREEMENT_REQUIRED_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, '_LA:INVOICING_CREDIT_METHOD_CODE:AR_LOOKUPS:CREDIT_METHOD_FOR_INSTALLMENTS:MEANING'
, '_LA:ACCOUNTING_CREDIT_METHOD_CODE:AR_LOOKUPS:CREDIT_METHOD_FOR_RULES:MEANING'
, B.CONVERSION_TYPE_CODE
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, T.DESCRIPTION
, '_LA:ORDER_CATEGORY_CODE:OE_LOOKUPS:ORDER_CATEGORY:MEANING'
, '_DF:ONT:OE_ORDER_TYPES:B'
, B.CURRENCY_CODE
, B.COST_OF_GOODS_SOLD_ACCOUNT
, B.PRICE_LIST_ID
, B.WAREHOUSE_ID
, B.INVOICING_RULE_ID
, B.ACCOUNTING_RULE_ID
, B.ORG_ID
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
FROM OE_TRANSACTION_TYPES_SYN B
, OE_TRANSACTION_TYPES_TL T
WHERE B.TRANSACTION_TYPE_ID = T.TRANSACTION_TYPE_ID
AND T.LANGUAGE = USERENV('LANG')
AND '_SEC:B.ORG_ID' IS NOT NULL WITH READ ONLY