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 1862: mtl_item_categories mic,

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

Line 1939: ,mtl_item_categories mic

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

Line 2098: FROM mtl_item_categories mic

2094:
2095: CURSOR c_line IS
2096: SELECT l.customer_trx_line_id,
2097: lr.deferred_revenue_flag
2098: FROM mtl_item_categories mic
2099: ,ra_customer_trx_lines l
2100: ,ra_rules lr
2101: WHERE l.customer_trx_id = p_customer_trx_id
2102: AND l.line_type = 'LINE'

Line 2469: ,mtl_item_categories mic

2465:
2466: CURSOR c_revenue_total IS
2467: SELECT NVL(SUM(d.amount),0) amount
2468: FROM ra_cust_trx_line_gl_dist d
2469: ,mtl_item_categories mic
2470: ,ra_customer_trx_lines l
2471: WHERE d.customer_trx_line_id = l.customer_trx_line_id
2472: AND d.account_class IN ('REV','UNEARN')
2473: AND NVL(d.revenue_adjustment_id,0) <> NVL(p_revenue_adjustment_id,