Skip to content

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

TABLE: FII.FII_PRODUCT_ASSIGNMENTS

Object Details
Object Name: FII_PRODUCT_ASSIGNMENTS
Object Type: TABLE
Owner: FII
FND Design Data: TableFII.FII_PRODUCT_ASSIGNMENTS
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.

Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
RECORD_ID NUMBER (15)
Record Identifier
PRODUCT_CODE VARCHAR2 (150)
Product Code
CHART_OF_ACCOUNTS_ID NUMBER (15)
Chart of Accounts Identifier
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SEGMENT1_LOW VARCHAR2 (25)
Low Value of Segement 1
SEGMENT1_HIGH VARCHAR2 (25)
High Value of Segment 1
SEGMENT2_LOW VARCHAR2 (25)
Low Value of Segement 2
SEGMENT2_HIGH VARCHAR2 (25)
High Value of Segment 2
SEGMENT3_LOW VARCHAR2 (25)
Low Value of Segement 3
SEGMENT3_HIGH VARCHAR2 (25)
High Value of Segment 3
SEGMENT4_LOW VARCHAR2 (25)
Low Value of Segement 4
SEGMENT4_HIGH VARCHAR2 (25)
High Value of Segment 4
SEGMENT5_LOW VARCHAR2 (25)
Low Value of Segement 5
SEGMENT5_HIGH VARCHAR2 (25)
High Value of Segment 5
SEGMENT6_LOW VARCHAR2 (25)
Low Value of Segement 6
SEGMENT6_HIGH VARCHAR2 (25)
High Value of Segment 6
SEGMENT7_LOW VARCHAR2 (25)
Low Value of Segement 7
SEGMENT7_HIGH VARCHAR2 (25)
High Value of Segment 7
SEGMENT8_LOW VARCHAR2 (25)
Low Value of Segement 8
SEGMENT8_HIGH VARCHAR2 (25)
High Value of Segment 8
SEGMENT9_LOW VARCHAR2 (25)
Low Value of Segement 9
SEGMENT9_HIGH VARCHAR2 (25)
High Value of Segment 9
SEGMENT10_LOW VARCHAR2 (25)
Low Value of Segement 10
SEGMENT10_HIGH VARCHAR2 (25)
High Value of Segment 10
SEGMENT11_LOW VARCHAR2 (25)
Low Value of Segement 11
SEGMENT11_HIGH VARCHAR2 (25)
High Value of Segment 11
SEGMENT12_LOW VARCHAR2 (25)
Low Value of Segement 12
SEGMENT12_HIGH VARCHAR2 (25)
High Value of Segment 12
SEGMENT13_LOW VARCHAR2 (25)
Low Value of Segement 13
SEGMENT13_HIGH VARCHAR2 (25)
High Value of Segment 13
SEGMENT14_LOW VARCHAR2 (25)
Low Value of Segement 14
SEGMENT14_HIGH VARCHAR2 (25)
High Value of Segment 14
SEGMENT15_LOW VARCHAR2 (25)
Low Value of Segement 15
SEGMENT15_HIGH VARCHAR2 (25)
High Value of Segment 15
SEGMENT16_LOW VARCHAR2 (25)
Low Value of Segement 16
SEGMENT16_HIGH VARCHAR2 (25)
High Value of Segment 16
SEGMENT17_LOW VARCHAR2 (25)
Low Value of Segement 17
SEGMENT17_HIGH VARCHAR2 (25)
High Value of Segment 17
SEGMENT18_LOW VARCHAR2 (25)
Low Value of Segement 18
SEGMENT18_HIGH VARCHAR2 (25)
High Value of Segment 18
SEGMENT19_LOW VARCHAR2 (25)
Low Value of Segement 19
SEGMENT19_HIGH VARCHAR2 (25)
High Value of Segment 19
SEGMENT20_LOW VARCHAR2 (25)
Low Value of Segement 20
SEGMENT20_HIGH VARCHAR2 (25)
High Value of Segment 20
SEGMENT21_LOW VARCHAR2 (25)
Low Value of Segement 21
SEGMENT21_HIGH VARCHAR2 (25)
High Value of Segment 21
SEGMENT22_LOW VARCHAR2 (25)
Low Value of Segement 22
SEGMENT22_HIGH VARCHAR2 (25)
High Value of Segment 22
SEGMENT23_LOW VARCHAR2 (25)
Low Value of Segement 23
SEGMENT23_HIGH VARCHAR2 (25)
High Value of Segment 23
SEGMENT24_LOW VARCHAR2 (25)
Low Value of Segement 24
SEGMENT24_HIGH VARCHAR2 (25)
High Value of Segment 24
SEGMENT25_LOW VARCHAR2 (25)
Low Value of Segement 25
SEGMENT25_HIGH VARCHAR2 (25)
High Value of Segment 25
SEGMENT26_LOW VARCHAR2 (25)
Low Value of Segement 26
SEGMENT26_HIGH VARCHAR2 (25)
High Value of Segment 26
SEGMENT27_LOW VARCHAR2 (25)
Low Value of Segement 27
SEGMENT27_HIGH VARCHAR2 (25)
High Value of Segment 27
SEGMENT28_LOW VARCHAR2 (25)
Low Value of Segement 28
SEGMENT28_HIGH VARCHAR2 (25)
High Value of Segment 28
SEGMENT29_LOW VARCHAR2 (25)
Low Value of Segement 29
SEGMENT29_HIGH VARCHAR2 (25)
High Value of Segment 29
SEGMENT30_LOW VARCHAR2 (25)
Low Value of Segement 30
SEGMENT30_HIGH VARCHAR2 (25)
High Value of Segment 30+D462
CONTEXT VARCHAR2 (150)
The Flexfield Structure Context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
PROD_CATEGORY_SET_ID NUMBER (15)
Product Category Set identifier
PROD_CATEGORY_ID NUMBER (15)
Product Category identifier
Query Text

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


