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]

VIEW: APPS.IGFBV_DL_PNOTE_STATUS_HISTORY

Object Details

Object Name:	IGFBV_DL_PNOTE_STATUS_HISTORY
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGF.IGFBV_DL_PNOTE_STATUS_HISTORY
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Base view for the entity that holds Direct Loan Promissory Note Activities

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
_LA:PROM_NOTE_STATUS	CHAR	(66)		Promissory Note Status
PROM_NOTE_STATUS_DATE	DATE			Promissory Note Status Date
LOAN_ID	NUMBER	(15)	Yes	Identifier for loans
STATUS_CHANGE_HISTORY_ID	NUMBER	(15)	Yes	Identifier for Promissory Note status change history
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
PERSON_ID	NUMBER	(15)		Person identifier

Query Text

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


SELECT _LA:PROM_NOTE_STATUS
,      PROM_NOTE_STATUS_DATE
,      LOAN_ID
,      STATUS_CHANGE_HISTORY_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      PERSON_ID
FROM APPS.IGFBV_DL_PNOTE_STATUS_HISTORY;

Dependencies

[top of page]

APPS.IGFBV_DL_PNOTE_STATUS_HISTORY references the following:

APPS: IGF_SL_LOR_ALL; IGF_SL_PNOTE_STAT_H

APPS.IGFBV_DL_PNOTE_STATUS_HISTORY is not referenced by any database object