DBA Data[Home] [Help]

APPS.AR_REVENUE_MANAGEMENT_PVT dependencies on AR_INTERFACE_CONTS

Line 1970: ar_interface_conts ic,

1966: ct.org_id
1967: FROM ra_customer_trx_lines ctl,
1968: ra_customer_trx ct,
1969: ra_cust_trx_types ctt,
1970: ar_interface_conts ic,
1971: ar_deferral_reasons dr
1972: WHERE ctl.request_id = p_request_id
1973: AND ctl.customer_trx_id = ct.customer_trx_id
1974: AND ct.batch_source_id NOT IN (20, 21)

Line 2252: ar_interface_conts ic,

2248: MAX(il.parent_line_id)
2249: FROM ra_customer_trx ct,
2250: ra_customer_trx_lines ctl,
2251: ar_line_conts lrc,
2252: ar_interface_conts ic,
2253: ra_interface_lines il
2254: WHERE ctl.request_id = p_request_id
2255: AND ctl.customer_trx_id = ct.customer_trx_id
2256: AND ctl.customer_trx_line_id = lrc.customer_trx_line_id

Line 2518: ar_interface_conts c

2514: arp_standard.fnd_message('AR_RVMG_INVALID_CONTINGENCY'),
2515: c.contingency_id,
2516: l.org_id
2517: FROM ra_interface_lines l,
2518: ar_interface_conts c
2519: WHERE l.request_id = p_request_id
2520: AND c.interface_line_id = l.interface_line_id
2521: AND NOT EXISTS
2522: (

Line 2558: ar_interface_conts c,

2554: arp_standard.fnd_message('AR_RVMG_NO_EXP_DATE'),
2555: c.contingency_id,
2556: l.org_id
2557: FROM ra_interface_lines l,
2558: ar_interface_conts c,
2559: ar_deferral_reasons dr
2560: WHERE l.request_id = p_request_id
2561: AND c.interface_line_id = l.interface_line_id
2562: AND dr.contingency_id = c.contingency_id