SELECT RECORD_ID
,      PRODUCT_CODE
,      CHART_OF_ACCOUNTS_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SEGMENT1_LOW
,      SEGMENT1_HIGH
,      SEGMENT2_LOW
,      SEGMENT2_HIGH
,      SEGMENT3_LOW
,      SEGMENT3_HIGH
,      SEGMENT4_LOW
,      SEGMENT4_HIGH
,      SEGMENT5_LOW
,      SEGMENT5_HIGH
,      SEGMENT6_LOW
,      SEGMENT6_HIGH
,      SEGMENT7_LOW
,      SEGMENT7_HIGH
,      SEGMENT8_LOW
,      SEGMENT8_HIGH
,      SEGMENT9_LOW
,      SEGMENT9_HIGH
,      SEGMENT10_LOW
,      SEGMENT10_HIGH
,      SEGMENT11_LOW
,      SEGMENT11_HIGH
,      SEGMENT12_LOW
,      SEGMENT12_HIGH
,      SEGMENT13_LOW
,      SEGMENT13_HIGH
,      SEGMENT14_LOW
,      SEGMENT14_HIGH
,      SEGMENT15_LOW
,      SEGMENT15_HIGH
,      SEGMENT16_LOW
,      SEGMENT16_HIGH
,      SEGMENT17_LOW
,      SEGMENT17_HIGH
,      SEGMENT18_LOW
,      SEGMENT18_HIGH
,      SEGMENT19_LOW
,      SEGMENT19_HIGH
,      SEGMENT20_LOW
,      SEGMENT20_HIGH
,      SEGMENT21_LOW
,      SEGMENT21_HIGH
,      SEGMENT22_LOW
,      SEGMENT22_HIGH
,      SEGMENT23_LOW
,      SEGMENT23_HIGH
,      SEGMENT24_LOW
,      SEGMENT24_HIGH
,      SEGMENT25_LOW
,      SEGMENT25_HIGH
,      SEGMENT26_LOW
,      SEGMENT26_HIGH
,      SEGMENT27_LOW
,      SEGMENT27_HIGH
,      SEGMENT28_LOW
,      SEGMENT28_HIGH
,      SEGMENT29_LOW
,      SEGMENT29_HIGH
,      SEGMENT30_LOW
,      SEGMENT30_HIGH
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PROD_CATEGORY_SET_ID
,      PROD_CATEGORY_ID
FROM FII.FII_PRODUCT_ASSIGNMENTS;

Dependencies

[top of page]

FII.FII_PRODUCT_ASSIGNMENTS does not reference any database object

FII.FII_PRODUCT_ASSIGNMENTS is referenced by following:

SchemaAPPS
SynonymFII_PRODUCT_ASSIGNMENTS