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

VIEW: APPS.IGS_DA_OUT_RQST_FTR_V

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

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view is to be created so that all information about all the feature values that have been defined for the features defined --Obsolete


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Rowid
BATCH_ID NUMBER
Yes batch id
REQUEST_MODE VARCHAR2 (30) Yes Request Mode
REQUEST_TYPE VARCHAR2 (30)
Request type
REQUEST_TYPE_COM1 VARCHAR2 (255)
Request Type com1
REQUEST_TYPE_COM2 VARCHAR2 (255)
Request Type com2
REQUEST_TYPE_COM3 VARCHAR2 (255)
Request Type com3
REQUEST_TYPE_COM4 VARCHAR2 (255)
Request Type com4
FEATURE_NAME VARCHAR2 (30)
Feature name
FEATURE_VALUE VARCHAR2 (30)
feature value
DISPLAY_FLAG VARCHAR2 (1)
Display flag
FEATURE_UPDATE_FLAG VARCHAR2 (1)
Feature update flag
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      BATCH_ID
,      REQUEST_MODE
,      REQUEST_TYPE
,      REQUEST_TYPE_COM1
,      REQUEST_TYPE_COM2
,      REQUEST_TYPE_COM3
,      REQUEST_TYPE_COM4
,      FEATURE_NAME
,      FEATURE_VALUE
,      DISPLAY_FLAG
,      FEATURE_UPDATE_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGS_DA_OUT_RQST_FTR_V;

Dependencies

[top of page]

APPS.IGS_DA_OUT_RQST_FTR_V references the following:

SchemaAPPS
SynonymIGS_DA_FTR_VAL_MAP
SynonymIGS_DA_REQ_FTRS
SynonymIGS_DA_RQST

APPS.IGS_DA_OUT_RQST_FTR_V is not referenced by any database object