[Home] [Help]
[Dependency Information]
Object Name: | IGS_PS_UNT_CRCLM |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
The units are to be grouped under common code to indicate they belong to same curriculum id. This view displays the curriculum id under which units can be grouped together.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CURRICULUM_ID | VARCHAR2 | (10) | Yes | |
DESCRIPTION | VARCHAR2 | (80) | Yes | |
CLOSED_IND | VARCHAR2 | (1) | Yes | |
ORG_ID | NUMBER | (15) | ||
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) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CURRICULUM_ID
, DESCRIPTION
, CLOSED_IND
, ORG_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGS_PS_UNT_CRCLM;
|
|
|