VIEW: APPS.OE_AK_ORDER_TYPES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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