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: JTF.JTY_DEA_ATTR_PROD_FACTORS

Object Details

Object Name:	JTY_DEA_ATTR_PROD_FACTORS
Object Type:	TABLE
Owner:	JTF
FND Design Data:	JTF.JTY_DEA_ATTR_PROD_FACTORS
Subobject Name:
Status:	VALID

This table stores attribute product factors for date effectivity assignment.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Mandatory	Comments
DEA_ATTR_PROD_FACTORS_ID	NUMBER	Yes	Primary key
DEA_ATTR_PRODUCTS_ID	NUMBER	Yes	Foreign key to JTY_DEA_ATTR_PRODUCTS
DEA_ATTR_FACTORS_ID	NUMBER	Yes	Foreign key to JTY_DEA_ATTR_FACTORS
LAST_UPDATE_DATE	DATE	Yes	Standard who column
LAST_UPDATED_BY	NUMBER	Yes	Standard who column
CREATION_DATE	DATE	Yes	Standard who column
CREATED_BY	NUMBER	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER		Standard who column
TERR_ANALYZE_ID	NUMBER		Territory analyze ID
SECURITY_GROUP_ID	NUMBER		used in hosted environments
OBJECT_VERSION_NUMBER	NUMBER		Object version number

Query Text

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


SELECT DEA_ATTR_PROD_FACTORS_ID
,      DEA_ATTR_PRODUCTS_ID
,      DEA_ATTR_FACTORS_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      TERR_ANALYZE_ID
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM JTF.JTY_DEA_ATTR_PROD_FACTORS;

Dependencies

[top of page]

JTF.JTY_DEA_ATTR_PROD_FACTORS does not reference any database object

JTF.JTY_DEA_ATTR_PROD_FACTORS is referenced by following:

APPS: JTY_DEA_ATTR_PROD_FACTORS