Introduction:

A cross-validation rule defines whether a value of a particular segment can be combined with specific values of other segments.The same details we can fetch using the below code.

Script:

SELECT FST.ID_FLEX_STRUCTURE_NAME “Strucuture Name”
, R.FLEX_VALIDATION_RULE_NAME “Cross Rule Name”,tl.description,tl.error_message_text,l.enabled_flag
, decode(L.INCLUDE_EXCLUDE_INDICATOR,’I’,’Inclide’,’E’,’Exclude’) “Indicator Type”
, L.CONCATENATED_SEGMENTS_LOW “Accounts FROM”
, L.CONCATENATED_SEGMENTS_HIGH “Acccounts TO”,l.LAST_UPDATED_BY,l.LAST_UPDATE_date
FROM apps.FND_FLEX_VALIDATION_RULES R,
apps.FND_FLEX_VDATION_RULES_TL TL,
apps.FND_FLEX_VALIDATION_RULE_LINES L,
apps.FND_ID_FLEX_STRUCTURES_VL FST
WHERE R.APPLICATION_ID = TL.APPLICATION_ID
AND FST.ID_FLEX_NUM = R.ID_FLEX_NUM
AND R.ID_FLEX_CODE = L.ID_FLEX_CODE
AND R.ID_FLEX_NUM = L.ID_FLEX_NUM
AND R.FLEX_VALIDATION_RULE_NAME = L.FLEX_VALIDATION_RULE_NAME
AND R.FLEX_VALIDATION_RULE_NAME = L.FLEX_VALIDATION_RULE_NAME
AND R.APPLICATION_ID = 101
AND R.ID_FLEX_CODE = TL.ID_FLEX_CODE
AND R.ID_FLEX_NUM = TL.ID_FLEX_NUM
AND R.FLEX_VALIDATION_RULE_NAME = TL.FLEX_VALIDATION_RULE_NAME
AND R.FLEX_VALIDATION_RULE_NAME = TL.FLEX_VALIDATION_RULE_NAME
AND R.APPLICATION_ID = L.APPLICATION_ID
group by
FST.ID_FLEX_STRUCTURE_NAME
,R.FLEX_VALIDATION_RULE_NAME,tl.description
, L.INCLUDE_EXCLUDE_INDICATOR
, L.CONCATENATED_SEGMENTS_LOW
, L.CONCATENATED_SEGMENTS_HIGH
,tl.error_message_text,l.enabled_flag,l.LAST_UPDATED_BY,l.LAST_UPDATE_DATE
ORDER BY FST.ID_FLEX_STRUCTURE_NAME,R.FLEX_VALIDATION_RULE_NAME,L.CONCATENATED_SEGMENTS_LOW

Got any queries?

Do drop a note by writing us at yeswanth.r@doyensys.com or use the comment section below to ask your questions

Recent Posts

Start typing and press Enter to search