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

TABLE: IEX.IEX_CHANGED_ACCOUNTS_ALL

Object Details
Object Name: IEX_CHANGED_ACCOUNTS_ALL
Object Type: TABLE
Owner: IEX
Subobject Name:
Status: VALID


This table stores accounts that have new collectors assigned.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
PARTY_ID NUMBER (15) Yes Foreign key into HZ_PARTIES
ACCOUNT_ID NUMBER (15)
Foreign key into HZ_CUST_ACCOUNTS
SITE_USE_ID NUMBER (15)
Foreign key into HZ_CUST_SITE_USES_ALL
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - who updated this row.
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER
Yes Standard who column - who created this row.
LAST_UPDATE_LOGIN NUMBER
Yes Standard who column - who updated this row.
REQUEST_ID NUMBER

Concurrent request id.
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

PROGRAM_UPDATE_DATE
CHANGE_TYPE VARCHAR2 (30)
CHANGE_TYPE
PROCESSED_FLAG VARCHAR2 (1)
PROCESSED_FLAG
ORG_ID NUMBER

Organization identifier
OBJECT_VERSION_NUMBER NUMBER

Standard HTML front end column
Query Text

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


SELECT PARTY_ID
,      ACCOUNT_ID
,      SITE_USE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CHANGE_TYPE
,      PROCESSED_FLAG
,      ORG_ID
,      OBJECT_VERSION_NUMBER
FROM IEX.IEX_CHANGED_ACCOUNTS_ALL;

Dependencies

[top of page]

IEX.IEX_CHANGED_ACCOUNTS_ALL does not reference any database object

IEX.IEX_CHANGED_ACCOUNTS_ALL is referenced by following:

SchemaAPPS
SynonymIEX_CHANGED_ACCOUNTS_ALL