DBA Data[Home] [Help] [Dependency Information]

VIEW: OE.SO_HEADERS_ALL#

Object Details
Object Name: SO_HEADERS_ALL#
Object Type: VIEW
Owner: OE
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

ORDER_NUMBER NUMBER
Yes
ORDER_CATEGORY VARCHAR2 (30) Yes
ORIGINAL_SYSTEM_SOURCE_CODE VARCHAR2 (30)
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (50)
SOURCE_HEADER_ID NUMBER

ORDER_TYPE_ID NUMBER
Yes
CYCLE_ID NUMBER
Yes
DATE_ORDERED DATE

OPEN_FLAG VARCHAR2 (1)
CANCELLED_FLAG VARCHAR2 (1)
CUSTOMER_ID NUMBER

ORDERED_BY_CONTACT_ID NUMBER

SHIP_TO_SITE_USE_ID NUMBER

SHIP_TO_CONTACT_ID NUMBER

INVOICE_TO_SITE_USE_ID NUMBER

INVOICE_TO_CONTACT_ID NUMBER

PURCHASE_ORDER_NUM VARCHAR2 (50)
DATE_REQUESTED_CURRENT DATE

SHIPMENT_PRIORITY_CODE VARCHAR2 (30)
SHIP_METHOD_CODE VARCHAR2 (30)
FREIGHT_TERMS_CODE VARCHAR2 (30)
FOB_CODE VARCHAR2 (30)
SHIP_PARTIAL_FLAG VARCHAR2 (1)
WAREHOUSE_ID NUMBER

DEMAND_CLASS_CODE VARCHAR2 (30)
SHIPPING_INSTRUCTIONS VARCHAR2 (240)
PACKING_INSTRUCTIONS VARCHAR2 (240)
AGREEMENT_ID NUMBER

SALESREP_ID NUMBER

SALES_CHANNEL_CODE VARCHAR2 (30)
PRICE_LIST_ID NUMBER

CURRENCY_CODE VARCHAR2 (15) Yes
CONVERSION_TYPE_CODE VARCHAR2 (30)
CONVERSION_RATE NUMBER

CONVERSION_DATE DATE

TERMS_ID NUMBER

INVOICING_RULE_ID NUMBER

ACCOUNTING_RULE_ID NUMBER

TAX_EXEMPT_FLAG VARCHAR2 (1)
TAX_EXEMPT_NUM VARCHAR2 (80)
TAX_EXEMPT_REASON_CODE VARCHAR2 (30)
PAYMENT_TYPE_CODE VARCHAR2 (30)
PAYMENT_AMOUNT NUMBER

CHECK_NUMBER VARCHAR2 (50)
CREDIT_CARD_CODE VARCHAR2 (30)
CREDIT_CARD_HOLDER_NAME VARCHAR2 (50)
CREDIT_CARD_NUMBER VARCHAR2 (50)
CREDIT_CARD_EXPIRATION_DATE DATE

CREDIT_CARD_APPROVAL_CODE VARCHAR2 (50)
ORG_ID NUMBER

WH_UPDATE_DATE DATE

DATE_SVRID NUMBER

ENTRY_STATUS_SVRID NUMBER

TYPE_SVRID NUMBER

CUSTOMER_SVRID NUMBER

CONTACT_SVRID NUMBER

SHIP_TO_SVRID NUMBER

SHIP_TO_CONTACT_SVRID NUMBER

INVOICE_TO_SVRID NUMBER

INVOICE_TO_CONTACT_SVRID NUMBER

AGREEMENT_SVRID NUMBER

PO_NUMBER_SVRID NUMBER

REQUEST_DATE_SVRID NUMBER

SALESPERSON_SVRID NUMBER

SALES_CHANNEL_SVRID NUMBER

PRICE_LIST_SVRID NUMBER

CURRENCY_SVRID NUMBER

CONVERSION_TYPE_SVRID NUMBER

CONVERSION_DATE_SVRID NUMBER

CONVERSION_RATE_SVRID NUMBER

INVOICING_RULE_SVRID NUMBER

ACCOUNTING_RULE_SVRID NUMBER

PAYMENT_TERMS_SVRID NUMBER

TAX_EXEMPT_NUMBER_SVRID NUMBER

TAX_EXEMPT_REASON_SVRID NUMBER

SHIPMENT_PRIORITY_SVRID NUMBER

FREIGHT_CARRIER_SVRID NUMBER

FREIGHT_TERMS_SVRID NUMBER

FOB_SVRID NUMBER

SHIP_PARTIAL_SVRID NUMBER

WAREHOUSE_SVRID NUMBER

DEMAND_CLASS_SVRID NUMBER

PACKING_INSTRUCTIONS_SVRID NUMBER

SHIPPING_INSTRUCTIONS_SVRID NUMBER

PAYMENT_TYPE_SVRID NUMBER

PAYMENT_AMOUNT_SVRID NUMBER

CHECK_NUMBER_SVRID NUMBER

CREDIT_CARD_SVRID NUMBER

CREDIT_CARD_HOLDER_SVRID NUMBER

CREDIT_CARD_NUMBER_SVRID NUMBER

CREDIT_CARD_EXP_DATE_SVRID NUMBER

CREDIT_CARD_APP_CODE_SVRID NUMBER

DF_SVRID NUMBER

S1 NUMBER

S1_DATE DATE

S2 NUMBER

S2_DATE DATE

S3 NUMBER

S3_DATE DATE

S4 NUMBER

S4_DATE DATE

S5 NUMBER

S5_DATE DATE

S6 NUMBER

S6_DATE DATE

S7 NUMBER

S7_DATE DATE

S8 NUMBER

S8_DATE DATE

S9 NUMBER

S9_DATE DATE

S10 NUMBER

S10_DATE DATE

S11 NUMBER

S11_DATE DATE

S12 NUMBER

S12_DATE DATE

S13 NUMBER

S13_DATE DATE

S14 NUMBER

S14_DATE DATE

S15 NUMBER

S15_DATE DATE

S16 NUMBER

S16_DATE DATE

S17 NUMBER

S17_DATE DATE

S18 NUMBER

S18_DATE DATE

S19 NUMBER

S19_DATE DATE

S20 NUMBER

S20_DATE DATE

S21 NUMBER

S21_DATE DATE

S22 NUMBER

S22_DATE DATE

S23 NUMBER

S23_DATE DATE

S24 NUMBER

S24_DATE DATE

S25 NUMBER

S25_DATE DATE

S26 NUMBER

S26_DATE DATE

S27 NUMBER

S27_DATE DATE

S28 NUMBER

S28_DATE DATE

S29 NUMBER

S29_DATE DATE

S30 NUMBER

S30_DATE DATE

CONTEXT VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
UPGRADE_FLAG VARCHAR2 (1)
Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

OE.SO_HEADERS_ALL# references the following:

SchemaOE
TableSO_HEADERS_ALL
OE.SO_HEADERS_ALL# is referenced by following:

SchemaAPPS
SynonymSO_HEADERS_ALL