APPS.ARP_CREDIT_MEMO_MODULE dependencies on RA_RULES

Line 1511: ra_rules rule,

1507: inv.unit_selling_price,
1508: cm.unit_selling_price,
1509: inv.rule_end_date
1510: FROM
1511: ra_rules rule,
1512: ra_cust_trx_line_gl_dist cm_rec,
1513: ra_cust_trx_line_gl_dist inv_rec,
1514: ra_cust_trx_line_gl_dist inv_rev,
1515: ra_cust_trx_types inv_type,

Line 1962: ra_rules ir

1958: fnd_currencies fc,
1959: ra_customer_trx_lines ctl,
1960: ra_customer_trx ct,
1961: ra_customer_trx_lines ictl,
1962: ra_rules ir
1963: WHERE lgd.customer_trx_id = ct.customer_trx_id
1964: and lgd.customer_trx_line_id = :customer_trx_line_id_1
1965: and lgd.customer_trx_line_id = ctl.customer_trx_line_id
1966: and fc.currency_code = ct.invoice_currency_code

Line 2315: RA_RULES RR

2311: SELECT SUM(LGD.AMOUNT), MAX(SUBSTR(NVL(RR.TYPE, 'N'), 1, 1))
2312: INTO l_rev_count, l_rule_type
2313: FROM RA_CUST_TRX_LINE_GL_DIST LGD,
2314: RA_CUSTOMER_TRX_LINES_ALL CTL,
2315: RA_RULES RR
2316: WHERE LGD.CUSTOMER_TRX_LINE_ID = p_prev_cust_trx_line_id
2317: AND CTL.CUSTOMER_TRX_LINE_ID = LGD.CUSTOMER_TRX_LINE_ID
2318: AND CTL.ACCOUNTING_RULE_ID = RR.RULE_ID(+)
2319: AND LGD.ACCOUNT_CLASS = 'REV'

Line 5320: from ra_customer_trx_lines tl, ra_rules rl

5316: l_sum_dist NUMBER;
5317:
5318: CURSOR c1 IS
5319: select tl.customer_trx_id
5320: from ra_customer_trx_lines tl, ra_rules rl
5321: where tl.customer_trx_id = p_prev_customer_trx_id
5322: and tl.autorule_complete_flag = 'N'
5323: and tl.accounting_rule_id = rl.rule_id
5324: and substr(rl.type, 1,1) = 'P';

Line 5338: ra_rules rl

5334: AND ctlgd.account_class = 'REC'
5335: AND ctlgd.account_set_flag = 'N')
5336: AND EXISTS (SELECT 1
5337: FROM ra_customer_trx_lines ctl,
5338: ra_rules rl
5339: WHERE ctl.customer_trx_id = int.previous_customer_trx_id
5340: AND ctl.accounting_rule_id = rl.rule_id
5341: AND substr(rl.type, 1,1) = 'P');
5342: