[Home] [Help] [Dependency Information]
Object Name: | IGS_UC_IVSTARW_2004_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_UC_IVSTARW_2004_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
From 2004, wrong application information will be held in different Hercules views for different systems. This View selects the wrong application information belonging to all the systems.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPNO | NUMBER | (22) | Application Number | |
TIMESTAMP | DATE | Time stamp - date and time of last change | ||
MISCODED | VARCHAR2 | (1) | Y - Miscoded | |
CANCELLED | VARCHAR2 | (1) | Y - Cancelled | |
JOINTADMISSION | VARCHAR2 | (1) | Joint admission indicator | |
CHOICE1LOST | VARCHAR2 | (1) | Choice 1 Lost | |
CHOICE2LOST | VARCHAR2 | (1) | Choice 2 Lost | |
CHOICE3LOST | VARCHAR2 | (1) | Choice 3 Lost | |
CHOICE4LOST | VARCHAR2 | (1) | Choice 4 Lost | |
CHOICE5LOST | VARCHAR2 | (1) | Choice 5 Lost | |
CHOICE6LOST | VARCHAR2 | (1) | Choice 6 Lost | |
CHOICE7LOST | VARCHAR2 | (1) | Choice 7 Lost | |
CANCELDATE | DATE | Date cancelled | ||
REMARK | VARCHAR2 | (40) | Why they were cancelled |
Cut, paste (and edit) the following text to query this object:
SELECT APPNO
, TIMESTAMP
, MISCODED
, CANCELLED
, JOINTADMISSION
, CHOICE1LOST
, CHOICE2LOST
, CHOICE3LOST
, CHOICE4LOST
, CHOICE5LOST
, CHOICE6LOST
, CHOICE7LOST
, CANCELDATE
, REMARK
FROM APPS.IGS_UC_IVSTARW_2004_V;
|
|
|