DBA Data[Home] [Help] [Dependency Information]

TABLE: JTF.JTY_DEA_ATTR_PRODUCTS

Object Details
Object Name: JTY_DEA_ATTR_PRODUCTS
Object Type: TABLE
Owner: JTF
FND Design Data: TableJTF.JTY_DEA_ATTR_PRODUCTS
Subobject Name:
Status: VALID


This table stores attribute product for date effectivity assignment.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
DEA_ATTR_PRODUCTS_ID NUMBER
Yes Primary key
ATTR_RELATION_PRODUCT NUMBER
Yes Attribute relation product
SOURCE_ID NUMBER
Yes Source ID
TRANS_TYPE_ID NUMBER
Yes Transaction type ID
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
FIRST_CHAR_FLAG VARCHAR2 (1)
First character flag
BUILD_INDEX_FLAG VARCHAR2 (1)
Build index flag
INDEX_NAME VARCHAR2 (30)
Index name
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_PRODUCTS_ID
,      ATTR_RELATION_PRODUCT
,      SOURCE_ID
,      TRANS_TYPE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      TERR_ANALYZE_ID
,      FIRST_CHAR_FLAG
,      BUILD_INDEX_FLAG
,      INDEX_NAME
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM JTF.JTY_DEA_ATTR_PRODUCTS;

Dependencies

[top of page]

JTF.JTY_DEA_ATTR_PRODUCTS does not reference any database object

JTF.JTY_DEA_ATTR_PRODUCTS is referenced by following:

SchemaJTF
ViewJTY_DEA_ATTR_PRODUCTS#