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.IBE_ORDER_HEADER_V

Object Details

Object Name:	IBE_ORDER_HEADER_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IBE.IBE_ORDER_HEADER_V
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
HEADER_ID	NUMBER		Yes
ORG_ID	NUMBER
REFERENCE_TYPE	NUMBER
CREATED_BY	NUMBER		Yes
REFERENCE_NUMBER	NUMBER
WEB_CONFIRM_NUMBER	VARCHAR2	(50)
ORDER_NUMBER	NUMBER		Yes
ORDER_CATEGORY_CODE	VARCHAR2	(30)	Yes
ORDER_TYPE	VARCHAR2	(30)	Yes
ORDER_TOTAL	NUMBER
LINES_TOTAL	NUMBER
TAXES_TOTAL	NUMBER
CHARGES_TOTAL	NUMBER
OE_INSTALMENT_OPTIONS	VARCHAR2	(4000)
OE_RECURRING_CHARGES	VARCHAR2	(4000)
PAYNOW_ORDER_TOTAL	NUMBER
PAYNOW_LINES_TOTAL	NUMBER
PAYNOW_TAXES_TOTAL	NUMBER
PAYNOW_CHARGES_TOTAL	NUMBER
ORDER_STATUS	VARCHAR2	(30)
ORDER_STATUS_MEANING	VARCHAR2	(80)
ORDERED_DATE	DATE
BOOKED_DATE	DATE
LAST_UPDATE_DATE	DATE		Yes
CUST_ACCOUNT_ID	NUMBER
PARTY_ID	NUMBER	(15)	Yes
CUSTOMER_NAME	VARCHAR2	(360)	Yes
SOLD_TO_CONTACT_ID	NUMBER
SOLD_TO_CONTACT_NAME	VARCHAR2	(301)
SOLD_TO_CONTACT_PHONE_EMAIL	VARCHAR2	(4000)
TRANSACTIONAL_CURR_CODE	VARCHAR2	(15)
CUST_PO_NUMBER	VARCHAR2	(50)
CREDIT_CARD_NUMBER	VARCHAR2	(4)
CREDIT_CARD_CODE	VARCHAR2	(80)
CREDIT_CARD_TYPE	VARCHAR2	(80)
PAYMENT_TERM_ID	NUMBER	(15)
PAYMENT_TERM	VARCHAR2	(15)
PAYMENT_TYPE_CODE	VARCHAR2	(30)
PAYMENT_TYPE	VARCHAR2	(80)
AGREEMENT_ID	NUMBER
AGREEMENT_NAME	VARCHAR2	(240)
INVOICE_TO_ORG_ID	NUMBER
BILL_TO_CUSTOMER_ID	NUMBER	(15)
BILL_TO_CUSTOMER_NAME	VARCHAR2	(360)
BILL_TO_CONTACT_ID	NUMBER
BILL_TO_CONTACT_NAME	VARCHAR2	(301)
BILL_TO_LOCATION	VARCHAR2	(121)
BILL_TO_ADDRESS1	VARCHAR2	(240)
BILL_TO_ADDRESS2	VARCHAR2	(240)
BILL_TO_ADDRESS3	VARCHAR2	(240)
BILL_TO_ADDRESS4	VARCHAR2	(240)
BILL_TO_ADDRESS_LINES_PHONETIC	VARCHAR2	(560)
BILL_TO_CITY	VARCHAR2	(60)
BILL_TO_STATE	VARCHAR2	(60)
BILL_TO_POSTAL_CODE	VARCHAR2	(60)
BILL_TO_COUNTY	VARCHAR2	(60)
BILL_TO_PROVINCE	VARCHAR2	(60)
BILL_TO_COUNTRY	VARCHAR2	(60)
BILL_TO_COUNTRY_CODE	VARCHAR2	(0)
SHIP_TO_ORG_ID	NUMBER
SHIP_TO_CUSTOMER_ID	NUMBER	(15)
SHIP_TO_CUSTOMER_NAME	VARCHAR2	(360)
SHIP_TO_CONTACT_ID	NUMBER
SHIP_TO_CONTACT_NAME	VARCHAR2	(301)
SHIP_TO_LOCATION	VARCHAR2	(121)
SHIP_TO_ADDRESS1	VARCHAR2	(240)
SHIP_TO_ADDRESS2	VARCHAR2	(240)
SHIP_TO_ADDRESS3	VARCHAR2	(240)
SHIP_TO_ADDRESS4	VARCHAR2	(240)
SHIP_TO_ADDRESS_LINES_PHONETIC	VARCHAR2	(560)
SHIP_TO_CITY	VARCHAR2	(60)
SHIP_TO_STATE	VARCHAR2	(60)
SHIP_TO_POSTAL_CODE	VARCHAR2	(60)
SHIP_TO_COUNTY	VARCHAR2	(60)
SHIP_TO_PROVINCE	VARCHAR2	(60)
SHIP_TO_COUNTRY	VARCHAR2	(60)
SHIP_TO_COUNTRY_CODE	VARCHAR2	(0)
END_CUSTOMER_ID	NUMBER
END_CUSTOMER_NAME	VARCHAR2	(360)
END_CUSTOMER_CONTACT_ID	NUMBER
ENDCUST_CONTACT_NAME	VARCHAR2	(301)
ENDCUST_LOCATION	VARCHAR2	(121)
ENDCUST_ADDRESS1	VARCHAR2	(240)
ENDCUST_ADDRESS2	VARCHAR2	(240)
ENDCUST_ADDRESS3	VARCHAR2	(240)
ENDCUST_ADDRESS4	VARCHAR2	(240)
ENDCUST_ADDRESS_LINES_PHONETIC	VARCHAR2	(560)
ENDCUST_CITY	VARCHAR2	(60)
ENDCUST_STATE	VARCHAR2	(60)
ENDCUST_POSTAL_CODE	VARCHAR2	(60)
ENDCUST_COUNTY	VARCHAR2	(60)
ENDCUST_PROVINCE	VARCHAR2	(60)
ENDCUST_COUNTRY	VARCHAR2	(60)
SHIPPING_METHOD_CODE	VARCHAR2	(30)
SHIPPING_METHOD_DESC	VARCHAR2	(80)
FREIGHT_TERMS_CODE	VARCHAR2	(30)
FREIGHT_TERMS	VARCHAR2	(80)
SHIPMENT_PRIORITY_CODE	VARCHAR2	(30)
SHIPMENT_PRIORITY_CODE_MNG	VARCHAR2	(80)
PARTIAL_SHIPMENTS_ALLOWED	VARCHAR2	(1)
REQUEST_DATE	DATE
TAX_EXEMPT_FLAG	VARCHAR2	(1)
SHIPPING_INSTRUCTIONS	VARCHAR2	(2000)
PACKING_INSTRUCTIONS	VARCHAR2	(2000)
CONTEXT	VARCHAR2	(30)
ATTRIBUTE1	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(240)		Descriptive Flexfield segment
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE1	VARCHAR2	(240)		Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE2	VARCHAR2	(240)		Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE3	VARCHAR2	(240)		Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE4	VARCHAR2	(240)		Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE5	VARCHAR2	(240)		Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE6	VARCHAR2	(240)		Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE7	VARCHAR2	(240)		Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE8	VARCHAR2	(240)		Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE9	VARCHAR2	(240)		Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE10	VARCHAR2	(240)		Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE11	VARCHAR2	(240)		Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE12	VARCHAR2	(240)		Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE13	VARCHAR2	(240)		Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE14	VARCHAR2	(240)		Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE15	VARCHAR2	(240)		Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE16	VARCHAR2	(240)		Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE17	VARCHAR2	(240)		Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE18	VARCHAR2	(240)		Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE19	VARCHAR2	(240)		Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE20	VARCHAR2	(240)		Reserved for country-specific functionality.
BILL_TO_ACCOUNT_ID	NUMBER	(15)
BILL_TO_ACCOUNT_SITE_ID	NUMBER	(15)

