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]

VIEW: APPS.OEFV_ORDER_HEADERS

Object Details

Object Name:	OEFV_ORDER_HEADERS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ONT.OEFV_ORDER_HEADERS
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.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ORDER_NUMBER	NUMBER		Yes	User-visible number of the order
CUSTOMER_NUMBER	VARCHAR2	(30)
CUSTOMER	VARCHAR2	(360)
CUSTOMER_CONTACT	VARCHAR2	(183)
CUSTOMER_CONTACT_EMAIL	VARCHAR2	(2000)
CUSTOMER_CONTACT_PHONE_NUMBER	VARCHAR2	(62)
CUSTOMER_CONTACT_PHONE_EXT	VARCHAR2	(20)
AGREEMENT	VARCHAR2	(240)
PRICE_LIST	VARCHAR2	(240)
SHIP_TO_LOCATION	VARCHAR2	(40)
SHIP_TO_ADDRESS1	VARCHAR2	(240)
SHIP_TO_ADDRESS2	VARCHAR2	(240)
SHIP_TO_ADDRESS3	VARCHAR2	(240)
SHIP_TO_ADDRESS4	VARCHAR2	(240)
SHIP_TO_CTY_ST_ZIP_CTRY	VARCHAR2	(246)
SHIP_TO_CONTACT	VARCHAR2	(183)
SHIP_FROM_ORG	VARCHAR2	(3)
ORDER_SOURCE	VARCHAR2	(240)
ORDER_TYPE	VARCHAR2	(30)	Yes
SALESPERSON	VARCHAR2	(4000)
BILL_TO_LOCATION	VARCHAR2	(40)
BILL_TO_ADDRESS1	VARCHAR2	(240)
BILL_TO_ADDRESS2	VARCHAR2	(240)
BILL_TO_ADDRESS3	VARCHAR2	(240)
BILL_TO_ADDRESS4	VARCHAR2	(240)
BILL_TO_CTY_ST_ZIP_CTRY	VARCHAR2	(246)
BILL_TO_CONTACT	VARCHAR2	(183)
PAYMENT_TERMS	VARCHAR2	(15)
INVOICING_RULE	VARCHAR2	(30)
DATE_ORDERED	DATE
CUSTOMER_PO_NUMBER	VARCHAR2	(50)
_LA:SALES_CHANNEL	CHAR	(62)
_LA:STATUS	CHAR	(58)
_LA:TAX_EXEMPTED	CHAR	(52)
_LA:TAX_EXEMPT_REASON	CHAR	(63)
TAX_EXEMPT_NUMBER	VARCHAR2	(80)
CURRENCY	VARCHAR2	(15)
PAYMENT_TYPE_CODE	VARCHAR2	(30)
_LA:SHIPMENT_PRIORITY	CHAR	(70)
_LA:FREIGHT_TERMS	CHAR	(62)
_LA:BOOKED_FLAG	CHAR	(48)
_LA:CANCELLED_FLAG	CHAR	(51)
ORG_ID	NUMBER
SOLD_FROM_ORG_ID	NUMBER
HEADER_ID	NUMBER		Yes
ORDER_TYPE_ID	NUMBER		Yes
CUSTOMER_CONTACT_ID	NUMBER
AGREEMENT_ID	NUMBER
PRICE_LIST_ID	NUMBER
SHIP_TO_ORG_ID	NUMBER
SHIP_TO_CONTACT_ID	NUMBER
SHIP_TO_CUSTOMER	VARCHAR2	(50)
SHIP_TO_CUSTOMER_ID	NUMBER	(15)
SHIP_FROM_ORG_ID	NUMBER
INVOICING_RULE_ID	NUMBER	(15)
BILL_TO_ORG_ID	NUMBER
BILL_TO_CONTACT_ID	NUMBER
BILL_TO_CUSTOMER	VARCHAR2	(50)
BILL_TO_CUSTOMER_ID	NUMBER	(15)
PAYMENT_TERM_ID	NUMBER	(15)
ORDER_SOURCE_ID	NUMBER
ORIG_SYS_DOCUMENT_REF	VARCHAR2	(50)
SALESPERSON_ID	NUMBER	(15)
_DF:HEADER	CHAR	(35)
_DF:GLOBAL	CHAR	(41)
_DF:TP	CHAR	(38)
BOOKED_DATE	DATE
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
LAST_UPDATED_BY_NAME	VARCHAR2	(100)
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
CREATED_BY_NAME	VARCHAR2	(100)
VERSION_NUMBER	NUMBER		Yes
EXPIRATION_DATE	DATE
SOURCE_DOCUMENT_TYPE_ID	NUMBER
CHANGE_SEQUENCE	VARCHAR2	(50)
SOURCE_DOCUMENT_ID	NUMBER
REQUEST_DATE	DATE
PRICING_DATE	DATE
DEMAND_CLASS_CODE	VARCHAR2	(30)
PRICE_REQUEST_CODE	VARCHAR2	(240)
CONVERSION_RATE	NUMBER
CONVERSION_TYPE_CODE	VARCHAR2	(30)
CONVERSION_RATE_DATE	DATE
_LA:PARTIAL_SHIPMENTS	CHAR	(62)
SHIP_TOLERANCE_ABOVE	NUMBER
SHIP_TOLERANCE_BELOW	NUMBER
_LA:TAX_POINT	CHAR	(54)
_LA:OPEN_FLAG	CHAR	(46)
ACCOUNTING_RULE_ID	NUMBER	(15)
ACCOUNTING_RULE_DURATION	NUMBER	(15)
_LA:SHIPPING_METHOD	CHAR	(69)
FREIGHT_CARRIER_CODE	VARCHAR2	(30)
FOB_POINT_CODE	VARCHAR2	(30)
SOLD_TO_ORG_ID	NUMBER
DELIVER_TO_ORG_ID	NUMBER
DELIVER_TO_CONTACT_ID	NUMBER
RETURN_REASON_CODE	VARCHAR2	(30)
ORDER_DATE_TYPE_CODE	VARCHAR2	(30)
EARLIEST_SCHEDULE_LIMIT	NUMBER
LATEST_SCHEDULE_LIMIT	NUMBER
PAYMENT_AMOUNT	NUMBER
CHECK_NUMBER	VARCHAR2	(50)
CREDIT_CARD_CODE	VARCHAR2	(80)
CREDIT_CARD_HOLDER_NAME	VARCHAR2	(80)
CREDIT_CARD_NUMBER	VARCHAR2	(80)
CREDIT_CARD_EXPIRATION_DATE	DATE
CREDIT_CARD_APPROVAL_CODE	VARCHAR2	(80)
FIRST_ACK_CODE	VARCHAR2	(30)
FIRST_ACK_DATE	DATE
LAST_ACK_CODE	VARCHAR2	(30)
LAST_ACK_DATE	DATE
_LA:ORDER_CATEGORY_CODE	CHAR	(64)
SHIPPING_INSTRUCTIONS	VARCHAR2	(2000)
PACKING_INSTRUCTIONS	VARCHAR2	(2000)
CREDIT_CARD_APPROVAL_DATE	DATE
CUSTOMER_PREFERENCE_SET_CODE	VARCHAR2	(30)
MARKETING_SOURCE_CODE_ID	NUMBER
UPGRADED_FLAG	VARCHAR2	(1)
TRANSACTION_PHASE_CODE	VARCHAR2	(30)
ORDER_FIRMED_DATE	DATE

