VIEW: ONT.OE_TRANSACTION_TYPES_ALL#

Source

View Text - Preformatted

select TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID, TRANSACTION_TYPE_CODE TRANSACTION_TYPE_CODE, ORDER_CATEGORY_CODE ORDER_CATEGORY_CODE, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, 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, REQUEST_ID REQUEST_ID, 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, PRICE_LIST_ID PRICE_LIST_ID, ENFORCE_LINE_PRICES_FLAG ENFORCE_LINE_PRICES_FLAG, WAREHOUSE_ID WAREHOUSE_ID, DEMAND_CLASS_CODE DEMAND_CLASS_CODE, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE, SHIPPING_METHOD_CODE SHIPPING_METHOD_CODE, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE, FOB_POINT_CODE FOB_POINT_CODE, SHIP_SOURCE_TYPE_CODE SHIP_SOURCE_TYPE_CODE, AGREEMENT_TYPE_CODE AGREEMENT_TYPE_CODE, AGREEMENT_REQUIRED_FLAG AGREEMENT_REQUIRED_FLAG, PO_REQUIRED_FLAG PO_REQUIRED_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, INVOICE_SOURCE_ID INVOICE_SOURCE_ID, NON_DELIVERY_INVOICE_SOURCE_ID NON_DELIVERY_INVOICE_SOURCE_ID, INSPECTION_REQUIRED_FLAG INSPECTION_REQUIRED_FLAG, DEPOT_REPAIR_CODE DEPOT_REPAIR_CODE, ORG_ID ORG_ID, AUTO_SCHEDULING_FLAG AUTO_SCHEDULING_FLAG, SCHEDULING_LEVEL_CODE SCHEDULING_LEVEL_CODE, 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, DEFAULT_INBOUND_LINE_TYPE_ID DEFAULT_INBOUND_LINE_TYPE_ID, DEFAULT_OUTBOUND_LINE_TYPE_ID DEFAULT_OUTBOUND_LINE_TYPE_ID, TAX_CALCULATION_EVENT_CODE TAX_CALCULATION_EVENT_CODE, PICKING_CREDIT_CHECK_RULE_ID PICKING_CREDIT_CHECK_RULE_ID, PACKING_CREDIT_CHECK_RULE_ID PACKING_CREDIT_CHECK_RULE_ID, MIN_MARGIN_PERCENT MIN_MARGIN_PERCENT, SALES_DOCUMENT_TYPE_CODE SALES_DOCUMENT_TYPE_CODE, DEFAULT_LINE_SET_CODE DEFAULT_LINE_SET_CODE, DEFAULT_FULFILLMENT_SET DEFAULT_FULFILLMENT_SET, DEF_TRANSACTION_PHASE_CODE DEF_TRANSACTION_PHASE_CODE, QUOTE_NUM_AS_ORD_NUM_FLAG QUOTE_NUM_AS_ORD_NUM_FLAG, LAYOUT_TEMPLATE_ID LAYOUT_TEMPLATE_ID, CONTRACT_TEMPLATE_ID CONTRACT_TEMPLATE_ID, CREDIT_CARD_REV_REAUTH_CODE CREDIT_CARD_REV_REAUTH_CODE, USE_AME_APPROVAL USE_AME_APPROVAL from "ONT"."OE_TRANSACTION_TYPES_ALL"

View Text - HTML Formatted

SELECT TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, TRANSACTION_TYPE_CODE TRANSACTION_TYPE_CODE
, ORDER_CATEGORY_CODE ORDER_CATEGORY_CODE
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, 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
, REQUEST_ID REQUEST_ID
, 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
, PRICE_LIST_ID PRICE_LIST_ID
, ENFORCE_LINE_PRICES_FLAG ENFORCE_LINE_PRICES_FLAG
, WAREHOUSE_ID WAREHOUSE_ID
, DEMAND_CLASS_CODE DEMAND_CLASS_CODE
, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE
, SHIPPING_METHOD_CODE SHIPPING_METHOD_CODE
, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, FOB_POINT_CODE FOB_POINT_CODE
, SHIP_SOURCE_TYPE_CODE SHIP_SOURCE_TYPE_CODE
, AGREEMENT_TYPE_CODE AGREEMENT_TYPE_CODE
, AGREEMENT_REQUIRED_FLAG AGREEMENT_REQUIRED_FLAG
, PO_REQUIRED_FLAG PO_REQUIRED_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
, INVOICE_SOURCE_ID INVOICE_SOURCE_ID
, NON_DELIVERY_INVOICE_SOURCE_ID NON_DELIVERY_INVOICE_SOURCE_ID
, INSPECTION_REQUIRED_FLAG INSPECTION_REQUIRED_FLAG
, DEPOT_REPAIR_CODE DEPOT_REPAIR_CODE
, ORG_ID ORG_ID
, AUTO_SCHEDULING_FLAG AUTO_SCHEDULING_FLAG
, SCHEDULING_LEVEL_CODE SCHEDULING_LEVEL_CODE
, 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
, DEFAULT_INBOUND_LINE_TYPE_ID DEFAULT_INBOUND_LINE_TYPE_ID
, DEFAULT_OUTBOUND_LINE_TYPE_ID DEFAULT_OUTBOUND_LINE_TYPE_ID
, TAX_CALCULATION_EVENT_CODE TAX_CALCULATION_EVENT_CODE
, PICKING_CREDIT_CHECK_RULE_ID PICKING_CREDIT_CHECK_RULE_ID
, PACKING_CREDIT_CHECK_RULE_ID PACKING_CREDIT_CHECK_RULE_ID
, MIN_MARGIN_PERCENT MIN_MARGIN_PERCENT
, SALES_DOCUMENT_TYPE_CODE SALES_DOCUMENT_TYPE_CODE
, DEFAULT_LINE_SET_CODE DEFAULT_LINE_SET_CODE
, DEFAULT_FULFILLMENT_SET DEFAULT_FULFILLMENT_SET
, DEF_TRANSACTION_PHASE_CODE DEF_TRANSACTION_PHASE_CODE
, QUOTE_NUM_AS_ORD_NUM_FLAG QUOTE_NUM_AS_ORD_NUM_FLAG
, LAYOUT_TEMPLATE_ID LAYOUT_TEMPLATE_ID
, CONTRACT_TEMPLATE_ID CONTRACT_TEMPLATE_ID
, CREDIT_CARD_REV_REAUTH_CODE CREDIT_CARD_REV_REAUTH_CODE
, USE_AME_APPROVAL USE_AME_APPROVAL
FROM "ONT"."OE_TRANSACTION_TYPES_ALL"