[Home] [Help] [Dependency Information]
Object Name: | IGS_GE_REF_CD_TYPE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_GE_REF_CD_TYPE_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) | ||
REFERENCE_CD_TYPE | VARCHAR2 | (10) | Yes | |
DESCRIPTION | VARCHAR2 | (60) | Yes | |
SELF_SERVICE_FLAG | VARCHAR2 | (1) | ||
PROGRAM_FLAG | VARCHAR2 | (1) | ||
PROGRAM_OFFERING_OPTION_FLAG | VARCHAR2 | (1) | ||
UNIT_FLAG | VARCHAR2 | (1) | ||
UNIT_SECTION_FLAG | VARCHAR2 | (1) | ||
UNIT_SECTION_OCCURRENCE_FLAG | VARCHAR2 | (1) | ||
S_REFERENCE_CD_TYPE | VARCHAR2 | (30) | Yes | |
CLOSED_IND | VARCHAR2 | (1) | 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) | ||
DSP_MEANING | VARCHAR2 | (80) | Yes | |
DSP_CLOSED_IND | VARCHAR2 | (1) | ||
MANDATORY_FLAG | VARCHAR2 | (1) | ||
RESTRICTED_FLAG | VARCHAR2 | (1) | This flag indicates whether reference codes need to be set up for the reference code type or whether the user can add in the reference code directly in the reference code form within PSP. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, REFERENCE_CD_TYPE
, DESCRIPTION
, SELF_SERVICE_FLAG
, PROGRAM_FLAG
, PROGRAM_OFFERING_OPTION_FLAG
, UNIT_FLAG
, UNIT_SECTION_FLAG
, UNIT_SECTION_OCCURRENCE_FLAG
, S_REFERENCE_CD_TYPE
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, DSP_MEANING
, DSP_CLOSED_IND
, MANDATORY_FLAG
, RESTRICTED_FLAG
FROM APPS.IGS_GE_REF_CD_TYPE_V;
APPS.IGS_GE_REF_CD_TYPE_V is not referenced by any database object
|
|
|