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.IGS_AD_PS_APINTUNTHS

Object Details

Object Name:	IGS_AD_PS_APINTUNTHS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_AD_PS_APINTUNTHS
Subobject Name:
Status:	VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
ORG_ID	NUMBER	(15)
PERSON_ID	NUMBER	(15)	Yes
ADMISSION_APPL_NUMBER	NUMBER	(2)	Yes
NOMINATED_COURSE_CD	VARCHAR2	(6)	Yes
ACAI_SEQUENCE_NUMBER	NUMBER	(6)	Yes
UNIT_CD	VARCHAR2	(10)	Yes
HIST_START_DT	DATE		Yes
HIST_END_DT	DATE		Yes
HIST_WHO	NUMBER	(15)	Yes
UV_VERSION_NUMBER	NUMBER	(3)
CAL_TYPE	VARCHAR2	(10)
CI_SEQUENCE_NUMBER	NUMBER	(6)
LOCATION_CD	VARCHAR2	(10)
UNIT_CLASS	VARCHAR2	(10)
UNIT_MODE	VARCHAR2	(10)
ADM_UNIT_OUTCOME_STATUS	VARCHAR2	(10)
ASS_TRACKING_ID	NUMBER	(9)
RULE_WAIVED_DT	DATE
RULE_WAIVED_PERSON_ID	NUMBER	(15)
SUP_UNIT_CD	VARCHAR2	(10)
SUP_UV_VERSION_NUMBER	NUMBER	(3)
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
ADM_PS_APPL_INST_UNIT_HIST_ID	NUMBER		Yes	The value of this column will uniquely identify the record
ADM_PS_APPL_INST_UNIT_ID	NUMBER			The value of this column will uniquely identify the transaction record

Query Text

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


SELECT ROW_ID
,      ORG_ID
,      PERSON_ID
,      ADMISSION_APPL_NUMBER
,      NOMINATED_COURSE_CD
,      ACAI_SEQUENCE_NUMBER
,      UNIT_CD
,      HIST_START_DT
,      HIST_END_DT
,      HIST_WHO
,      UV_VERSION_NUMBER
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      LOCATION_CD
,      UNIT_CLASS
,      UNIT_MODE
,      ADM_UNIT_OUTCOME_STATUS
,      ASS_TRACKING_ID
,      RULE_WAIVED_DT
,      RULE_WAIVED_PERSON_ID
,      SUP_UNIT_CD
,      SUP_UV_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ADM_PS_APPL_INST_UNIT_HIST_ID
,      ADM_PS_APPL_INST_UNIT_ID
FROM APPS.IGS_AD_PS_APINTUNTHS;

Dependencies

[top of page]

APPS.IGS_AD_PS_APINTUNTHS references the following:

APPS: IGS_AD_PS_APINTUNTHS_ALL

APPS.IGS_AD_PS_APINTUNTHS is referenced by following:

APPS: IGS_AD_GEN_001 - show dependent code; IGS_AD_GEN_010 - show dependent code; IGS_AD_PS_APLINSTUNT_PKG - show dependent code; IGS_AD_PS_APLINSTUNT_UNITHST_V; IGS_AU_GEN_001 - show dependent code