[Home] [Help] [Dependency Information]
Object Name: | IGS_GE_REF_CD_TYPE |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_GE_REF_CD_TYPE |
Subobject Name: | |
Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
ORG_ID | NUMBER | (15) | ||
REFERENCE_CD_TYPE | VARCHAR2 | (10) | Yes | |
DESCRIPTION | VARCHAR2 | (60) | Yes | |
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) | ||
SELF_SERVICE_FLAG | VARCHAR2 | (1) | ||
PROGRAM_OFFERING_OPTION_FLAG | VARCHAR2 | (1) | ||
UNIT_FLAG | VARCHAR2 | (1) | ||
UNIT_SECTION_FLAG | VARCHAR2 | (1) | ||
UNIT_SECTION_OCCURRENCE_FLAG | VARCHAR2 | (1) | ||
PROGRAM_FLAG | 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
, ORG_ID
, REFERENCE_CD_TYPE
, DESCRIPTION
, S_REFERENCE_CD_TYPE
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SELF_SERVICE_FLAG
, PROGRAM_OFFERING_OPTION_FLAG
, UNIT_FLAG
, UNIT_SECTION_FLAG
, UNIT_SECTION_OCCURRENCE_FLAG
, PROGRAM_FLAG
, MANDATORY_FLAG
, RESTRICTED_FLAG
FROM APPS.IGS_GE_REF_CD_TYPE;
|
|
|