View: OEFV_SALES_ORDER_TYPES

Product:	ONT - Order Management
Description:	Full BIS Business View for Sales Order Types.
Implementation/DBA Data:	APPS.OEFV_SALES_ORDER_TYPES

View Text

SELECT TYPESTL.NAME
, '_LA:TYPE.ENFORCE_LINE_PRICES_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, '_LA:TYPE.SHIPMENT_PRIORITY_CODE:OE_LOOKUPS:SHIPMENT_PRIORITY:MEANING'
, '_LA:TYPE.SHIPPING_METHOD_CODE:OE_LOOKUPS:SHIPPING_METHOD:MEANING'
, '_LA:TYPE.FREIGHT_TERMS_CODE:OE_LOOKUPS:FREIGHT_TERMS:MEANING'
, '_LA:TYPE.AGREEMENT_TYPE_CODE:QP_LOOKUPS:QP_AGREEMENT_TYPE:MEANING'
, '_LA:TYPE.AGREEMENT_REQUIRED_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, '_LA:TYPE.INVOICING_CREDIT_METHOD_CODE:AR_LOOKUPS:CREDIT_METHOD_FOR_INSTALLMENTS:MEANING'
, '_LA:TYPE.ACCOUNTING_CREDIT_METHOD_CODE:AR_LOOKUPS:CREDIT_METHOD_FOR_RULES:MEANING'
, GCT.USER_CONVERSION_TYPE
, TYPE.START_DATE_ACTIVE
, TYPE.END_DATE_ACTIVE
, TYPESTL.DESCRIPTION
, '_LA:TYPE.ORDER_CATEGORY_CODE:OE_LOOKUPS:ORDER_CATEGORY:MEANING'
, '_DF:ONT:OE_ORDER_TYPES:TYPE'
, CURRENCY.NAME
, '_KF:SQLGL:GL#:GLCOMBO'
, PRICELST.NAME
, WORG.NAME
, WPARA.ORGANIZATION_CODE
, INV_RULE.NAME
, ACCT_RULE.NAME
, ORG.NAME
, PARA.ORGANIZATION_CODE
, TYPE.TRANSACTION_TYPE_ID
, TYPE.CURRENCY_CODE
, TYPE.COST_OF_GOODS_SOLD_ACCOUNT
, TYPE.PRICE_LIST_ID
, TYPE.WAREHOUSE_ID
, TYPE.INVOICING_RULE_ID
, TYPE.ACCOUNTING_RULE_ID
, TYPE.ORG_ID
, TYPE.LAST_UPDATE_DATE
, TYPE.LAST_UPDATED_BY
, TYPE.CREATION_DATE
, TYPE.CREATED_BY
FROM OE_TRANSACTION_TYPES_SYN TYPE
, OE_TRANSACTION_TYPES_TL TYPESTL
, FND_CURRENCIES_TL CURRENCY
, GL_CODE_COMBINATIONS GLCOMBO
, ORG_FREIGHT FREIGHT
, HR_ALL_ORGANIZATION_UNITS WORG
, MTL_PARAMETERS WPARA
, MTL_PARAMETERS PARA
, HR_ALL_ORGANIZATION_UNITS ORG
, RA_RULES ACCT_RULE
, RA_RULES INV_RULE
, QP_LIST_HEADERS_TL PRICELST
, GL_DAILY_CONVERSION_TYPES GCT
WHERE TYPE.INVOICING_RULE_ID = INV_RULE.RULE_ID(+)
AND TYPE.ACCOUNTING_RULE_ID = ACCT_RULE.RULE_ID(+)
AND TYPE.CURRENCY_CODE = CURRENCY.CURRENCY_CODE(+)
AND CURRENCY.LANGUAGE (+) = USERENV('LANG')
AND TYPE.COST_OF_GOODS_SOLD_ACCOUNT = GLCOMBO.CODE_COMBINATION_ID(+)
AND TYPE.PRICE_LIST_ID = PRICELST.LIST_HEADER_ID(+)
AND PRICELST.LANGUAGE (+) = USERENV('LANG')
AND TYPE.WAREHOUSE_ID = WORG.ORGANIZATION_ID(+)
AND TYPE.WAREHOUSE_ID = WPARA.ORGANIZATION_ID(+)
AND TYPE.SHIPPING_METHOD_CODE = FREIGHT.FREIGHT_CODE(+)
AND TYPE.WAREHOUSE_ID = FREIGHT.ORGANIZATION_ID(+)
AND TYPE.ORG_ID = PARA.ORGANIZATION_ID(+)
AND TYPE.ORG_ID = ORG.ORGANIZATION_ID(+)
AND TYPE.CONVERSION_TYPE_CODE = GCT.CONVERSION_TYPE(+)
AND TYPE.TRANSACTION_TYPE_ID = TYPESTL.TRANSACTION_TYPE_ID
AND TYPESTL.LANGUAGE = USERENV('LANG')
AND '_SEC:TYPE.ORG_ID' IS NOT NULL WITH READ ONLY

Columns