View: OEFV_SALES_ORDER_TYPES

Product:	OE - Order Entry
Description:	- Retrofitted
Implementation/DBA Data:	APPS.OEFV_SALES_ORDER_TYPES

View Text

SELECT TYPE.NAME
, '_LA:TYPE.ENFORCE_PRICE_LIST_FLAG:SO_LOOKUPS:YES_NO:MEANING'
, '_LA:TYPE.ENFORCE_LINE_PRICES_FLAG:SO_LOOKUPS:YES_NO:MEANING'
, '_LA:TYPE.SHIPMENT_PRIORITY_CODE:SO_LOOKUPS:SHIPMENT_PRIORITY:MEANING'
, '_LA:TYPE.SHIP_METHOD_CODE:SO_LOOKUPS:SHIPPING_METHOD:MEANING'
, '_LA:TYPE.FREIGHT_TERMS_CODE:SO_LOOKUPS:FREIGHT_TERMS:MEANING'
, '_LA:TYPE.AGREEMENT_TYPE_CODE:SO_LOOKUPS:AGREEMENT_TYPE:MEANING'
, '_LA:TYPE.AGREEMENT_REQUIRED_FLAG:SO_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
, TYPE.DESCRIPTION
, '_LA:TYPE.ORDER_CATEGORY_CODE:SO_LOOKUPS:ORDER_CATEGORY:MEANING'
, '_DF:OE:SO_ORDER_TYPES:TYPE'
, CYCLE.NAME
, 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.ORDER_TYPE_ID
, TYPE.CYCLE_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 SO_ORDER_TYPES_ALL TYPE
, SO_CYCLES CYCLE
, FND_CURRENCIES_VL 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
, SO_PRICE_LISTS PRICELST
, GL_DAILY_CONVERSION_TYPES GCT
WHERE TYPE.CYCLE_ID = CYCLE.CYCLE_ID
AND TYPE.INVOICING_RULE_ID = ACCT_RULE.RULE_ID(+)
AND TYPE.ACCOUNTING_RULE_ID = INV_RULE.RULE_ID(+)
AND TYPE.CURRENCY_CODE = CURRENCY.CURRENCY_CODE(+)
AND TYPE.COST_OF_GOODS_SOLD_ACCOUNT = GLCOMBO.CODE_COMBINATION_ID(+)
AND TYPE.PRICE_LIST_ID = PRICELST.PRICE_LIST_ID(+)
AND TYPE.WAREHOUSE_ID = WORG.ORGANIZATION_ID(+)
AND TYPE.WAREHOUSE_ID = WPARA.ORGANIZATION_ID(+)
AND TYPE.SHIP_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(+) WITH READ ONLY

Columns