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


VIEW: APPLSYS.FND_FLEX_TEST#

Object Details
Object Name: FND_FLEX_TEST#
Object Type: VIEW
Owner: APPLSYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER

ID_FLEX_CODE VARCHAR2 (30)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

UNIQUE_ID_COLUMN NUMBER

UNIQUE_ID_COLUMN2 NUMBER

SET_DEFINING_COLUMN NUMBER

SUMMARY_FLAG VARCHAR2 (1)
ENABLED_FLAG VARCHAR2 (1)
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

SEGMENT1 VARCHAR2 (60)
SEGMENT2 VARCHAR2 (60)
SEGMENT3 VARCHAR2 (60)
SEGMENT4 VARCHAR2 (60)
SEGMENT5 VARCHAR2 (60)
SEGMENT6 VARCHAR2 (60)
SEGMENT7 VARCHAR2 (60)
SEGMENT8 VARCHAR2 (60)
SEGMENT9 VARCHAR2 (60)
SEGMENT10 VARCHAR2 (60)
SEGMENT11 VARCHAR2 (60)
SEGMENT12 VARCHAR2 (60)
SEGMENT13 VARCHAR2 (60)
SEGMENT14 VARCHAR2 (60)
SEGMENT15 VARCHAR2 (60)
SEGMENT16 VARCHAR2 (60)
SEGMENT17 VARCHAR2 (60)
SEGMENT18 VARCHAR2 (60)
SEGMENT19 VARCHAR2 (60)
SEGMENT20 VARCHAR2 (60)
SEGMENT21 VARCHAR2 (60)
SEGMENT22 VARCHAR2 (60)
SEGMENT23 VARCHAR2 (60)
SEGMENT24 VARCHAR2 (60)
SEGMENT25 VARCHAR2 (60)
SEGMENT26 VARCHAR2 (60)
SEGMENT27 VARCHAR2 (60)
SEGMENT28 VARCHAR2 (60)
SEGMENT29 VARCHAR2 (60)
SEGMENT30 VARCHAR2 (60)
SEGMENT31_NUMBER NUMBER

SEGMENT32_NUMBER NUMBER

SEGMENT33_NUMBER NUMBER

SEGMENT34_NUMBER NUMBER

SEGMENT35_DATE DATE

SEGMENT36_DATE DATE

SEGMENT1_LOW VARCHAR2 (60)
SEGMENT2_LOW VARCHAR2 (60)
SEGMENT3_LOW VARCHAR2 (60)
SEGMENT4_LOW VARCHAR2 (60)
SEGMENT5_LOW VARCHAR2 (60)
SEGMENT6_LOW VARCHAR2 (60)
SEGMENT7_LOW VARCHAR2 (60)
SEGMENT8_LOW VARCHAR2 (60)
SEGMENT9_LOW VARCHAR2 (60)
SEGMENT10_LOW VARCHAR2 (60)
SEGMENT11_LOW VARCHAR2 (60)
SEGMENT12_LOW VARCHAR2 (60)
SEGMENT13_LOW VARCHAR2 (60)
SEGMENT14_LOW VARCHAR2 (60)
SEGMENT15_LOW VARCHAR2 (60)
SEGMENT16_LOW VARCHAR2 (60)
SEGMENT17_LOW VARCHAR2 (60)
SEGMENT18_LOW VARCHAR2 (60)
SEGMENT19_LOW VARCHAR2 (60)
SEGMENT20_LOW VARCHAR2 (60)
SEGMENT21_LOW VARCHAR2 (60)
SEGMENT22_LOW VARCHAR2 (60)
SEGMENT23_LOW VARCHAR2 (60)
SEGMENT24_LOW VARCHAR2 (60)
SEGMENT25_LOW VARCHAR2 (60)
SEGMENT26_LOW VARCHAR2 (60)
SEGMENT27_LOW VARCHAR2 (60)
SEGMENT28_LOW VARCHAR2 (60)
SEGMENT29_LOW VARCHAR2 (60)
SEGMENT30_LOW VARCHAR2 (60)
SEGMENT31_LOW_NUMBER NUMBER