Query Text

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


SELECT ORDER_NUMBER
,      CUSTOMER_NUMBER
,      CUSTOMER
,      CUSTOMER_CONTACT
,      CUSTOMER_CONTACT_EMAIL
,      CUSTOMER_CONTACT_PHONE_NUMBER
,      CUSTOMER_CONTACT_PHONE_EXT
,      AGREEMENT
,      PRICE_LIST
,      SHIP_TO_LOCATION
,      SHIP_TO_ADDRESS1
,      SHIP_TO_ADDRESS2
,      SHIP_TO_ADDRESS3
,      SHIP_TO_ADDRESS4
,      SHIP_TO_CTY_ST_ZIP_CTRY
,      SHIP_TO_CONTACT
,      SHIP_FROM_ORG
,      ORDER_SOURCE
,      ORDER_TYPE
,      SALESPERSON
,      BILL_TO_LOCATION
,      BILL_TO_ADDRESS1
,      BILL_TO_ADDRESS2
,      BILL_TO_ADDRESS3
,      BILL_TO_ADDRESS4
,      BILL_TO_CTY_ST_ZIP_CTRY
,      BILL_TO_CONTACT
,      PAYMENT_TERMS
,      INVOICING_RULE
,      DATE_ORDERED
,      CUSTOMER_PO_NUMBER
,      _LA:SALES_CHANNEL
,      _LA:STATUS
,      _LA:TAX_EXEMPTED
,      _LA:TAX_EXEMPT_REASON
,      TAX_EXEMPT_NUMBER
,      CURRENCY
,      PAYMENT_TYPE_CODE
,      _LA:SHIPMENT_PRIORITY
,      _LA:FREIGHT_TERMS
,      _LA:BOOKED_FLAG
,      _LA:CANCELLED_FLAG
,      ORG_ID
,      SOLD_FROM_ORG_ID
,      HEADER_ID
,      ORDER_TYPE_ID
,      CUSTOMER_CONTACT_ID
,      AGREEMENT_ID
,      PRICE_LIST_ID
,      SHIP_TO_ORG_ID
,      SHIP_TO_CONTACT_ID
,      SHIP_TO_CUSTOMER
,      SHIP_TO_CUSTOMER_ID
,      SHIP_FROM_ORG_ID
,      INVOICING_RULE_ID
,      BILL_TO_ORG_ID
,      BILL_TO_CONTACT_ID
,      BILL_TO_CUSTOMER
,      BILL_TO_CUSTOMER_ID
,      PAYMENT_TERM_ID
,      ORDER_SOURCE_ID
,      ORIG_SYS_DOCUMENT_REF
,      SALESPERSON_ID
,      _DF:HEADER
,      _DF:GLOBAL
,      _DF:TP
,      BOOKED_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATED_BY_NAME
,      CREATION_DATE
,      CREATED_BY
,      CREATED_BY_NAME
,      VERSION_NUMBER
,      EXPIRATION_DATE
,      SOURCE_DOCUMENT_TYPE_ID
,      CHANGE_SEQUENCE
,      SOURCE_DOCUMENT_ID
,      REQUEST_DATE
,      PRICING_DATE
,      DEMAND_CLASS_CODE
,      PRICE_REQUEST_CODE
,      CONVERSION_RATE
,      CONVERSION_TYPE_CODE
,      CONVERSION_RATE_DATE
,      _LA:PARTIAL_SHIPMENTS
,      SHIP_TOLERANCE_ABOVE
,      SHIP_TOLERANCE_BELOW
,      _LA:TAX_POINT
,      _LA:OPEN_FLAG
,      ACCOUNTING_RULE_ID
,      ACCOUNTING_RULE_DURATION
,      _LA:SHIPPING_METHOD
,      FREIGHT_CARRIER_CODE
,      FOB_POINT_CODE
,      SOLD_TO_ORG_ID
,      DELIVER_TO_ORG_ID
,      DELIVER_TO_CONTACT_ID
,      RETURN_REASON_CODE
,      ORDER_DATE_TYPE_CODE
,      EARLIEST_SCHEDULE_LIMIT
,      LATEST_SCHEDULE_LIMIT
,      PAYMENT_AMOUNT
,      CHECK_NUMBER
,      CREDIT_CARD_CODE
,      CREDIT_CARD_HOLDER_NAME
,      CREDIT_CARD_NUMBER
,      CREDIT_CARD_EXPIRATION_DATE
,      CREDIT_CARD_APPROVAL_CODE
,      FIRST_ACK_CODE
,      FIRST_ACK_DATE
,      LAST_ACK_CODE
,      LAST_ACK_DATE
,      _LA:ORDER_CATEGORY_CODE
,      SHIPPING_INSTRUCTIONS
,      PACKING_INSTRUCTIONS
,      CREDIT_CARD_APPROVAL_DATE
,      CUSTOMER_PREFERENCE_SET_CODE
,      MARKETING_SOURCE_CODE_ID
,      UPGRADED_FLAG
,      TRANSACTION_PHASE_CODE
,      ORDER_FIRMED_DATE
FROM APPS.OEFV_ORDER_HEADERS;

Dependencies

[top of page]

APPS.OEFV_ORDER_HEADERS references the following:

APPS: AR_LOOKUPS; FND_CURRENCIES; FND_USER; HZ_CONTACT_POINTS; HZ_CUST_ACCOUNTS; HZ_CUST_ACCOUNT_ROLES; HZ_CUST_ACCT_SITES_ALL; HZ_CUST_SITE_USES_ALL; HZ_LOCATIONS; HZ_PARTIES; HZ_PARTY_SITES; HZ_RELATIONSHIPS; MTL_PARAMETERS; OE_AGREEMENTS_TL; OE_BIS_SALESPERSON - show dependent code; OE_ORDER_HEADERS_ALL; OE_ORDER_SOURCES; OE_TRANSACTION_TYPES_TL; QP_LIST_HEADERS_TL; RA_RULES; RA_TERMS

APPS.OEFV_ORDER_HEADERS is not referenced by any database object