DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IGS_DA_WIFFTR_V

Object Details
Object Name: IGS_DA_WIFFTR_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_DA_WIFFTR_V
Subobject Name:
Status: VALID

View Type

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


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.IGS_DA_WIFFTR_V references the following:

SchemaAPPS
SynonymIGS_DA_REQ_WIFMJRS
SynonymIGS_DA_REQ_WIFMNRS
SynonymIGS_DA_REQ_WIFPRGS
SynonymIGS_DA_REQ_WIFTRCKS

APPS.IGS_DA_WIFFTR_V is not referenced by any database object