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

TABLE: IEX.IEX_DUNNING_PLANS_TL

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


Collections dunning plan translated table


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
DUNNING_PLAN_ID NUMBER (10) Yes Primary Key
NAME VARCHAR2 (240)
Name assigned to the dunning plan
DESCRIPTION VARCHAR2 (240)
Description assigned to the dunning plan
LANGUAGE VARCHAR2 (240)
Language code
SOURCE_LANG VARCHAR2 (240)
The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE

Standard who column - date when this row was updated.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
Query Text

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


SELECT DUNNING_PLAN_ID
,      NAME
,      DESCRIPTION
,      LANGUAGE
,      SOURCE_LANG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM IEX.IEX_DUNNING_PLANS_TL;

Dependencies

[top of page]

IEX.IEX_DUNNING_PLANS_TL does not reference any database object

IEX.IEX_DUNNING_PLANS_TL is referenced by following:

SchemaAPPS
SynonymIEX_DUNNING_PLANS_TL