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

Object Details

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

View Type

A Business Intelligence System view

IGS_PE_HZ_PARTIES describes the attribites of a person

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ORG_UNIT_IDENTIFIER	NUMBER	(15)	Yes	Organization unit identifier
ORG_UNIT_CODE	VARCHAR2	(30)		Product Recognized Organization Code
TCA_PARTY_NUMBER	VARCHAR2	(30)	Yes	Party Number of the Organization in HZ_PARTIES
ORG_UNIT_NAME	VARCHAR2	(360)	Yes	Name of this Organization unit
INSTITUTION_CODE	VARCHAR2	(30)		Identifier code of the parent institution for this organizational unit
START_DATE	DATE			Start date of the organizational unit
END_DATE	DATE			End date of the organizational unit
_LA:MEMBER_TYPE	CHAR	(63)		Organization Unit member type
ORG_STATUS	VARCHAR2	(10)		Organization status
_LA:ORG_TYPE	CHAR	(57)		Organization type
PREF_UNIT_IDENTIFIER_TYPE	VARCHAR2	(10)		Prefered organizational unit alternate identifier type
PREF_UNIT_ALT_IDENTIFIER	VARCHAR2	(20)		Prefered organizational unit alternate identifier
ORG_STATUS_DESC	VARCHAR2	(60)		Organization status description
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 ORG_UNIT_IDENTIFIER
,      ORG_UNIT_CODE
,      TCA_PARTY_NUMBER
,      ORG_UNIT_NAME
,      INSTITUTION_CODE
,      START_DATE
,      END_DATE
,      _LA:MEMBER_TYPE
,      ORG_STATUS
,      _LA:ORG_TYPE
,      PREF_UNIT_IDENTIFIER_TYPE
,      PREF_UNIT_ALT_IDENTIFIER
,      ORG_STATUS_DESC
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGSFV_ORGANIZATION_UNIT_PARTY;

Dependencies

[top of page]

APPS.IGSFV_ORGANIZATION_UNIT_PARTY references the following:

APPS: HZ_PARTIES; IGS_OR_ORG_ALT_IDS; IGS_OR_ORG_ALT_IDTYP; IGS_OR_STATUS; IGS_PE_HZ_PARTIES

APPS.IGSFV_ORGANIZATION_UNIT_PARTY is not referenced by any database object