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: IGW.IGW_P_PROGRAM_DUE_DATES

Object Details

Object Name:	IGW_P_PROGRAM_DUE_DATES
Object Type:	TABLE
Owner:	IGW
Subobject Name:
Status:	VALID

This table stores the Program due dates

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
PROGRAM_DUE_DATE_ID	NUMBER	(15)	Yes	Unique Identifier
DUE_DATE_TYPE_CODE	VARCHAR2	(30)		Due Date Type Identifier
DEADLINE_TYPE_CODE	VARCHAR2	(30)		Deadline Type Identifier
DUE_DATE	DATE			Due Date
PROP_PROGRAM_ID	NUMBER	(15)	Yes	Unique Program Identifier
LAST_UPDATE_DATE	DATE		Yes	Standard who column
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
RECORD_VERSION_NUMBER	NUMBER		Yes	Field for storing locking sequence number

Query Text

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


SELECT PROGRAM_DUE_DATE_ID
,      DUE_DATE_TYPE_CODE
,      DEADLINE_TYPE_CODE
,      DUE_DATE
,      PROP_PROGRAM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      RECORD_VERSION_NUMBER
FROM IGW.IGW_P_PROGRAM_DUE_DATES;

Dependencies

[top of page]

IGW.IGW_P_PROGRAM_DUE_DATES does not reference any database object

IGW.IGW_P_PROGRAM_DUE_DATES is referenced by following:

APPS: IGW_P_PROGRAM_DUE_DATES