[Home] [Help] [Dependency Information]
Object Name: | IGS_DA_WIFFTR_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_DA_WIFFTR_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
View to obtain the values that have been choosen for Major , Minor and track options for explore program details. --Obsolete
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | Batch ID that the request is associated to | ||
PROGRAM_CODE | VARCHAR2 | (6) | Program Code that the Major Minor and Track Unit sets are associated with | |
TRACK_SEQ_NUM | NUMBER | Track programmatic sequence number | ||
MAJOR_SEQ_NUM | NUMBER | Major programmatic sequence number | ||
TRACK_UNIT_SET | VARCHAR2 | (10) | Track option unit set code | |
TRACK_OPTION_VERSION | NUMBER | (3) | Track option unit set version | |
TRACK_OPTION_CATALOG | VARCHAR2 | (30) | Track option catalog description | |
ORG_UNIT_TRACK | VARCHAR2 | (30) | Track option organization unit program is in | |
TRACK_CAL_TYPE | VARCHAR2 | (10) | Track option calendar type | |
TRACK_CI_SEQ_NUM | NUMBER | (6) | Track option calendar sequence number | |
MINOR_UNIT_SET1 | VARCHAR2 | (10) | Minor choice 1 unit set code | |
MINOR_VERSION1 | NUMBER | (3) | Minor choice 1 unit set version | |
MINOR_CATALOG1 | VARCHAR2 | (30) | Minor choice 1 catalog description | |
ORG_UNIT_MINOR1 | VARCHAR2 | (10) | Minor choice 1 organization unit program is in | |
MINOR_CAL_TYPE1 | VARCHAR2 | (10) | Minor choice 1 calendar type | |
MINOR_CI_SEQ_NUM1 | NUMBER | (6) | Minor choice 1 calendar sequence number | |
MINOR_UNIT_SET2 | VARCHAR2 | (10) | Minor choice 2 unit set code | |
MINOR_VERSION2 | NUMBER | (3) | Minor choice 2 unit set version | |
MINOR_CATALOG2 | VARCHAR2 | (30) | Minor choice 2 catalog description | |
ORG_UNIT_MINOR2 | VARCHAR2 | (10) | Minor choice 2 organization unit program is in | |
MINOR_CAL_TYPE2 | VARCHAR2 | (10) | Minor choice 2 calendar type | |
MINOR_CI_SEQ_NUM2 | NUMBER | (6) | Minor choice 2 calendar sequence number | |
MINOR_UNIT_SET3 | VARCHAR2 | (10) | Minor choice 3 unit set code | |
MINOR_VERSION3 | NUMBER | (3) | Minor choice 3 unit set version | |
MINOR_CATALOG3 | VARCHAR2 | (30) | Minor choice 3 description | |
ORG_UNIT_MINOR3 | VARCHAR2 | (10) | Minor choice 3 organization unit program is in | |
MINOR_CAL_TYPE3 | VARCHAR2 | (10) | Minor choice 3 calendar type | |
MINOR_CI_SEQ_NUM3 | NUMBER | (6) | Minor choice 3 calendar sequence number | |
MAJOR_UNIT_SET | VARCHAR2 | (10) | Major unit set code | |
MAJOR_VERSION | NUMBER | Major unit set version | ||
MAJOR_CATALOG | VARCHAR2 | (30) | Major catalog description | |
ORG_UNIT_MAJOR | VARCHAR2 | (30) | Major organization unit program is in | |
MAJOR_CAL_TYPE | VARCHAR2 | (10) | Major calendar type | |
MAJOR_CI_SEQ_NUM | NUMBER | Major calendar sequence number | ||
PROGRAM_VERSION | NUMBER | (3) | Program Version selected for the Major Minor and Track options to select |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, PROGRAM_CODE
, TRACK_SEQ_NUM
, MAJOR_SEQ_NUM
, TRACK_UNIT_SET
, TRACK_OPTION_VERSION
, TRACK_OPTION_CATALOG
, ORG_UNIT_TRACK
, TRACK_CAL_TYPE
, TRACK_CI_SEQ_NUM
, MINOR_UNIT_SET1
, MINOR_VERSION1
, MINOR_CATALOG1
, ORG_UNIT_MINOR1
, MINOR_CAL_TYPE1
, MINOR_CI_SEQ_NUM1
, MINOR_UNIT_SET2
, MINOR_VERSION2
, MINOR_CATALOG2
, ORG_UNIT_MINOR2
, MINOR_CAL_TYPE2
, MINOR_CI_SEQ_NUM2
, MINOR_UNIT_SET3
, MINOR_VERSION3
, MINOR_CATALOG3
, ORG_UNIT_MINOR3
, MINOR_CAL_TYPE3
, MINOR_CI_SEQ_NUM3
, MAJOR_UNIT_SET
, MAJOR_VERSION
, MAJOR_CATALOG
, ORG_UNIT_MAJOR
, MAJOR_CAL_TYPE
, MAJOR_CI_SEQ_NUM
, PROGRAM_VERSION
FROM APPS.IGS_DA_WIFFTR_V;
APPS.IGS_DA_WIFFTR_V is not referenced by any database object
|
|
|