/* CVR CROSS VALIDATION RULE DETAIL LISTING Provides detail view of CVR definition including account ranges. (Tested on Vision 11.5.10.2 June 2007 )*/ SELECT FST.ID_FLEX_STRUCTURE_NAME , R.FLEX_VALIDATION_RULE_NAME , R.ENABLED_FLAG --, R.ERROR_SEGMENT_COLUMN_NAME"ERR SEG" --, TL.DESCRIPTION --, TL.ERROR_MESSAGE_TEXT"ERROR MESSAGE" , L.ENABLED_FLAG , L.INCLUDE_EXCLUDE_INDICATOR"INC?" , L.CONCATENATED_SEGMENTS_LOW "FROM" , L.CONCATENATED_SEGMENTS_HIGH "TO" , L.LAST_UPDATED_BY , L.LAST_UPDATE_DATE FROM FND_FLEX_VALIDATION_RULES R, FND_FLEX_VDATION_RULES_TL TL, FND_FLEX_VALIDATION_RULE_LINES L, 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 = 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 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 -- OPTIONAL FILTERS BELOW TO LIMIT QUERY TO SPECIFIC CVR OR LINES --AND R.ERROR_SEGMENT_COLUMN_NAME = 'SEGMENT5' --AND TL.ERROR_MESSAGE_TEXT LIKE '%PLEASE USE A VALID R%' --AND R.FLEX_VALIDATION_RULE_NAME LIKE 'BE GROUP ERROR%' --AND TL.ERROR_MESSAGE_TEXT LIKE '%94005%' --AND L.INCLUDE_EXCLUDE_INDICATOR = 'E' ORDER BY 1,R.FLEX_VALIDATION_RULE_NAME, L.INCLUDE_EXCLUDE_INDICATOR DESC, L.CONCATENATED_SEGMENTS_LOW
Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.
If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Thursday, November 17, 2011
CVR CROSS VALIDATION RULE DETAIL LISTING
Subscribe to:
Post Comments (Atom)
If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
No comments:
Post a Comment