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

TABLE: OSM.AS_INTEREST_CODES_ALL

Object Details
Object Name: AS_INTEREST_CODES_ALL
Object Type: TABLE
Owner: OSM
FND Design Data: TableAS.AS_INTEREST_CODES_ALL
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_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AS_INTEREST_CODES_ALL_U2 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnINTEREST_CODE_ID
ColumnORG_ID
Columns
Name Datatype Length Mandatory Comments
INTEREST_CODE_ID NUMBER
Yes Interest code identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
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
Yes Standard who column
REQUEST_ID NUMBER

Obsolete. Moved to _B table.
PROGRAM_APPLICATION_ID NUMBER

Obsolete. Moved to _B table.
PROGRAM_ID NUMBER

Obsolete. Moved to _B table.
PROGRAM_UPDATE_DATE DATE

Obsolete. Moved to _B table.
CODE VARCHAR2 (100)
Obsolete. Moved to _TL table.
REVENUE_CLASS_ID NUMBER

Obsolete.
INTEREST_TYPE_ID NUMBER

Obsolete. Moved to _B table.
ENABLED_FLAG VARCHAR2 (1) Yes Obsolete. Moved to _B table
PARENT_INTEREST_CODE_ID NUMBER

Obsolete. Moved to _B table.
DESCRIPTION VARCHAR2 (240)
Obsolete. Moved to _TL table.
CATEGORY_ID NUMBER

Obsolete. Moved to _B table.
CATEGORY_SET_ID NUMBER

Obsolete. Moved to _B table.
ORG_ID NUMBER
Yes Operating unit which performed the transaction
PF_ITEM_ID NUMBER

Obsolete. Moved to _B table.
PF_ORGANIZATION_ID NUMBER

Obsolete. Moved to _B table.
CURRENCY_CODE VARCHAR2 (15)
Obsolete. Moved to _B table.
PRICE NUMBER

Obsolete. Moved to _B table.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
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
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use
Query Text

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


SELECT INTEREST_CODE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CODE
,      REVENUE_CLASS_ID
,      INTEREST_TYPE_ID
,      ENABLED_FLAG
,      PARENT_INTEREST_CODE_ID
,      DESCRIPTION
,      CATEGORY_ID
,      CATEGORY_SET_ID
,      ORG_ID
,      PF_ITEM_ID
,      PF_ORGANIZATION_ID
,      CURRENCY_CODE
,      PRICE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
FROM OSM.AS_INTEREST_CODES_ALL;

Dependencies

[top of page]

OSM.AS_INTEREST_CODES_ALL does not reference any database object

OSM.AS_INTEREST_CODES_ALL is referenced by following:

SchemaAPPS
SynonymAS_INTEREST_CODES_ALL