SEGMENT32_LOW_NUMBER NUMBER

SEGMENT33_LOW_NUMBER NUMBER

SEGMENT34_LOW_NUMBER NUMBER

SEGMENT35_LOW_DATE DATE

SEGMENT36_LOW_DATE DATE

SEGMENT1_HIGH VARCHAR2 (60)
SEGMENT2_HIGH VARCHAR2 (60)
SEGMENT3_HIGH VARCHAR2 (60)
SEGMENT4_HIGH VARCHAR2 (60)
SEGMENT5_HIGH VARCHAR2 (60)
SEGMENT6_HIGH VARCHAR2 (60)
SEGMENT7_HIGH VARCHAR2 (60)
SEGMENT8_HIGH VARCHAR2 (60)
SEGMENT9_HIGH VARCHAR2 (60)
SEGMENT10_HIGH VARCHAR2 (60)
SEGMENT11_HIGH VARCHAR2 (60)
SEGMENT12_HIGH VARCHAR2 (60)
SEGMENT13_HIGH VARCHAR2 (60)
SEGMENT14_HIGH VARCHAR2 (60)
SEGMENT15_HIGH VARCHAR2 (60)
SEGMENT16_HIGH VARCHAR2 (60)
SEGMENT17_HIGH VARCHAR2 (60)
SEGMENT18_HIGH VARCHAR2 (60)
SEGMENT19_HIGH VARCHAR2 (60)
SEGMENT20_HIGH VARCHAR2 (60)
SEGMENT21_HIGH VARCHAR2 (60)
SEGMENT22_HIGH VARCHAR2 (60)
SEGMENT23_HIGH VARCHAR2 (60)
SEGMENT24_HIGH VARCHAR2 (60)
SEGMENT25_HIGH VARCHAR2 (60)
SEGMENT26_HIGH VARCHAR2 (60)
SEGMENT27_HIGH VARCHAR2 (60)
SEGMENT28_HIGH VARCHAR2 (60)
SEGMENT29_HIGH VARCHAR2 (60)
SEGMENT30_HIGH VARCHAR2 (60)
SEGMENT31_HIGH_NUMBER NUMBER

SEGMENT32_HIGH_NUMBER NUMBER

SEGMENT33_HIGH_NUMBER NUMBER

SEGMENT34_HIGH_NUMBER NUMBER

SEGMENT35_HIGH_DATE DATE

SEGMENT36_HIGH_DATE DATE

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (240)
ATTRIBUTE2 VARCHAR2 (240)
ATTRIBUTE3 VARCHAR2 (240)
ATTRIBUTE4 VARCHAR2 (240)
ATTRIBUTE5 VARCHAR2 (240)
ATTRIBUTE6 VARCHAR2 (240)
ATTRIBUTE7 VARCHAR2 (240)
ATTRIBUTE8 VARCHAR2 (240)
ATTRIBUTE9 VARCHAR2 (240)
ATTRIBUTE10 VARCHAR2 (240)
ATTRIBUTE11 VARCHAR2 (240)
ATTRIBUTE12 VARCHAR2 (240)
ATTRIBUTE13 VARCHAR2 (240)
ATTRIBUTE14 VARCHAR2 (240)
ATTRIBUTE15 VARCHAR2 (240)
ATTRIBUTE16 VARCHAR2 (240)
ATTRIBUTE17 VARCHAR2 (240)
ATTRIBUTE18 VARCHAR2 (240)
ATTRIBUTE19 VARCHAR2 (240)
ATTRIBUTE20 VARCHAR2 (240)
ATTRIBUTE21 VARCHAR2 (240)
ATTRIBUTE22 VARCHAR2 (240)
ATTRIBUTE23 VARCHAR2 (240)
ATTRIBUTE24 VARCHAR2 (240)
ATTRIBUTE25 VARCHAR2 (240)
ATTRIBUTE26 VARCHAR2 (240)
ATTRIBUTE27 VARCHAR2 (240)
ATTRIBUTE28 VARCHAR2 (240)
ATTRIBUTE29 VARCHAR2 (240)
ATTRIBUTE30 VARCHAR2 (240)
ATTRIBUTE21_NUMBER NUMBER

