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

VIEW: APPS.IGS_AD_LOCATION

Object Details
Object Name: IGS_AD_LOCATION
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_AD_LOCATION
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)
LOCATION_CD VARCHAR2 (10) Yes
DESCRIPTION VARCHAR2 (60) Yes
LOCATION_TYPE VARCHAR2 (10) Yes
MAIL_DLVRY_WRK_DAYS NUMBER (2)
COORD_PERSON_ID NUMBER (15)
CLOSED_IND VARCHAR2 (1) Yes
REV_ACCOUNT_CD VARCHAR2 (40)
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 (30)
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
,      ORG_ID
,      LOCATION_CD
,      DESCRIPTION
,      LOCATION_TYPE
,      MAIL_DLVRY_WRK_DAYS
,      COORD_PERSON_ID
,      CLOSED_IND
,      REV_ACCOUNT_CD
,      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_AD_LOCATION;

Dependencies

[top of page]

APPS.IGS_AD_LOCATION references the following:

SchemaAPPS
SynonymIGS_AD_LOCATION_ALL
APPS.IGS_AD_LOCATION is referenced by following:

SchemaAPPS
ViewIGF_AP_IA_LOOKUP_V
Package BodyIGF_AW_ANTICIPATED_DATA - show dependent code
ViewIGSBV_AS_CHNG_GRD_REQUESTS
ViewIGSBV_AS_UNIT_SEC_ATTENDANCES
ViewIGSFV_APPL_PANEL_DETAILS
ViewIGSFV_AS_CHNG_GRD_REQUESTS
ViewIGSFV_AS_UNIT_SEC_ATTENDANCES
ViewIGSFV_INTERVIEW_PNL_MEMBR_DTLS
ViewIGS_AD_LOCATION_V
ViewIGS_AD_LOC_BLDG_V
ViewIGS_AD_PANEL_DTLS_V
ViewIGS_AD_PNMEMBR_DTLS_V
ViewIGS_AD_SCRN_INT_PANEL_DTLS_V
Package BodyIGS_AD_WF_P2A - show dependent code
ViewIGS_AS_ESE_EXMVNUS_UNAVLBL_V
Package BodyIGS_AS_GEN_002 - show dependent code
Package BodyIGS_AS_GEN_003 - show dependent code
Package BodyIGS_AS_GEN_006 - show dependent code
Package BodyIGS_AS_GEN_008 - show dependent code
ViewIGS_AS_ITEM_ASSESSOR_V
Package BodyIGS_AS_NOTIFY_PKG - show dependent code
Package BodyIGS_AS_VAL_ELS - show dependent code
Package BodyIGS_AS_VAL_VE - show dependent code
ViewIGS_AS_XSLISTCOM_ADI_V
ViewIGS_AS_XSLISTSEP_ADI_V
Package BodyIGS_EN_GEN_009 - show dependent code
Package BodyIGS_EN_GEN_010 - show dependent code
Package BodyIGS_EN_GEN_011 - show dependent code
Package BodyIGS_EN_SPA_TERMS_API - show dependent code
ViewIGS_EN_USEC_STAT_V
Package BodyIGS_EN_WLST_GEN_PROC - show dependent code
PL/SQL PackageIGS_EN_WLST_GEN_PROC - show dependent code
Package BodyIGS_FI_ACCT_STP_CNV - show dependent code
ViewIGS_FI_FEE_AS_RATE_V
Package BodyIGS_FI_VAL_CFAR - show dependent code
Package BodyIGS_FI_VAL_FAR - show dependent code
Package BodyIGS_GE_GEN_001 - show dependent code
Package BodyIGS_GE_GEN_002 - show dependent code
Package BodyIGS_GE_VAL_PARAM - show dependent code
Package BodyIGS_GR_GEN_002 - show dependent code
Package BodyIGS_GR_VAL_GC - show dependent code
ViewIGS_HE_ST_UNV_DTLS_V
Package BodyIGS_OR_GEN_001 - show dependent code
Package BodyIGS_OR_VAL_LOC - show dependent code
Package BodyIGS_OR_VAL_LOT - show dependent code
Package BodyIGS_OR_VAL_LR - show dependent code
Package BodyIGS_PRECREATE_APPL_PUB - show dependent code
ViewIGS_PS_FAC_USEC_HIST_V
ViewIGS_PS_FAC_USEC_TCH_HIST_V
PL/SQL PackageIGS_PS_GENERIC_PUB - show dependent code
ViewIGS_PS_UNIT_LOCATION_V
ViewIGS_PS_UNIT_OFR_OPT_V
ViewIGS_PS_USEC_AS_V
Package BodyIGS_PS_USEC_SCHEDULE - show dependent code
ViewIGS_PS_USEC_X_USEC_V
ViewIGS_PS_US_UNSCHED_CL_V
Package BodyIGS_PS_VAL_UOO - show dependent code
Package BodyIGS_SS_ENR_DETAILS - show dependent code
ViewIGS_SS_EN_ENROLL_CART_RSLT_V
ViewIGS_SS_USEC_OCCURENCES_V