View: GCS_LEX_MAP_SEQUENCES_V

Product:	GCS - Financial Consolidation Hub
Description:	IDT derivation information.
Implementation/DBA Data:	APPS.GCS_LEX_MAP_SEQUENCES_V

View Text

SELECT DERIVATIONEO.RULE_ID
, DERIVATIONEO.DERIVATION_ID
, DERIVATIONEO.DERIVATION_SEQUENCE
, NVL(GCS_LEX_MAP_PKG.GET_CONCAT_CONDITIONS(DERIVATION_ID)
, 'DEFAULT') CONDITION
, FL.MEANING DERIVATION_TYPE
FROM GCS_LEX_MAP_DERIVATIONS DERIVATIONEO
, FND_LOOKUP_VALUES FL
WHERE FL.LOOKUP_TYPE= 'DERIVATION_TYPE'
AND FL.LOOKUP_CODE = DERIVATIONEO.DERIVATION_TYPE_CODE
AND FL.VIEW_APPLICATION_ID = 266
AND SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(FL.LOOKUP_TYPE
, FL.VIEW_APPLICATION_ID)
AND LANGUAGE= USERENV('LANG')

Columns