ATTRIBUTE22_NUMBER NUMBER

ATTRIBUTE23_DATE DATE

ATTRIBUTE24_DATE DATE

DATA_FIELD VARCHAR2 (2000)
Query Text

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


SELECT APPLICATION_ID
,      ID_FLEX_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      UNIQUE_ID_COLUMN
,      UNIQUE_ID_COLUMN2
,      SET_DEFINING_COLUMN
,      SUMMARY_FLAG
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      SEGMENT31_NUMBER
,      SEGMENT32_NUMBER
,      SEGMENT33_NUMBER
,      SEGMENT34_NUMBER
,      SEGMENT35_DATE
,      SEGMENT36_DATE
,      SEGMENT1_LOW
,      SEGMENT2_LOW
,      SEGMENT3_LOW
,      SEGMENT4_LOW
,      SEGMENT5_LOW
,      SEGMENT6_LOW
,      SEGMENT7_LOW
,      SEGMENT8_LOW
,      SEGMENT9_LOW
,      SEGMENT10_LOW
,      SEGMENT11_LOW
,      SEGMENT12_LOW
,      SEGMENT13_LOW
,      SEGMENT14_LOW
,      SEGMENT15_LOW
,      SEGMENT16_LOW
,      SEGMENT17_LOW
,      SEGMENT18_LOW
,      SEGMENT19_LOW
,      SEGMENT20_LOW
,      SEGMENT21_LOW
,      SEGMENT22_LOW
,      SEGMENT23_LOW
,      SEGMENT24_LOW
,      SEGMENT25_LOW
,      SEGMENT26_LOW
,      SEGMENT27_LOW
,      SEGMENT28_LOW
,      SEGMENT29_LOW
,      SEGMENT30_LOW
,      SEGMENT31_LOW_NUMBER
,      SEGMENT32_LOW_NUMBER
,      SEGMENT33_LOW_NUMBER
,      SEGMENT34_LOW_NUMBER
,      SEGMENT35_LOW_DATE
,      SEGMENT36_LOW_DATE
,      SEGMENT1_HIGH
,      SEGMENT2_HIGH
,      SEGMENT3_HIGH
,      SEGMENT4_HIGH
,      SEGMENT5_HIGH
,      SEGMENT6_HIGH
,      SEGMENT7_HIGH
,      SEGMENT8_HIGH
,      SEGMENT9_HIGH
,      SEGMENT10_HIGH
,      SEGMENT11_HIGH
,      SEGMENT12_HIGH
,      SEGMENT13_HIGH
,      SEGMENT14_HIGH
,      SEGMENT15_HIGH
,      SEGMENT16_HIGH
,      SEGMENT17_HIGH
,      SEGMENT18_HIGH
,      SEGMENT19_HIGH
,      SEGMENT20_HIGH
,      SEGMENT21_HIGH
,      SEGMENT22_HIGH
,      SEGMENT23_HIGH
,      SEGMENT24_HIGH
,      SEGMENT25_HIGH
,      SEGMENT26_HIGH
,      SEGMENT27_HIGH
,      SEGMENT28_HIGH
,      SEGMENT29_HIGH
,      SEGMENT30_HIGH
,      SEGMENT31_HIGH_NUMBER
,      SEGMENT32_HIGH_NUMBER
,      SEGMENT33_HIGH_NUMBER
,      SEGMENT34_HIGH_NUMBER
,      SEGMENT35_HIGH_DATE
,      SEGMENT36_HIGH_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE21_NUMBER
,      ATTRIBUTE22_NUMBER
,      ATTRIBUTE23_DATE
,      ATTRIBUTE24_DATE
,      DATA_FIELD
FROM APPLSYS.FND_FLEX_TEST#;

Dependencies

[top of page]

APPLSYS.FND_FLEX_TEST# references the following:

SchemaAPPLSYS
TableFND_FLEX_TEST
APPLSYS.FND_FLEX_TEST# is referenced by following:

SchemaAPPS
SynonymFND_FLEX_TEST