APPS.AR_RAAPI_UTIL dependencies on MTL_ITEM_CATEGORIES

Line 883: FROM mtl_item_categories c,

879: AND structure_id = g_category_structure_id;
880:
881: CURSOR c_cat_exists_on_trx(p_category_id NUMBER) IS
882: SELECT COUNT(*)
883: FROM mtl_item_categories c,
884: ra_customer_trx_lines l
885: WHERE c.inventory_item_id = l.inventory_item_id
886: AND l.customer_trx_id = g_customer_trx_id
887: AND c.category_id = p_category_id

Line 1861: mtl_item_categories mic,

1857: CURSOR c_salesrep_totals IS
1858: SELECT NVL(SUM(s.revenue_percent_split),0),
1859: NVL(SUM(s.non_revenue_percent_split),0)
1860: FROM ra_cust_trx_line_salesreps s,
1861: mtl_item_categories mic,
1862: ra_customer_trx_lines l
1863: WHERE s.customer_trx_line_id = l.customer_trx_line_id
1864: AND l.customer_trx_id = p_customer_trx_id
1865: AND l.line_type = 'LINE'

Line 1938: ,mtl_item_categories mic

1934:
1935: CURSOR c_all_line_total IS
1936: SELECT NVL(SUM(d.amount),0) amount
1937: FROM ra_cust_trx_line_gl_dist d
1938: ,mtl_item_categories mic
1939: ,ra_customer_trx_lines l
1940: WHERE d.customer_trx_line_id = l.customer_trx_line_id
1941: AND l.line_type = 'LINE'
1942: AND l.customer_trx_id = p_customer_trx_id

Line 2031: FROM mtl_item_categories mic

2027:
2028: CURSOR c_line IS
2029: SELECT l.customer_trx_line_id,
2030: lr.deferred_revenue_flag
2031: FROM mtl_item_categories mic
2032: ,ra_customer_trx_lines l
2033: ,ra_rules lr
2034: WHERE l.customer_trx_id = p_customer_trx_id
2035: AND l.line_type = 'LINE'

Line 2311: ,mtl_item_categories mic

2307:
2308: CURSOR c_revenue_total IS
2309: SELECT NVL(SUM(d.amount),0) amount
2310: FROM ra_cust_trx_line_gl_dist d
2311: ,mtl_item_categories mic
2312: ,ra_customer_trx_lines l
2313: WHERE d.customer_trx_line_id = l.customer_trx_line_id
2314: AND d.account_class IN ('REV','UNEARN')
2315: AND NVL(d.revenue_adjustment_id,0) <> NVL(p_revenue_adjustment_id,