Query Text

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


SELECT HEADER_ID
,      ORG_ID
,      REFERENCE_TYPE
,      CREATED_BY
,      REFERENCE_NUMBER
,      WEB_CONFIRM_NUMBER
,      ORDER_NUMBER
,      ORDER_CATEGORY_CODE
,      ORDER_TYPE
,      ORDER_TOTAL
,      LINES_TOTAL
,      TAXES_TOTAL
,      CHARGES_TOTAL
,      OE_INSTALMENT_OPTIONS
,      OE_RECURRING_CHARGES
,      PAYNOW_ORDER_TOTAL
,      PAYNOW_LINES_TOTAL
,      PAYNOW_TAXES_TOTAL
,      PAYNOW_CHARGES_TOTAL
,      ORDER_STATUS
,      ORDER_STATUS_MEANING
,      ORDERED_DATE
,      BOOKED_DATE
,      LAST_UPDATE_DATE
,      CUST_ACCOUNT_ID
,      PARTY_ID
,      CUSTOMER_NAME
,      SOLD_TO_CONTACT_ID
,      SOLD_TO_CONTACT_NAME
,      SOLD_TO_CONTACT_PHONE_EMAIL
,      TRANSACTIONAL_CURR_CODE
,      CUST_PO_NUMBER
,      CREDIT_CARD_NUMBER
,      CREDIT_CARD_CODE
,      CREDIT_CARD_TYPE
,      PAYMENT_TERM_ID
,      PAYMENT_TERM
,      PAYMENT_TYPE_CODE
,      PAYMENT_TYPE
,      AGREEMENT_ID
,      AGREEMENT_NAME
,      INVOICE_TO_ORG_ID
,      BILL_TO_CUSTOMER_ID
,      BILL_TO_CUSTOMER_NAME
,      BILL_TO_CONTACT_ID
,      BILL_TO_CONTACT_NAME
,      BILL_TO_LOCATION
,      BILL_TO_ADDRESS1
,      BILL_TO_ADDRESS2
,      BILL_TO_ADDRESS3
,      BILL_TO_ADDRESS4
,      BILL_TO_ADDRESS_LINES_PHONETIC
,      BILL_TO_CITY
,      BILL_TO_STATE
,      BILL_TO_POSTAL_CODE
,      BILL_TO_COUNTY
,      BILL_TO_PROVINCE
,      BILL_TO_COUNTRY
,      BILL_TO_COUNTRY_CODE
,      SHIP_TO_ORG_ID
,      SHIP_TO_CUSTOMER_ID
,      SHIP_TO_CUSTOMER_NAME
,      SHIP_TO_CONTACT_ID
,      SHIP_TO_CONTACT_NAME
,      SHIP_TO_LOCATION
,      SHIP_TO_ADDRESS1
,      SHIP_TO_ADDRESS2
,      SHIP_TO_ADDRESS3
,      SHIP_TO_ADDRESS4
,      SHIP_TO_ADDRESS_LINES_PHONETIC
,      SHIP_TO_CITY
,      SHIP_TO_STATE
,      SHIP_TO_POSTAL_CODE
,      SHIP_TO_COUNTY
,      SHIP_TO_PROVINCE
,      SHIP_TO_COUNTRY
,      SHIP_TO_COUNTRY_CODE
,      END_CUSTOMER_ID
,      END_CUSTOMER_NAME
,      END_CUSTOMER_CONTACT_ID
,      ENDCUST_CONTACT_NAME
,      ENDCUST_LOCATION
,      ENDCUST_ADDRESS1
,      ENDCUST_ADDRESS2
,      ENDCUST_ADDRESS3
,      ENDCUST_ADDRESS4
,      ENDCUST_ADDRESS_LINES_PHONETIC
,      ENDCUST_CITY
,      ENDCUST_STATE
,      ENDCUST_POSTAL_CODE
,      ENDCUST_COUNTY
,      ENDCUST_PROVINCE
,      ENDCUST_COUNTRY
,      SHIPPING_METHOD_CODE
,      SHIPPING_METHOD_DESC
,      FREIGHT_TERMS_CODE
,      FREIGHT_TERMS
,      SHIPMENT_PRIORITY_CODE
,      SHIPMENT_PRIORITY_CODE_MNG
,      PARTIAL_SHIPMENTS_ALLOWED
,      REQUEST_DATE
,      TAX_EXEMPT_FLAG
,      SHIPPING_INSTRUCTIONS
,      PACKING_INSTRUCTIONS
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      BILL_TO_ACCOUNT_ID
,      BILL_TO_ACCOUNT_SITE_ID
FROM APPS.IBE_ORDER_HEADER_V;

Dependencies

[top of page]

APPS.IBE_ORDER_HEADER_V references the following:

APPS: HZ_CUST_ACCOUNTS; HZ_CUST_ACCT_SITES_ALL; HZ_CUST_SITE_USES_ALL; HZ_LOCATIONS; HZ_PARTIES; HZ_PARTY_SITES; IBE_OE_CONTACTS_V; IBE_ORDER_UTIL_PVT - show dependent code; OE_AGREEMENTS_TL; OE_LOOKUPS; OE_ORDER_HEADERS_ALL; OE_SHIP_METHODS_V; OE_SYS_PARAMETERS - show dependent code; OE_TOTALS_GRP - show dependent code; OE_TRANSACTION_TYPES_TL; RA_TERMS_TL

APPS.IBE_ORDER_HEADER_V is not referenced by any database object