eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: OE.SO_HEADERS_INTERFACE_ALL

Object Details

Object Name:	SO_HEADERS_INTERFACE_ALL
Object Type:	TABLE
Owner:	OE
FND Design Data:	OE.SO_HEADERS_INTERFACE_ALL
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SO_HEADERS_INTERFACE_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	ORIGINAL_SYSTEM_REFERENCE ORDER_SOURCE_ID
SYS_IL0000040561C00121$$	LOB	UNIQUE	APPS_TS_INTERFACE
SO_HEADERS_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application of concurrent program which last updated row
PROGRAM_ID	NUMBER	(15)		Concurrent program that last updated row
PROGRAM_UPDATE_DATE	DATE			Last date changed by concurrent program
REQUEST_ID	NUMBER	(15)		Concurrent request that last updated row
ORIGINAL_SYSTEM_REFERENCE	VARCHAR2	(50)	Yes	Unique ID of order in old system
ORDER_NUMBER_SOURCE_ID	NUMBER			This column is not used currently
CUSTOMER_NAME	VARCHAR2	(50)		Name of ordering customer
CUSTOMER_NUMBER	VARCHAR2	(30)		Customer number of ordering customer
CUSTOMER_ID	NUMBER			Sold-to customer
ORDER_TYPE	VARCHAR2	(30)		Order type name
ORDER_TYPE_ID	NUMBER			Order type
ORDER_SOURCE_ID	NUMBER		Yes	ID for the order source
ORDER_CATEGORY	VARCHAR2	(30)	Yes	Identifies whether the order is a regular order, return or internal sales order
DATE_ORDERED	DATE		Yes	Date order was placed
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency in which line prices are calculated
CONVERSION_RATE	NUMBER			Rate of currency conversion
CONVERSION_DATE	DATE			Date of currency conversion
CONVERSION_TYPE_CODE	VARCHAR2	(30)		Currency conversion type
SALESREP_NAME	VARCHAR2	(30)		Primary salesrep for the order
SALESREP_ID	NUMBER			ID of the salesrep
INVOICE_CUSTOMER	VARCHAR2	(50)		Customer to whom invoice is sent
INVOICE_CUSTOMER_ID	NUMBER			ID for the invoice customer
INVOICE_TO_SITE_USE_ID	NUMBER			Site use ID to which invoice is sent (derived field)
INVOICE_ADDRESS_ID	NUMBER			Address ID of the invoice site
INVOICE_ADDRESS1	VARCHAR2	(240)		Address line 1 of invoice address
INVOICE_ADDRESS2	VARCHAR2	(240)		Address line 2
INVOICE_ADDRESS3	VARCHAR2	(240)		Address line 3
INVOICE_ADDRESS4	VARCHAR2	(240)		Address line 4
INVOICE_CITY	VARCHAR2	(50)		City for invoice address
INVOICE_STATE	VARCHAR2	(50)		State
INVOICE_COUNTY	VARCHAR2	(50)		County
INVOICE_COUNTRY	VARCHAR2	(50)		Country
INVOICE_POSTAL_CODE	VARCHAR2	(30)		Postal code
SHIP_TO_SITE_USE_ID	NUMBER			Site use ID to which order is shipped
SHIP_TO_CUSTOMER	VARCHAR2	(50)		Customer to whom order is shipped
SHIP_TO_CUSTOMER_ID	NUMBER			Customer ID to whom order is shipped
SHIP_ADDRESS_ID	NUMBER			Address ID to which order is shipped
SHIP_ADDRESS1	VARCHAR2	(240)		Address line 1 of ship address
SHIP_ADDRESS2	VARCHAR2	(240)		Address line 2
SHIP_ADDRESS3	VARCHAR2	(240)		Address line 3
SHIP_ADDRESS4	VARCHAR2	(240)		Address line 4
SHIP_CITY	VARCHAR2	(50)		City
SHIP_STATE	VARCHAR2	(50)		State
SHIP_COUNTY	VARCHAR2	(50)		County
SHIP_COUNTRY	VARCHAR2	(50)		Country
SHIP_POSTAL_CODE	VARCHAR2	(30)		Postal code
PRICE_LIST_NAME	VARCHAR2	(30)		Name of price list to be ordered from
PRICE_LIST_ID	NUMBER			ID of price list
TERMS_NAME	VARCHAR2	(15)		Name of the terms used on the order
TERMS_ID	NUMBER			Payment terms
CYCLE_ID	NUMBER			ID of the cycle the order will follow
ENTERED_STATE_NAME	VARCHAR2	(30)		Place in the cycle where order is
ENTERED_STATE_ID	NUMBER			ID corresponding to ENTERED_STATE_NAME
ENTERED_STATE_DATE	DATE			Date the order made it to that stage
COMPLETE_FLAG	VARCHAR2	(1)		Determines if this order is a historical order
AGREEMENT_NAME	VARCHAR2	(30)		Name of the agreement for the order
AGREEMENT_ID	NUMBER			ID of the agreement
DATE_REQUESTED_CURRENT	DATE			Date the customer requests delivery
ORDERED_BY_CONTACT_FIRST_NAME	VARCHAR2	(30)		First name of the order contact
ORDERED_BY_CONTACT_LAST_NAME	VARCHAR2	(50)		Last name of the order contact
ORDERED_BY_CONTACT_ID	NUMBER			ID of the order contact
SALES_CHANNEL_CODE	VARCHAR2	(30)		Sales channel for this order
PURCHASE_ORDER_NUM	VARCHAR2	(50)		Purchase order number for the order
INVOICE_TO_CONTACT_FIRST_NAME	VARCHAR2	(30)		First name of the invoice contact
INVOICE_TO_CONTACT_LAST_NAME	VARCHAR2	(50)		Last name of the invoice contact
INVOICE_TO_CONTACT_ID	NUMBER			ID of the invoice contact
SHIP_TO_CONTACT_FIRST_NAME	VARCHAR2	(30)		First name of the ship-to contact
SHIP_TO_CONTACT_LAST_NAME	VARCHAR2	(50)		Last name of the ship-to contact
SHIP_TO_CONTACT_ID	NUMBER			ID of the ship-to contact
TAX_EXEMPT_FLAG	VARCHAR2	(1)		Tax-exempt indicator
TAX_EXEMPT_NUM	VARCHAR2	(80)		Tax exemption certificate number
TAX_EXEMPT_REASON_CODE	VARCHAR2	(30)		Tax exemption reason
SHIPMENT_PRIORITY_CODE	VARCHAR2	(30)		Shipment priority
SHIP_METHOD_CODE	VARCHAR2	(30)		Freight carrier
FREIGHT_TERMS_CODE	VARCHAR2	(30)		Freight terms
FOB_CODE	VARCHAR2	(30)		FOB for the order
SHIPPING_INSTRUCTIONS	VARCHAR2	(240)		Shipping instruction for the order
PACKING_INSTRUCTIONS	VARCHAR2	(240)		Packing instructions for the order
DATE_SHIPPED	DATE			Date the order shipped
PAYMENT_TYPE_CODE	VARCHAR2	(30)		Method of payment
PAYMENT_AMOUNT	NUMBER			Amount of payment
CHECK_NUMBER	VARCHAR2	(50)		Check number if payment by check
CREDIT_CARD_CODE	VARCHAR2	(30)		Credit card name if credit
CREDIT_CARD_HOLDER_NAME	VARCHAR2	(50)		Credit card holder name
CREDIT_CARD_NUMBER	VARCHAR2	(50)		Credit card number
CREDIT_CARD_EXPIRATION_DATE	DATE			Credit card expiration date
CREDIT_CARD_APPROVAL_CODE	VARCHAR2	(50)		Approval code for credit card
ACCOUNTING_RULE	VARCHAR2	(30)		Name of accounting rule for order
ACCOUNTING_RULE_ID	NUMBER			Accounting rule
INVOICING_RULE	VARCHAR2	(30)		Name of the invoicing rule to be used in the order
INVOICING_RULE_ID	NUMBER			Invoicing rule
CONTEXT	VARCHAR2	(30)		Descriptive flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
INTERFACE_STATUS	VARCHAR2	(1000)		Contains validation errors which occurred when processing this record
ERROR_FLAG	VARCHAR2	(1)		Value is set to 'Y' if this record has errors
SCHEDULE_STATUS_CODE	VARCHAR2	(30)		Used to do scheduling on the order; can be 'DEMANDED' or 'RESERVED' or NULL
OPERATION_CODE	VARCHAR2	(30)		Used to identify if this record is to be inserted, updated or deleted
SALESREP_NUMBER	NUMBER			Salesrep number of the order level salesrep
APPLY_STANDARD_NOTES	VARCHAR2	(1)		Used to apply standard notes on the order; can be 'Y', 'N' or NULL
DEMAND_CLASS_CODE	VARCHAR2	(30)		Demand class
ORG_ID	NUMBER			Operating unit which performed this transaction
REPORT_SUMMARY	CLOB	(4000)		Contains all validation and other errors for the entire order

