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: OZF.OZF_RES_CUST_PROD

Object Details

Object Name:	OZF_RES_CUST_PROD
Object Type:	TABLE
Owner:	OZF
FND Design Data:	OZF.OZF_RES_CUST_PROD
Subobject Name:
Status:	VALID

This table stores the customer and products eligible for a User to show data on the Account Manager Dashboard

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OZF_RES_CUST_PROD_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID PARTY_ID BILL_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID PRODUCT_ATTRIBUTE PRODUCT_ATTR_VALUE
OZF_RES_CUST_PROD_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID PRODUCT_ATTRIBUTE PRODUCT_ATTR_VALUE

Columns

Name	Datatype	Length	Mandatory	Comments
RESOURCE_ID	NUMBER		Yes	Resource Identifier
PARTY_ID	NUMBER			Party Identifier
CUST_ACCOUNT_ID	NUMBER			Customer Account Identifier
BILL_TO_SITE_USE_ID	NUMBER			Bill to site identifier
SHIP_TO_SITE_USE_ID	NUMBER			Ship to site identifier
PRODUCT_ATTRIBUTE	VARCHAR2	(30)		This column indicates if the value in product_attr_value is a inventory item or a category
PRODUCT_ATTR_VALUE	VARCHAR2	(240)		The value in this column will identify a inventory item or category based on product_attribute

Query Text

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


SELECT RESOURCE_ID
,      PARTY_ID
,      CUST_ACCOUNT_ID
,      BILL_TO_SITE_USE_ID
,      SHIP_TO_SITE_USE_ID
,      PRODUCT_ATTRIBUTE
,      PRODUCT_ATTR_VALUE
FROM OZF.OZF_RES_CUST_PROD;

Dependencies

[top of page]

OZF.OZF_RES_CUST_PROD does not reference any database object

OZF.OZF_RES_CUST_PROD is referenced by following:

OZF: OZF_RES_CUST_PROD#