VIEW: OE.SO_ORDER_TYPES_115_ALL#

Source

View Text - Preformatted

select ORDER_TYPE_ID ORDER_TYPE_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, NAME NAME, CYCLE_ID CYCLE_ID, ORDER_NUMBER_SOURCE_ID ORDER_NUMBER_SOURCE_ID, STANDARD_VALUE_RULE_SET_ID STANDARD_VALUE_RULE_SET_ID, NAVIGATION_PREFERENCE_SET_ID NAVIGATION_PREFERENCE_SET_ID, PRICE_LIST_ID PRICE_LIST_ID, ENFORCE_PRICE_LIST_FLAG ENFORCE_PRICE_LIST_FLAG, ENFORCE_LINE_PRICES_FLAG ENFORCE_LINE_PRICES_FLAG, WAREHOUSE_ID WAREHOUSE_ID, DEMAND_CLASS_CODE DEMAND_CLASS_CODE, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE, SHIP_METHOD_CODE SHIP_METHOD_CODE, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE, FOB_CODE FOB_CODE, AGREEMENT_TYPE_CODE AGREEMENT_TYPE_CODE, AGREEMENT_REQUIRED_FLAG AGREEMENT_REQUIRED_FLAG, REQUIRE_PO_FLAG REQUIRE_PO_FLAG, INVOICING_RULE_ID INVOICING_RULE_ID, INVOICING_CREDIT_METHOD_CODE INVOICING_CREDIT_METHOD_CODE, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID, ACCOUNTING_CREDIT_METHOD_CODE ACCOUNTING_CREDIT_METHOD_CODE, CURRENCY_CODE CURRENCY_CODE, CONVERSION_TYPE_CODE CONVERSION_TYPE_CODE, CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID, COST_OF_GOODS_SOLD_ACCOUNT COST_OF_GOODS_SOLD_ACCOUNT, ENTRY_CREDIT_CHECK_RULE_ID ENTRY_CREDIT_CHECK_RULE_ID, SHIPPING_CREDIT_CHECK_RULE_ID SHIPPING_CREDIT_CHECK_RULE_ID, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, DESCRIPTION DESCRIPTION, CONTEXT CONTEXT, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ORDER_CATEGORY_CODE ORDER_CATEGORY_CODE, ORG_ID ORG_ID from "OE"."SO_ORDER_TYPES_115_ALL"

View Text - HTML Formatted

SELECT ORDER_TYPE_ID ORDER_TYPE_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, NAME NAME
, CYCLE_ID CYCLE_ID
, ORDER_NUMBER_SOURCE_ID ORDER_NUMBER_SOURCE_ID
, STANDARD_VALUE_RULE_SET_ID STANDARD_VALUE_RULE_SET_ID
, NAVIGATION_PREFERENCE_SET_ID NAVIGATION_PREFERENCE_SET_ID
, PRICE_LIST_ID PRICE_LIST_ID
, ENFORCE_PRICE_LIST_FLAG ENFORCE_PRICE_LIST_FLAG
, ENFORCE_LINE_PRICES_FLAG ENFORCE_LINE_PRICES_FLAG
, WAREHOUSE_ID WAREHOUSE_ID
, DEMAND_CLASS_CODE DEMAND_CLASS_CODE
, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE
, SHIP_METHOD_CODE SHIP_METHOD_CODE
, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, FOB_CODE FOB_CODE
, AGREEMENT_TYPE_CODE AGREEMENT_TYPE_CODE
, AGREEMENT_REQUIRED_FLAG AGREEMENT_REQUIRED_FLAG
, REQUIRE_PO_FLAG REQUIRE_PO_FLAG
, INVOICING_RULE_ID INVOICING_RULE_ID
, INVOICING_CREDIT_METHOD_CODE INVOICING_CREDIT_METHOD_CODE
, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, ACCOUNTING_CREDIT_METHOD_CODE ACCOUNTING_CREDIT_METHOD_CODE
, CURRENCY_CODE CURRENCY_CODE
, CONVERSION_TYPE_CODE CONVERSION_TYPE_CODE
, CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID
, COST_OF_GOODS_SOLD_ACCOUNT COST_OF_GOODS_SOLD_ACCOUNT
, ENTRY_CREDIT_CHECK_RULE_ID ENTRY_CREDIT_CHECK_RULE_ID
, SHIPPING_CREDIT_CHECK_RULE_ID SHIPPING_CREDIT_CHECK_RULE_ID
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, DESCRIPTION DESCRIPTION
, CONTEXT CONTEXT
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ORDER_CATEGORY_CODE ORDER_CATEGORY_CODE
, ORG_ID ORG_ID
FROM "OE"."SO_ORDER_TYPES_115_ALL"