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

Object Details

Object Name:	OZF_RESALE_HEADERS_V
Object Type:	VIEW
Owner:	APPS
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

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Mandatory
RESALE_HEADER_ID	NUMBER		Yes
DATE_SHIPPED	DATE
DATE_ORDERED	DATE
ORDER_TYPE_ID	NUMBER
ORDER_TYPE_NAME	VARCHAR2	(30)
ORDER_TYPE	VARCHAR2	(30)
ORDER_CATEGORY	VARCHAR2	(30)
STATUS_CODE	VARCHAR2	(30)
USER_STATUS	VARCHAR2	(80)	Yes
DIRECT_CUSTOMER_FLAG	VARCHAR2	(1)
ORDER_NUMBER	VARCHAR2	(50)
PRICE_LIST_ID	NUMBER
PRICE_LIST	VARCHAR2	(240)	Yes
BILL_TO_CUST_ACCOUNT_ID	NUMBER
BILL_TO_SITE_USE_ID	NUMBER
BILL_TO_PARTY_NAME	VARCHAR2	(360)
BILL_TO_PARTY_ID	NUMBER
BILL_TO_PARTY_SITE_ID	NUMBER
BILL_TO_LOCATION	VARCHAR2	(40)
BILL_TO_DUNS_NUMBER	VARCHAR2	(30)
BILL_TO_ADDRESS	VARCHAR2	(240)
BILL_TO_CITY	VARCHAR2	(60)
BILL_TO_STATE	VARCHAR2	(60)
BILL_TO_POSTAL_CODE	VARCHAR2	(60)
BILL_TO_COUNTRY	VARCHAR2	(60)
BILL_TO_CONTACT_PARTY_ID	NUMBER
BILL_TO_CONTACT_NAME	VARCHAR2	(360)
BILL_TO_EMAIL	VARCHAR2	(2000)
BILL_TO_PHONE	VARCHAR2	(60)
BILL_TO_FAX	VARCHAR2	(60)
SHIP_TO_CUST_ACCOUNT_ID	NUMBER
SHIP_TO_SITE_USE_ID	NUMBER
SHIP_TO_PARTY_NAME	VARCHAR2	(360)
SHIP_TO_PARTY_ID	NUMBER
SHIP_TO_PARTY_SITE_ID	NUMBER
SHIP_TO_LOCATION	VARCHAR2	(40)
SHIP_TO_DUNS_NUMBER	VARCHAR2	(30)
SHIP_TO_ADDRESS	VARCHAR2	(240)
SHIP_TO_CITY	VARCHAR2	(60)
SHIP_TO_STATE	VARCHAR2	(60)
SHIP_TO_POSTAL_CODE	VARCHAR2	(60)
SHIP_TO_COUNTRY	VARCHAR2	(60)
SHIP_TO_CONTACT_PARTY_ID	NUMBER
SHIP_TO_CONTACT_NAME	VARCHAR2	(360)
SHIP_TO_EMAIL	VARCHAR2	(2000)
SHIP_TO_FAX	VARCHAR2	(60)
SHIP_TO_PHONE	VARCHAR2	(60)
SOLD_FROM_CUST_ACCOUNT_ID	NUMBER
SOLD_FROM_PARTY_NAME	VARCHAR2	(360)	Yes
SHIP_FROM_CUST_ACCOUNT_ID	NUMBER
SHIP_FROM_PARTY_NAME	VARCHAR2	(360)	Yes

Query Text

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


SELECT RESALE_HEADER_ID
,      DATE_SHIPPED
,      DATE_ORDERED
,      ORDER_TYPE_ID
,      ORDER_TYPE_NAME
,      ORDER_TYPE
,      ORDER_CATEGORY
,      STATUS_CODE
,      USER_STATUS
,      DIRECT_CUSTOMER_FLAG
,      ORDER_NUMBER
,      PRICE_LIST_ID
,      PRICE_LIST
,      BILL_TO_CUST_ACCOUNT_ID
,      BILL_TO_SITE_USE_ID
,      BILL_TO_PARTY_NAME
,      BILL_TO_PARTY_ID
,      BILL_TO_PARTY_SITE_ID
,      BILL_TO_LOCATION
,      BILL_TO_DUNS_NUMBER
,      BILL_TO_ADDRESS
,      BILL_TO_CITY
,      BILL_TO_STATE
,      BILL_TO_POSTAL_CODE
,      BILL_TO_COUNTRY
,      BILL_TO_CONTACT_PARTY_ID
,      BILL_TO_CONTACT_NAME
,      BILL_TO_EMAIL
,      BILL_TO_PHONE
,      BILL_TO_FAX
,      SHIP_TO_CUST_ACCOUNT_ID
,      SHIP_TO_SITE_USE_ID
,      SHIP_TO_PARTY_NAME
,      SHIP_TO_PARTY_ID
,      SHIP_TO_PARTY_SITE_ID
,      SHIP_TO_LOCATION
,      SHIP_TO_DUNS_NUMBER
,      SHIP_TO_ADDRESS
,      SHIP_TO_CITY
,      SHIP_TO_STATE
,      SHIP_TO_POSTAL_CODE
,      SHIP_TO_COUNTRY
,      SHIP_TO_CONTACT_PARTY_ID
,      SHIP_TO_CONTACT_NAME
,      SHIP_TO_EMAIL
,      SHIP_TO_FAX
,      SHIP_TO_PHONE
,      SOLD_FROM_CUST_ACCOUNT_ID
,      SOLD_FROM_PARTY_NAME
,      SHIP_FROM_CUST_ACCOUNT_ID
,      SHIP_FROM_PARTY_NAME
FROM APPS.OZF_RESALE_HEADERS_V;

Dependencies

[top of page]

APPS.OZF_RESALE_HEADERS_V references the following:

APPS: HZ_CUST_ACCOUNTS; HZ_PARTIES; OE_TRANSACTION_TYPES_VL; OZF_LOOKUPS; OZF_RESALE_HEADERS_ALL; QP_LIST_HEADERS

APPS.OZF_RESALE_HEADERS_V is not referenced by any database object