[Home] [Help]
576: /* Multi-Org Access Control Changes for SSA;Begin;anukumar;11/01/2002*/
577: ,org_id
578: /* Multi-Org Access Control Changes for SSA;end;anukumar;11/01/2002*/
579: --end anuj
580: FROM ra_cust_trx_line_salesreps
581: WHERE customer_trx_id = g_customer_trx_id
582: AND customer_trx_line_id IS NOT NULL
583: /* BEGIN bug 3067675 */
584: --AND salesrep_id = g_from_salesrep_id
1856:
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
1953: AND ((p_salesrep_id IS NULL AND p_salesgroup_id IS NULL AND
1954: p_sales_credit_type IS NULL)
1955: OR EXISTS
1956: (SELECT 'X'
1957: FROM ra_cust_trx_line_salesreps ls
1958: WHERE ls.customer_trx_line_id = l.customer_trx_line_id
1959: AND ls.salesrep_id = NVL(p_salesrep_id,ls.salesrep_id)
1960: AND DECODE(p_sales_credit_type,'N',NVL(ls.non_revenue_salesgroup_id, -9999), NVL(ls.revenue_salesgroup_id, -9999)) =
1961: NVL(p_salesgroup_id, DECODE(p_sales_credit_type,'N',NVL(ls.non_revenue_salesgroup_id, -9999), NVL(ls.revenue_salesgroup_id, -9999)))
2051: AND ((p_salesrep_id IS NULL AND p_salesgroup_id IS NULL AND
2052: p_sales_credit_type IS NULL)
2053: OR EXISTS
2054: (SELECT 'X'
2055: FROM ra_cust_trx_line_salesreps ls
2056: WHERE ls.customer_trx_line_id = l.customer_trx_line_id
2057: AND ls.salesrep_id = NVL(p_salesrep_id,ls.salesrep_id)
2058: AND DECODE(p_sales_credit_type,'N',NVL(ls.non_revenue_salesgroup_id, -9999), NVL(ls.revenue_salesgroup_id, -9999)) =
2059: NVL(p_salesgroup_id, DECODE(p_sales_credit_type,'N',NVL(ls.non_revenue_salesgroup_id, -9999), NVL(ls.revenue_salesgroup_id, -9999)))
2068: SELECT /*+ index(d ra_cust_trx_line_gl_dist_n1) push_pred(s)*/
2069: NVL(SUM(d.amount),0) amount
2070: ,NVL(SUM(d.acctd_amount),0) acctd_amount
2071: FROM ra_cust_trx_line_gl_dist d,
2072: ra_cust_trx_line_salesreps s
2073: WHERE d.customer_trx_line_id = p_cust_trx_line_id
2074: AND d.customer_trx_id = p_customer_trx_id
2075: AND d.account_class = DECODE(p_adjustment_type,'EA','UNEARN','REV')
2076: AND NVL(d.revenue_adjustment_id,0) <> NVL(p_revenue_adjustment_id,
2090: NVL(SUM(NVL(d.amount,0)),0) amount
2091: ,NVL(SUM(NVL(d.acctd_amount,0)),0) acctd_amount
2092: FROM ra_cust_trx_line_gl_dist d
2093: ,ra_customer_trx_lines l
2094: ,ra_cust_trx_line_salesreps s
2095: WHERE l.previous_customer_trx_line_id = p_cust_trx_line_id
2096: AND d.customer_trx_id = l.customer_trx_id
2097: AND d.customer_trx_line_id = l.customer_trx_line_id
2098: AND d.account_class = DECODE(p_adjustment_type,'EA','UNEARN','REV')
2108: NVL(s.revenue_salesgroup_id, -9999));
2109:
2110: CURSOR c_line_nr_amount (p_cust_trx_line_id NUMBER) IS
2111: SELECT SUM(NVL(s.non_revenue_amount_split,0)) amount
2112: FROM ra_cust_trx_line_salesreps s
2113: WHERE s.customer_trx_line_id = p_cust_trx_line_id
2114: AND s.salesrep_id = NVL(p_salesrep_id,s.salesrep_id)
2115: AND NVL(s.non_revenue_salesgroup_id, -9999) =
2116: NVL(p_salesgroup_id,
2120:
2121: CURSOR c_cm_line_nr_amount (p_cust_trx_line_id NUMBER) IS
2122: SELECT NVL(SUM(NVL(s.non_revenue_amount_split,0)),0) amount
2123: FROM ra_customer_trx_lines l
2124: ,ra_cust_trx_line_salesreps s
2125: WHERE l.previous_customer_trx_line_id = p_cust_trx_line_id
2126: AND l.customer_trx_line_id = s.customer_trx_line_id
2127: AND s.salesrep_id = NVL(p_salesrep_id /* sr_id */,s.salesrep_id)
2128: AND NVL(s.non_revenue_salesgroup_id, -9999) =
2333: AND ((p_salesrep_id IS NULL AND p_salesgroup_id IS NULL AND
2334: p_sales_credit_type IS NULL)
2335: OR EXISTS
2336: (SELECT 'X'
2337: FROM ra_cust_trx_line_salesreps ls
2338: WHERE ls.customer_trx_line_id = l.customer_trx_line_id
2339: AND ls.salesrep_id = NVL(p_salesrep_id,ls.salesrep_id)
2340: AND DECODE(p_sales_credit_type,'N',
2341: NVL(ls.non_revenue_salesgroup_id, -9999),