APPS.AR_REVENUE_ADJUSTMENT_PVT dependencies on RA_RULES

Line 484: ,ra_rules r

480: ,NVL(r.deferred_revenue_flag,'N') deferred_revenue_flag
481: ,l.extended_amount -- 7569247
482: FROM mtl_item_categories mic
483: ,ra_customer_trx_lines l
484: ,ra_rules r
485: WHERE l.line_type = 'LINE'
486: AND l.autorule_complete_flag IS NULL
487: AND l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
488: AND l.customer_trx_line_id =

Line 2550: ra_rules r

2546: l.accounting_rule_duration,
2547: r.deferred_revenue_flag,
2548: l.rule_start_date
2549: FROM ra_customer_trx_lines l,
2550: ra_rules r
2551: WHERE l.accounting_rule_id = r.rule_id
2552: AND l.customer_trx_line_id = p_customer_trx_line_id
2553: AND l.customer_trx_id = p_customer_trx_id
2554: AND l.line_type = 'LINE';

Line 3154: ra_rules r

3150: r.deferred_revenue_flag,
3151: l.warehouse_id,
3152: l.rule_start_date
3153: FROM ra_customer_trx_lines l,
3154: ra_rules r
3155: WHERE l.accounting_rule_id = r.rule_id
3156: AND l.customer_trx_line_id = p_customer_trx_line_id
3157: AND l.customer_trx_id = p_customer_trx_id
3158: AND l.line_type = 'LINE';

Line 5637: ,ra_rules r

5633:
5634: CURSOR c_line IS
5635: SELECT l.customer_trx_line_id
5636: FROM mtl_item_categories mic
5637: ,ra_rules r
5638: ,ra_customer_trx_lines l
5639: WHERE l.customer_trx_id = p_customer_trx_id
5640: AND l.accounting_rule_id = r.rule_id(+)
5641: AND NVL(l.inventory_item_id,0) =