FND Design Data [Home] [Help]

View: OEBV_SALES_ORDER_TYPES

Product: ONT - Order Management
Description: Base BIS Business View for Sales Order Types.
Implementation/DBA Data: ViewAPPS.OEBV_SALES_ORDER_TYPES
View Text

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

Columns

Name
ORDER_TYPE_NAME
"_LA:ENFORCE_LINE_PRICES"
"_LA:SHIPMENT_PRIORITY"
"_LA:SHIPPING_METHOD"
"_LA:FREIGHT_TERMS"
"_LA:AGREEMENT_TYPE"
"_LA:AGREEMENT_REQUIRED"
"_LA:INVOICING_CREDIT_METHOD"
"_LA:ACCOUNTING_CREDIT_METHOD"
CONVERSION_TYPE_CODE
START_DATE
END_DATE
DESCRIPTION
"_LA:ORDER_CATEGORY"
"_DF"
CURRENCY_CODE
COST_OF_SALES_ACCOUNT_ID
PRICE_LIST_ID
WAREHOUSE_ID
INVOICING_RULE_ID
ACCOUNTING_RULE_ID
ORG_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY