DBA Data[Home] [Help]

APPS.AR_REVENUE_ADJUSTMENT_PVT dependencies on RA_RULES

Line 2473: ra_rules r

2469: l.accounting_rule_duration,
2470: r.deferred_revenue_flag,
2471: l.rule_start_date
2472: FROM ra_customer_trx_lines l,
2473: ra_rules r
2474: WHERE l.accounting_rule_id = r.rule_id
2475: AND l.customer_trx_line_id = p_customer_trx_line_id
2476: AND l.customer_trx_id = p_customer_trx_id
2477: AND l.line_type = 'LINE';

Line 2969: ra_rules r

2965: r.deferred_revenue_flag,
2966: l.warehouse_id,
2967: l.rule_start_date
2968: FROM ra_customer_trx_lines l,
2969: ra_rules r
2970: WHERE l.accounting_rule_id = r.rule_id
2971: AND l.customer_trx_line_id = p_customer_trx_line_id
2972: AND l.customer_trx_id = p_customer_trx_id
2973: AND l.line_type = 'LINE';

Line 5416: ,ra_rules r

5412:
5413: CURSOR c_line IS
5414: SELECT l.customer_trx_line_id
5415: FROM mtl_item_categories mic
5416: ,ra_rules r
5417: ,ra_customer_trx_lines l
5418: WHERE l.customer_trx_id = p_customer_trx_id
5419: AND l.accounting_rule_id = r.rule_id(+)
5420: AND NVL(l.inventory_item_id,0) =