DBA Data[Home] [Help]

APPS.AR_REVENUE_MANAGEMENT_PVT dependencies on AR_INTERFACE_CONTS

Line 2079: ar_interface_conts ic,

2075: ct.org_id
2076: FROM ra_customer_trx_lines ctl,
2077: ra_customer_trx ct,
2078: ra_cust_trx_types ctt,
2079: ar_interface_conts ic,
2080: ar_deferral_reasons dr,
2081: pa_implementations pa
2082: WHERE ctl.request_id = p_request_id
2083: AND ctl.customer_trx_id = ct.customer_trx_id

Line 2366: ar_interface_conts ic,

2362: MAX(il.parent_line_id)
2363: FROM ra_customer_trx ct,
2364: ra_customer_trx_lines ctl,
2365: ar_line_conts lrc,
2366: ar_interface_conts ic,
2367: ra_interface_lines il
2368: WHERE ctl.request_id = p_request_id
2369: AND ctl.customer_trx_id = ct.customer_trx_id
2370: AND ctl.customer_trx_line_id = lrc.customer_trx_line_id

Line 2665: ar_interface_conts c

2661: arp_standard.fnd_message('AR_RVMG_INVALID_CONTINGENCY'),
2662: c.contingency_id,
2663: l.org_id
2664: FROM ra_interface_lines l,
2665: ar_interface_conts c
2666: WHERE l.request_id = p_request_id
2667: AND c.interface_line_id = l.interface_line_id
2668: AND NOT EXISTS
2669: (

Line 2705: ar_interface_conts c,

2701: arp_standard.fnd_message('AR_RVMG_NO_EXP_DATE'),
2702: c.contingency_id,
2703: l.org_id
2704: FROM ra_interface_lines l,
2705: ar_interface_conts c,
2706: ar_deferral_reasons dr
2707: WHERE l.request_id = p_request_id
2708: AND c.interface_line_id = l.interface_line_id
2709: AND dr.contingency_id = c.contingency_id