SLA : Account Derivation Rule Script

 /* account derivation rule  */

SELECT xsr.user_sequence Priority,xsr.VALUE_TYPE_CODE,xsr.VALUE_CODE_COMBINATION_ID,xc.user_sequence seq
,xc.SOURCE_TYPE_CODE,xc.SOURCE_CODE,xc.LINE_OPERATOR_CODE,xc.VALUE_TYPE_CODE VLAUE_TYPE,xc.VALUE_CONSTANT
  FROM xla_seg_rule_details xsr,
       xla_conditions xc
 WHERE segment_rule_code = 'XX_RCA_COMBINATION1'
   AND xsr.SEGMENT_RULE_DETAIL_ID = xc.SEGMENT_RULE_DETAIL_ID
   AND xsr.application_id = xc.application_id
   
--   AND xsr.user_sequence > 600
--   AND xsr.user_sequence <= 1020

Oracle Apps R12: Check if the patch applied or not

--Check if the patch applied or not

This table includes the defined bugs on the system:

SELECT    bug_number

       || '.'

       || aru_release_name

       || '.'

       || UPPER (trackable_entity_abbr)

       || '.'

       || baseline_name

          Patch

FROM     apps.ad_bugs
WHERE   bug_number LIKE '%' ||3594604 || '%';

This table includes patches applied on the system:

SELECT patch_name

FROM   apps.ad_applied_patches
WHERE patch_name LIKE '%' ||3594604 || '%'