VIEW: OE.SO_HEADERS_ALL#

Source

View Text - Preformatted

select HEADER_ID HEADER_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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ORDER_NUMBER ORDER_NUMBER, ORDER_CATEGORY ORDER_CATEGORY, ORIGINAL_SYSTEM_SOURCE_CODE ORIGINAL_SYSTEM_SOURCE_CODE, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE, SOURCE_HEADER_ID SOURCE_HEADER_ID, ORDER_TYPE_ID ORDER_TYPE_ID, CYCLE_ID CYCLE_ID, DATE_ORDERED DATE_ORDERED, OPEN_FLAG OPEN_FLAG, CANCELLED_FLAG CANCELLED_FLAG, CUSTOMER_ID CUSTOMER_ID, ORDERED_BY_CONTACT_ID ORDERED_BY_CONTACT_ID, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID, INVOICE_TO_SITE_USE_ID INVOICE_TO_SITE_USE_ID, INVOICE_TO_CONTACT_ID INVOICE_TO_CONTACT_ID, PURCHASE_ORDER_NUM PURCHASE_ORDER_NUM, DATE_REQUESTED_CURRENT DATE_REQUESTED_CURRENT, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE, SHIP_METHOD_CODE SHIP_METHOD_CODE, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE, FOB_CODE FOB_CODE, SHIP_PARTIAL_FLAG SHIP_PARTIAL_FLAG, WAREHOUSE_ID WAREHOUSE_ID, DEMAND_CLASS_CODE DEMAND_CLASS_CODE, SHIPPING_INSTRUCTIONS SHIPPING_INSTRUCTIONS, PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS, AGREEMENT_ID AGREEMENT_ID, SALESREP_ID SALESREP_ID, SALES_CHANNEL_CODE SALES_CHANNEL_CODE, PRICE_LIST_ID PRICE_LIST_ID, CURRENCY_CODE CURRENCY_CODE, CONVERSION_TYPE_CODE CONVERSION_TYPE_CODE, CONVERSION_RATE CONVERSION_RATE, CONVERSION_DATE CONVERSION_DATE, TERMS_ID TERMS_ID, INVOICING_RULE_ID INVOICING_RULE_ID, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID, TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG, TAX_EXEMPT_NUM TAX_EXEMPT_NUM, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE, PAYMENT_TYPE_CODE PAYMENT_TYPE_CODE, PAYMENT_AMOUNT PAYMENT_AMOUNT, CHECK_NUMBER CHECK_NUMBER, CREDIT_CARD_CODE CREDIT_CARD_CODE, CREDIT_CARD_HOLDER_NAME CREDIT_CARD_HOLDER_NAME, CREDIT_CARD_NUMBER CREDIT_CARD_NUMBER, CREDIT_CARD_EXPIRATION_DATE CREDIT_CARD_EXPIRATION_DATE, CREDIT_CARD_APPROVAL_CODE CREDIT_CARD_APPROVAL_CODE, ORG_ID ORG_ID, WH_UPDATE_DATE WH_UPDATE_DATE, DATE_SVRID DATE_SVRID, ENTRY_STATUS_SVRID ENTRY_STATUS_SVRID, TYPE_SVRID TYPE_SVRID, CUSTOMER_SVRID CUSTOMER_SVRID, CONTACT_SVRID CONTACT_SVRID, SHIP_TO_SVRID SHIP_TO_SVRID, SHIP_TO_CONTACT_SVRID SHIP_TO_CONTACT_SVRID, INVOICE_TO_SVRID INVOICE_TO_SVRID, INVOICE_TO_CONTACT_SVRID INVOICE_TO_CONTACT_SVRID, AGREEMENT_SVRID AGREEMENT_SVRID, PO_NUMBER_SVRID PO_NUMBER_SVRID, REQUEST_DATE_SVRID REQUEST_DATE_SVRID, SALESPERSON_SVRID SALESPERSON_SVRID, SALES_CHANNEL_SVRID SALES_CHANNEL_SVRID, PRICE_LIST_SVRID PRICE_LIST_SVRID, CURRENCY_SVRID CURRENCY_SVRID, CONVERSION_TYPE_SVRID CONVERSION_TYPE_SVRID, CONVERSION_DATE_SVRID CONVERSION_DATE_SVRID, CONVERSION_RATE_SVRID CONVERSION_RATE_SVRID, INVOICING_RULE_SVRID INVOICING_RULE_SVRID, ACCOUNTING_RULE_SVRID ACCOUNTING_RULE_SVRID, PAYMENT_TERMS_SVRID PAYMENT_TERMS_SVRID, TAX_EXEMPT_NUMBER_SVRID TAX_EXEMPT_NUMBER_SVRID, TAX_EXEMPT_REASON_SVRID TAX_EXEMPT_REASON_SVRID, SHIPMENT_PRIORITY_SVRID SHIPMENT_PRIORITY_SVRID, FREIGHT_CARRIER_SVRID FREIGHT_CARRIER_SVRID, FREIGHT_TERMS_SVRID FREIGHT_TERMS_SVRID, FOB_SVRID FOB_SVRID, SHIP_PARTIAL_SVRID SHIP_PARTIAL_SVRID, WAREHOUSE_SVRID WAREHOUSE_SVRID, DEMAND_CLASS_SVRID DEMAND_CLASS_SVRID, PACKING_INSTRUCTIONS_SVRID PACKING_INSTRUCTIONS_SVRID, SHIPPING_INSTRUCTIONS_SVRID SHIPPING_INSTRUCTIONS_SVRID, PAYMENT_TYPE_SVRID PAYMENT_TYPE_SVRID, PAYMENT_AMOUNT_SVRID PAYMENT_AMOUNT_SVRID, CHECK_NUMBER_SVRID CHECK_NUMBER_SVRID, CREDIT_CARD_SVRID CREDIT_CARD_SVRID, CREDIT_CARD_HOLDER_SVRID CREDIT_CARD_HOLDER_SVRID, CREDIT_CARD_NUMBER_SVRID CREDIT_CARD_NUMBER_SVRID, CREDIT_CARD_EXP_DATE_SVRID CREDIT_CARD_EXP_DATE_SVRID, CREDIT_CARD_APP_CODE_SVRID CREDIT_CARD_APP_CODE_SVRID, DF_SVRID DF_SVRID, S1 S1, S1_DATE S1_DATE, S2 S2, S2_DATE S2_DATE, S3 S3, S3_DATE S3_DATE, S4 S4, S4_DATE S4_DATE, S5 S5, S5_DATE S5_DATE, S6 S6, S6_DATE S6_DATE, S7 S7, S7_DATE S7_DATE, S8 S8, S8_DATE S8_DATE, S9 S9, S9_DATE S9_DATE, S10 S10, S10_DATE S10_DATE, S11 S11, S11_DATE S11_DATE, S12 S12, S12_DATE S12_DATE, S13 S13, S13_DATE S13_DATE, S14 S14, S14_DATE S14_DATE, S15 S15, S15_DATE S15_DATE, S16 S16, S16_DATE S16_DATE, S17 S17, S17_DATE S17_DATE, S18 S18, S18_DATE S18_DATE, S19 S19, S19_DATE S19_DATE, S20 S20, S20_DATE S20_DATE, S21 S21, S21_DATE S21_DATE, S22 S22, S22_DATE S22_DATE, S23 S23, S23_DATE S23_DATE, S24 S24, S24_DATE S24_DATE, S25 S25, S25_DATE S25_DATE, S26 S26, S26_DATE S26_DATE, S27 S27, S27_DATE S27_DATE, S28 S28, S28_DATE S28_DATE, S29 S29, S29_DATE S29_DATE, S30 S30, S30_DATE S30_DATE, 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, UPGRADE_FLAG UPGRADE_FLAG from "OE"."SO_HEADERS_ALL"

