[Home] [Help]
[Dependency Information]
VIEW: APPS.IGS_AD_LOCATION
Object Details
Object Name: | IGS_AD_LOCATION |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.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:
-
APPS
-
IGS_AD_LOCATION_ALL
APPS.IGS_AD_LOCATION is referenced by following:
-
APPS
-
IGF_AP_IA_LOOKUP_V
-
IGF_AW_ANTICIPATED_DATA
- show dependent code
-
IGSBV_AS_CHNG_GRD_REQUESTS
-
IGSBV_AS_UNIT_SEC_ATTENDANCES
-
IGSFV_APPL_PANEL_DETAILS
-
IGSFV_AS_CHNG_GRD_REQUESTS
-
IGSFV_AS_UNIT_SEC_ATTENDANCES
-
IGSFV_INTERVIEW_PNL_MEMBR_DTLS
-
IGS_AD_LOCATION_V
-
IGS_AD_LOC_BLDG_V
-
IGS_AD_PANEL_DTLS_V
-
IGS_AD_PNMEMBR_DTLS_V
-
IGS_AD_SCRN_INT_PANEL_DTLS_V
-
IGS_AD_WF_P2A
- show dependent code
-
IGS_AS_ESE_EXMVNUS_UNAVLBL_V
-
IGS_AS_GEN_002
- show dependent code
-
IGS_AS_GEN_003
- show dependent code
-
IGS_AS_GEN_006
- show dependent code
-
IGS_AS_GEN_008
- show dependent code
-
IGS_AS_ITEM_ASSESSOR_V
-
IGS_AS_NOTIFY_PKG
- show dependent code
-
IGS_AS_VAL_ELS
- show dependent code
-
IGS_AS_VAL_VE
- show dependent code
-
IGS_AS_XSLISTCOM_ADI_V
-
IGS_AS_XSLISTSEP_ADI_V
-
IGS_EN_GEN_009
- show dependent code
-
IGS_EN_GEN_010
- show dependent code
-
IGS_EN_GEN_011
- show dependent code
-
IGS_EN_SPA_TERMS_API
- show dependent code
-
IGS_EN_USEC_STAT_V
-
IGS_EN_WLST_GEN_PROC
- show dependent code
-
IGS_EN_WLST_GEN_PROC
- show dependent code
-
IGS_FI_ACCT_STP_CNV
- show dependent code
-
IGS_FI_FEE_AS_RATE_V
-
IGS_FI_VAL_CFAR
- show dependent code
-
IGS_FI_VAL_FAR
- show dependent code
-
IGS_GE_GEN_001
- show dependent code
-
IGS_GE_GEN_002
- show dependent code
-
IGS_GE_VAL_PARAM
- show dependent code
-
IGS_GR_GEN_002
- show dependent code
-
IGS_GR_VAL_GC
- show dependent code
-
IGS_HE_ST_UNV_DTLS_V
-
IGS_OR_GEN_001
- show dependent code
-
IGS_OR_VAL_LOC
- show dependent code
-
IGS_OR_VAL_LOT
- show dependent code
-
IGS_OR_VAL_LR
- show dependent code
-
IGS_PRECREATE_APPL_PUB
- show dependent code
-
IGS_PS_FAC_USEC_HIST_V
-
IGS_PS_FAC_USEC_TCH_HIST_V
-
IGS_PS_GENERIC_PUB
- show dependent code
-
IGS_PS_UNIT_LOCATION_V
-
IGS_PS_UNIT_OFR_OPT_V
-
IGS_PS_USEC_AS_V
-
IGS_PS_USEC_SCHEDULE
- show dependent code
-
IGS_PS_USEC_X_USEC_V
-
IGS_PS_US_UNSCHED_CL_V
-
IGS_PS_VAL_UOO
- show dependent code
-
IGS_SS_ENR_DETAILS
- show dependent code
-
IGS_SS_EN_ENROLL_CART_RSLT_V
-
IGS_SS_USEC_OCCURENCES_V