How to find SubLedger accounting package being used for custom or standard subledger accounting engine

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

SELECT
    *
FROM
    all_objects
WHERE
    object_name IN (SELECT 'XLA_'|| lpad(application_id,5,0)
             || '_AAD_'
             || product_rule_type_code
             || '_'
             || lpad(product_rule_hash_id,6,0)
             || '_PKG'
        FROM
            xla.xla_product_rules_b
        WHERE
            ( application_id,product_rule_type_code,product_rule_code,amb_context_code ) IN (
                SELECT
                    application_id,
                    product_rule_type_code,
                    product_rule_code,
                    amb_context_code
                FROM
                    xla.xla_acctg_method_rules
--where acctg_method_rule_id = :l_acctg_method_rule_id
            )
    );