eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IGS.IGS_PS_NSUS_RTN_DTL

Object Details

Object Name:	IGS_PS_NSUS_RTN_DTL
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_PS_NSUS_RTN_DTL
Subobject Name:
Status:	VALID

This table stores the info about Retention master setup

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_PS_NSUS_RTN_DTL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	NON_STD_USEC_RTN_DTL_ID
IGS_PS_NSUS_RTN_DTL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	NON_STD_USEC_RTN_ID OFFSET_VALUE

Columns

Name	Datatype	Length	Mandatory	Comments
NON_STD_USEC_RTN_DTL_ID	NUMBER		Yes	System generated number to uniquely identify the non-standard unit section detail setup
NON_STD_USEC_RTN_ID	NUMBER		Yes	System generated number to uniquely identify the non-standard unit section master setup. This column is used here to get the corresponding childs
OFFSET_VALUE	NUMBER		Yes	Offset Value set up for corresponding formula method.
RETENTION_PERCENT	NUMBER			Retention Percentage
RETENTION_AMOUNT	NUMBER			Retention Amount
OFFSET_DATE	DATE			Offset Date for retention
OVERRIDE_DATE_FLAG	VARCHAR2	(1)	Yes	This will indicate whether the offset date is system calculated or user entered.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column

Query Text

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


SELECT NON_STD_USEC_RTN_DTL_ID
,      NON_STD_USEC_RTN_ID
,      OFFSET_VALUE
,      RETENTION_PERCENT
,      RETENTION_AMOUNT
,      OFFSET_DATE
,      OVERRIDE_DATE_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_PS_NSUS_RTN_DTL;

Dependencies

[top of page]

IGS.IGS_PS_NSUS_RTN_DTL does not reference any database object

IGS.IGS_PS_NSUS_RTN_DTL is referenced by following:

APPS: IGS_PS_NSUS_RTN_DTL