[Home] [Help]
View: FND_FLEX_CROSS_VALIDATION_V
Product: | FND - Application Object Library |
Description: | View of FND_ID_FLEXS, FND_APPLICATION_UNKNOWN_VIEW, and FND_ID_FLEX_STRUCTURES_VL |
Implementation/DBA Data: |
APPS.FND_FLEX_CROSS_VALIDATION_V
|
View Text
SELECT K.ID_FLEX_CODE
, K.ID_FLEX_NAME
, K.DESCRIPTION
, K.APPLICATION_ID
, A.APPLICATION_NAME
, A.APPLICATION_SHORT_NAME
, S.ID_FLEX_NUM
, S.ID_FLEX_STRUCTURE_NAME
, S.DESCRIPTION
FROM FND_ID_FLEXS K
, FND_APPLICATION_VL A
, FND_ID_FLEX_STRUCTURES_VL S
WHERE K.APPLICATION_ID = A.APPLICATION_ID
AND S.APPLICATION_ID = K.APPLICATION_ID
AND S.ID_FLEX_CODE = K.ID_FLEX_CODE
AND S.CROSS_SEGMENT_VALIDATION_FLAG = 'Y'
Columns
Name |
FLEX_CODE |
FLEX_NAME |
FLEX_DESCRIPTION |
APPLICATION_ID |
APPLICATION_NAME |
APPLICATION_SHORT_NAME |
FLEX_STRUCTURE_NUM |
FLEX_STRUCTURE_NAME |
FLEX_STRUCTURE_DESCRIPTION |