[Home] [Help]
[Dependency Information]
| Object Name: | IGS_CA_DA_CONFIGS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | IGS.IGS_CA_DA_CONFIGS_V
|
| Subobject Name: | |
| Status: | VALID |
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.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Rowid | |
| SYS_DATE_TYPE | VARCHAR2 | (30) | Yes | Sys date type |
| DESCRIPTION | VARCHAR2 | (80) | Yes | Description |
| OWNER_MODULE_CODE | VARCHAR2 | (30) | Yes | Owner module |
| OWNER_MODULE_DESC | VARCHAR2 | (80) | Yes | Owner module description |
| VALIDATION_PROC | VARCHAR2 | (100) | Validation procedure | |
| ONE_PER_CAL_FLAG | VARCHAR2 | (1) | Yes | One per cal flag |
| RES_CAL_CAT1 | VARCHAR2 | (30) | Yes | Restricted Calendar category |
| CAL_CAT1_DESC | VARCHAR2 | (80) | Yes | Restricted Calendar category description |
| RES_CAL_CAT2 | VARCHAR2 | (30) | Alternate Calendar category | |
| CAL_CAT2_DESC | VARCHAR2 | (80) | Alternate Calendar category description | |
| DATE_ALIAS | VARCHAR2 | (10) | Date Alias | |
| 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 |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, SYS_DATE_TYPE
, DESCRIPTION
, OWNER_MODULE_CODE
, OWNER_MODULE_DESC
, VALIDATION_PROC
, ONE_PER_CAL_FLAG
, RES_CAL_CAT1
, CAL_CAT1_DESC
, RES_CAL_CAT2
, CAL_CAT2_DESC
, DATE_ALIAS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGS_CA_DA_CONFIGS_V;
APPS
FND_LOOKUP_VALUES
IGS_CA_DA_CONFIGS
IGS_LOOKUP_VALUES
APPS.IGS_CA_DA_CONFIGS_V is not referenced by any database object
|
|
|
|