Query Text

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


SELECT CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      ORIGINAL_SYSTEM_REFERENCE
,      ORDER_NUMBER_SOURCE_ID
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      CUSTOMER_ID
,      ORDER_TYPE
,      ORDER_TYPE_ID
,      ORDER_SOURCE_ID
,      ORDER_CATEGORY
,      DATE_ORDERED
,      CURRENCY_CODE
,      CONVERSION_RATE
,      CONVERSION_DATE
,      CONVERSION_TYPE_CODE
,      SALESREP_NAME
,      SALESREP_ID
,      INVOICE_CUSTOMER
,      INVOICE_CUSTOMER_ID
,      INVOICE_TO_SITE_USE_ID
,      INVOICE_ADDRESS_ID
,      INVOICE_ADDRESS1
,      INVOICE_ADDRESS2
,      INVOICE_ADDRESS3
,      INVOICE_ADDRESS4
,      INVOICE_CITY
,      INVOICE_STATE
,      INVOICE_COUNTY
,      INVOICE_COUNTRY
,      INVOICE_POSTAL_CODE
,      SHIP_TO_SITE_USE_ID
,      SHIP_TO_CUSTOMER
,      SHIP_TO_CUSTOMER_ID
,      SHIP_ADDRESS_ID
,      SHIP_ADDRESS1
,      SHIP_ADDRESS2
,      SHIP_ADDRESS3
,      SHIP_ADDRESS4
,      SHIP_CITY
,      SHIP_STATE
,      SHIP_COUNTY
,      SHIP_COUNTRY
,      SHIP_POSTAL_CODE
,      PRICE_LIST_NAME
,      PRICE_LIST_ID
,      TERMS_NAME
,      TERMS_ID
,      CYCLE_ID
,      ENTERED_STATE_NAME
,      ENTERED_STATE_ID
,      ENTERED_STATE_DATE
,      COMPLETE_FLAG
,      AGREEMENT_NAME
,      AGREEMENT_ID
,      DATE_REQUESTED_CURRENT
,      ORDERED_BY_CONTACT_FIRST_NAME
,      ORDERED_BY_CONTACT_LAST_NAME
,      ORDERED_BY_CONTACT_ID
,      SALES_CHANNEL_CODE
,      PURCHASE_ORDER_NUM
,      INVOICE_TO_CONTACT_FIRST_NAME
,      INVOICE_TO_CONTACT_LAST_NAME
,      INVOICE_TO_CONTACT_ID
,      SHIP_TO_CONTACT_FIRST_NAME
,      SHIP_TO_CONTACT_LAST_NAME
,      SHIP_TO_CONTACT_ID
,      TAX_EXEMPT_FLAG
,      TAX_EXEMPT_NUM
,      TAX_EXEMPT_REASON_CODE
,      SHIPMENT_PRIORITY_CODE
,      SHIP_METHOD_CODE
,      FREIGHT_TERMS_CODE
,      FOB_CODE
,      SHIPPING_INSTRUCTIONS
,      PACKING_INSTRUCTIONS
,      DATE_SHIPPED
,      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
,      ACCOUNTING_RULE
,      ACCOUNTING_RULE_ID
,      INVOICING_RULE
,      INVOICING_RULE_ID
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      INTERFACE_STATUS
,      ERROR_FLAG
,      SCHEDULE_STATUS_CODE
,      OPERATION_CODE
,      SALESREP_NUMBER
,      APPLY_STANDARD_NOTES
,      DEMAND_CLASS_CODE
,      ORG_ID
,      REPORT_SUMMARY
FROM OE.SO_HEADERS_INTERFACE_ALL;

Dependencies

[top of page]

OE.SO_HEADERS_INTERFACE_ALL does not reference any database object

OE.SO_HEADERS_INTERFACE_ALL is referenced by following:

OE: SO_HEADERS_INTERFACE_ALL#