eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: OE_AK_ORDER_TYPES_V

Product:	ONT - Order Management
Description:
Implementation/DBA Data:	APPS.OE_AK_ORDER_TYPES_V

View Text

SELECT B.TRANSACTION_TYPE_ID
, B.ORDER_CATEGORY_CODE
, B.CURRENCY_CODE
, B.CONVERSION_TYPE_CODE
, B.CUST_TRX_TYPE_ID
, B.COST_OF_GOODS_SOLD_ACCOUNT
, B.PRICE_LIST_ID
, B.WAREHOUSE_ID
, B.DEMAND_CLASS_CODE
, B.SHIPMENT_PRIORITY_CODE
, B.SHIPPING_METHOD_CODE
, B.FREIGHT_TERMS_CODE
, B.FOB_POINT_CODE
, B.AGREEMENT_TYPE_CODE
, B.INVOICING_RULE_ID
, B.INVOICING_CREDIT_METHOD_CODE
, B.ACCOUNTING_RULE_ID
, B.ACCOUNTING_CREDIT_METHOD_CODE
, B.INVOICE_SOURCE_ID
, B.NON_DELIVERY_INVOICE_SOURCE_ID
, B.DEFAULT_INBOUND_LINE_TYPE_ID
, B.DEFAULT_OUTBOUND_LINE_TYPE_ID
, B.SCHEDULING_LEVEL_CODE
, B.DEFAULT_FULFILLMENT_SET
, B.DEFAULT_LINE_SET_CODE
, ' '
, DEF_TRANSACTION_PHASE_CODE
FROM OE_ORDER_TYPES_V B

Columns

Name
ORDER_TYPE_ID
ORDER_CATEGORY_CODE
CURRENCY_CODE
CONVERSION_TYPE_CODE
CUST_TRX_TYPE_ID
COST_OF_GOODS_SOLD_ACCOUNT
PRICE_LIST_ID
SHIP_FROM_ORG_ID
DEMAND_CLASS_CODE
SHIPMENT_PRIORITY_CODE
SHIPPING_METHOD_CODE
FREIGHT_TERMS_CODE
FOB_POINT_CODE
AGREEMENT_TYPE_CODE
INVOICING_RULE_ID
INVOICING_CREDIT_METHOD_CODE
ACCOUNTING_RULE_ID
ACCOUNTING_CREDIT_METHOD_CODE
INVOICE_SOURCE_ID
NON_DELIVERY_INVOICE_SOURCE_ID
DEFAULT_INBOUND_LINE_TYPE_ID
DEFAULT_OUTBOUND_LINE_TYPE_ID
SCHEDULING_LEVEL_CODE
DEFAULT_FULFILLMENT_SET
DEFAULT_LINE_SET_CODE
ORDER_NUMBER_SOURCE_ID
DEF_TRANSACTION_PHASE_CODE