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