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

VIEW: APPS.IGS_PE_PERSID_GROUP_V

Object Details
Object Name: IGS_PE_PERSID_GROUP_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_PE_PERSID_GROUP_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
GROUP_ID NUMBER (6) Yes
GROUP_CD VARCHAR2 (10) Yes
GROUP_TYPE VARCHAR2 (7)
Group type
CREATOR_PERSON_ID NUMBER (15)
DESCRIPTION VARCHAR2 (60) Yes
CLOSED_IND VARCHAR2 (1) Yes
COMMENTS VARCHAR2 (2000)
FULL_NAME VARCHAR2 (450)
CREATOR_PERSON_NUMBER VARCHAR2 (30) Yes
FILE_NAME VARCHAR2 (200)
File Name
CREATE_DT DATE
Yes
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)
ATTRIBUTE_CATEGORY VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE16 VARCHAR2 (150)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
Query Text

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


SELECT ROW_ID
,      GROUP_ID
,      GROUP_CD
,      GROUP_TYPE
,      CREATOR_PERSON_ID
,      DESCRIPTION
,      CLOSED_IND
,      COMMENTS
,      FULL_NAME
,      CREATOR_PERSON_NUMBER
,      FILE_NAME
,      CREATE_DT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
FROM APPS.IGS_PE_PERSID_GROUP_V;

Dependencies

[top of page]

APPS.IGS_PE_PERSID_GROUP_V references the following:

SchemaAPPS
SynonymIGS_PE_PERSID_GROUP_ALL
ViewIGS_PE_PERSON_BASE_V
APPS.IGS_PE_PERSID_GROUP_V is referenced by following:

SchemaAPPS
Package BodyIGF_AP_CALC_IM_EFC - show dependent code
Package BodyIGF_AP_SS_PKG - show dependent code
PL/SQL PackageIGF_AP_SS_PKG - show dependent code
Package BodyIGF_AP_TODO_GRPS_PRC_PKG - show dependent code
Package BodyIGF_AP_VER_GRPS_PRC_PKG - show dependent code
Package BodyIGF_AW_CANCEL_AWD - show dependent code
Package BodyIGF_AW_COA_CALC - show dependent code
Package BodyIGF_AW_COA_UPDATE - show dependent code
Package BodyIGF_AW_GEN_004 - show dependent code
Package BodyIGF_AW_LOCK_ASSGN_PKG - show dependent code
Package BodyIGF_AW_MANAGE_AWD - show dependent code
Package BodyIGF_AW_PACKAGING - show dependent code
Package BodyIGF_AW_RULE - show dependent code
Package BodyIGF_DB_DISB - show dependent code
PL/SQL PackageIGF_DB_SF_INTEGRATION - show dependent code
Package BodyIGF_DB_SF_INTEGRATION - show dependent code
Package BodyIGF_GR_GEN_XML - show dependent code
Package BodyIGF_GR_REPACKAGE - show dependent code
Package BodyIGF_GR_RFMS_DISB_ORIG - show dependent code
Package BodyIGF_GR_RFMS_ORIG - show dependent code
Package BodyIGF_GR_VERIFY_PROCESS - show dependent code
Package BodyIGF_SL_CL_CHG_FILE - show dependent code
Package BodyIGF_SL_DL_GEN_XML - show dependent code
Package BodyIGF_SL_LAR_CREATION - show dependent code
Package BodyIGF_SL_PREF_LENDER - show dependent code
Package BodyIGF_SL_REL_DISB - show dependent code
Package BodyIGF_SP_AWARD - show dependent code
Package BodyIGF_SP_CREATE_BASE_REC - show dependent code
Package BodyIGS_AD_AC_COMP - show dependent code
Package BodyIGS_AD_CANCEL_RECONSIDER - show dependent code
Package BodyIGS_AD_DEF_APPL_PKG - show dependent code
Package BodyIGS_AD_INT_RECONSIDER - show dependent code
Package BodyIGS_AD_TI_COMP - show dependent code
Package BodyIGS_AD_VAL_ACAI_FTR_OFFER - show dependent code
ViewIGS_AS_GPC_PE_ID_GRP_V
Package BodyIGS_FI_1098T_EXTRACT_DATA - show dependent code
Package BodyIGS_FI_AD_HOC_WAV - show dependent code
PL/SQL PackageIGS_FI_AD_HOC_WAV - show dependent code
Package BodyIGS_FI_PRC_APINT - show dependent code
PL/SQL PackageIGS_FI_PRC_BALANCES - show dependent code
Package BodyIGS_FI_PRC_BALANCES - show dependent code
Package BodyIGS_FI_PRC_HOLDS - show dependent code
PL/SQL PackageIGS_FI_PRC_HOLDS - show dependent code
Package BodyIGS_FI_PRC_REFUNDS - show dependent code
Package BodyIGS_FI_PRC_SP_FEES - show dependent code
Package BodyIGS_FI_PRC_WAIVERS - show dependent code
Package BodyIGS_FI_REFUNDS_PROCESS - show dependent code
PL/SQL PackageIGS_FI_TRAN_LOCKBOX_TXNS - show dependent code
Package BodyIGS_FI_TRAN_LOCKBOX_TXNS - show dependent code
Package BodyIGS_HE_CREATE_EXTRACT_PKG - show dependent code
Package BodyIGS_HE_EXTRACT_PKG - show dependent code
Package BodyIGS_HE_FTE_CALC_PKG - show dependent code
ViewIGS_PE_ALL_PERSID_GROUP_V
PL/SQL PackageIGS_PE_DYNAMIC_PERSID_GROUP - show dependent code
Package BodyIGS_PE_DYNAMIC_PERSID_GROUP - show dependent code
ViewIGS_PE_ID_GROUP_V
Package BodyIGS_PE_SET_REM_HOLDS - show dependent code
PL/SQL PackageIGS_PE_SET_REM_HOLDS - show dependent code
Package BodyIGS_PE_USERID_PKG - show dependent code
Package BodyIGS_SC_BULK_ASSIGN - show dependent code