View Text - HTML Formatted

SELECT HEADER_ID HEADER_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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ORDER_NUMBER ORDER_NUMBER
, ORDER_CATEGORY ORDER_CATEGORY
, ORIGINAL_SYSTEM_SOURCE_CODE ORIGINAL_SYSTEM_SOURCE_CODE
, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE
, SOURCE_HEADER_ID SOURCE_HEADER_ID
, ORDER_TYPE_ID ORDER_TYPE_ID
, CYCLE_ID CYCLE_ID
, DATE_ORDERED DATE_ORDERED
, OPEN_FLAG OPEN_FLAG
, CANCELLED_FLAG CANCELLED_FLAG
, CUSTOMER_ID CUSTOMER_ID
, ORDERED_BY_CONTACT_ID ORDERED_BY_CONTACT_ID
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID
, INVOICE_TO_SITE_USE_ID INVOICE_TO_SITE_USE_ID
, INVOICE_TO_CONTACT_ID INVOICE_TO_CONTACT_ID
, PURCHASE_ORDER_NUM PURCHASE_ORDER_NUM
, DATE_REQUESTED_CURRENT DATE_REQUESTED_CURRENT
, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE
, SHIP_METHOD_CODE SHIP_METHOD_CODE
, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, FOB_CODE FOB_CODE
, SHIP_PARTIAL_FLAG SHIP_PARTIAL_FLAG
, WAREHOUSE_ID WAREHOUSE_ID
, DEMAND_CLASS_CODE DEMAND_CLASS_CODE
, SHIPPING_INSTRUCTIONS SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS
, AGREEMENT_ID AGREEMENT_ID
, SALESREP_ID SALESREP_ID
, SALES_CHANNEL_CODE SALES_CHANNEL_CODE
, PRICE_LIST_ID PRICE_LIST_ID
, CURRENCY_CODE CURRENCY_CODE
, CONVERSION_TYPE_CODE CONVERSION_TYPE_CODE
, CONVERSION_RATE CONVERSION_RATE
, CONVERSION_DATE CONVERSION_DATE
, TERMS_ID TERMS_ID
, INVOICING_RULE_ID INVOICING_RULE_ID
, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUM TAX_EXEMPT_NUM
, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE
, PAYMENT_TYPE_CODE PAYMENT_TYPE_CODE
, PAYMENT_AMOUNT PAYMENT_AMOUNT
, CHECK_NUMBER CHECK_NUMBER
, CREDIT_CARD_CODE CREDIT_CARD_CODE
, CREDIT_CARD_HOLDER_NAME CREDIT_CARD_HOLDER_NAME
, CREDIT_CARD_NUMBER CREDIT_CARD_NUMBER
, CREDIT_CARD_EXPIRATION_DATE CREDIT_CARD_EXPIRATION_DATE
, CREDIT_CARD_APPROVAL_CODE CREDIT_CARD_APPROVAL_CODE
, ORG_ID ORG_ID
, WH_UPDATE_DATE WH_UPDATE_DATE
, DATE_SVRID DATE_SVRID
, ENTRY_STATUS_SVRID ENTRY_STATUS_SVRID
, TYPE_SVRID TYPE_SVRID
, CUSTOMER_SVRID CUSTOMER_SVRID
, CONTACT_SVRID CONTACT_SVRID
, SHIP_TO_SVRID SHIP_TO_SVRID
, SHIP_TO_CONTACT_SVRID SHIP_TO_CONTACT_SVRID
, INVOICE_TO_SVRID INVOICE_TO_SVRID
, INVOICE_TO_CONTACT_SVRID INVOICE_TO_CONTACT_SVRID
, AGREEMENT_SVRID AGREEMENT_SVRID
, PO_NUMBER_SVRID PO_NUMBER_SVRID
, REQUEST_DATE_SVRID REQUEST_DATE_SVRID
, SALESPERSON_SVRID SALESPERSON_SVRID
, SALES_CHANNEL_SVRID SALES_CHANNEL_SVRID
, PRICE_LIST_SVRID PRICE_LIST_SVRID
, CURRENCY_SVRID CURRENCY_SVRID
, CONVERSION_TYPE_SVRID CONVERSION_TYPE_SVRID
, CONVERSION_DATE_SVRID CONVERSION_DATE_SVRID
, CONVERSION_RATE_SVRID CONVERSION_RATE_SVRID
, INVOICING_RULE_SVRID INVOICING_RULE_SVRID
, ACCOUNTING_RULE_SVRID ACCOUNTING_RULE_SVRID
, PAYMENT_TERMS_SVRID PAYMENT_TERMS_SVRID
, TAX_EXEMPT_NUMBER_SVRID TAX_EXEMPT_NUMBER_SVRID
, TAX_EXEMPT_REASON_SVRID TAX_EXEMPT_REASON_SVRID
, SHIPMENT_PRIORITY_SVRID SHIPMENT_PRIORITY_SVRID
, FREIGHT_CARRIER_SVRID FREIGHT_CARRIER_SVRID
, FREIGHT_TERMS_SVRID FREIGHT_TERMS_SVRID
, FOB_SVRID FOB_SVRID
, SHIP_PARTIAL_SVRID SHIP_PARTIAL_SVRID
, WAREHOUSE_SVRID WAREHOUSE_SVRID
, DEMAND_CLASS_SVRID DEMAND_CLASS_SVRID
, PACKING_INSTRUCTIONS_SVRID PACKING_INSTRUCTIONS_SVRID
, SHIPPING_INSTRUCTIONS_SVRID SHIPPING_INSTRUCTIONS_SVRID
, PAYMENT_TYPE_SVRID PAYMENT_TYPE_SVRID
, PAYMENT_AMOUNT_SVRID PAYMENT_AMOUNT_SVRID
, CHECK_NUMBER_SVRID CHECK_NUMBER_SVRID
, CREDIT_CARD_SVRID CREDIT_CARD_SVRID
, CREDIT_CARD_HOLDER_SVRID CREDIT_CARD_HOLDER_SVRID
, CREDIT_CARD_NUMBER_SVRID CREDIT_CARD_NUMBER_SVRID
, CREDIT_CARD_EXP_DATE_SVRID CREDIT_CARD_EXP_DATE_SVRID
, CREDIT_CARD_APP_CODE_SVRID CREDIT_CARD_APP_CODE_SVRID
, DF_SVRID DF_SVRID
, S1 S1
, S1_DATE S1_DATE
, S2 S2
, S2_DATE S2_DATE
, S3 S3
, S3_DATE S3_DATE
, S4 S4
, S4_DATE S4_DATE
, S5 S5
, S5_DATE S5_DATE
, S6 S6
, S6_DATE S6_DATE
, S7 S7
, S7_DATE S7_DATE
, S8 S8
, S8_DATE S8_DATE
, S9 S9
, S9_DATE S9_DATE
, S10 S10
, S10_DATE S10_DATE
, S11 S11
, S11_DATE S11_DATE
, S12 S12
, S12_DATE S12_DATE
, S13 S13
, S13_DATE S13_DATE
, S14 S14
, S14_DATE S14_DATE
, S15 S15
, S15_DATE S15_DATE
, S16 S16
, S16_DATE S16_DATE
, S17 S17
, S17_DATE S17_DATE
, S18 S18
, S18_DATE S18_DATE
, S19 S19
, S19_DATE S19_DATE
, S20 S20
, S20_DATE S20_DATE
, S21 S21
, S21_DATE S21_DATE
, S22 S22
, S22_DATE S22_DATE
, S23 S23
, S23_DATE S23_DATE
, S24 S24
, S24_DATE S24_DATE
, S25 S25
, S25_DATE S25_DATE
, S26 S26
, S26_DATE S26_DATE
, S27 S27
, S27_DATE S27_DATE
, S28 S28
, S28_DATE S28_DATE
, S29 S29
, S29_DATE S29_DATE
, S30 S30
, S30_DATE S30_DATE
, 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
, UPGRADE_FLAG UPGRADE_FLAG
FROM "OE"."SO_HEADERS_ALL"