[Home] [Help]
478: ,l.rule_start_date
479: ,l.customer_trx_id
480: ,NVL(r.deferred_revenue_flag,'N') deferred_revenue_flag
481: ,l.extended_amount -- 7569247
482: FROM mtl_item_categories mic
483: ,ra_customer_trx_lines l
484: ,ra_rules r
485: WHERE l.line_type = 'LINE'
486: AND l.autorule_complete_flag IS NULL
1041:
1042: CURSOR c_trx_total IS
1043: SELECT SUM(NVL(s.revenue_amount_split,0))
1044: FROM ra_cust_trx_line_salesreps s
1045: ,mtl_item_categories mic
1046: ,ra_customer_trx_lines l
1047: WHERE s.customer_trx_line_id = l.customer_trx_line_id
1048: AND l.line_type = 'LINE'
1049: AND l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
1071:
1072: CURSOR c_rev_total IS
1073: SELECT NVL(SUM(d.amount),0)
1074: FROM ra_cust_trx_line_gl_dist d
1075: ,mtl_item_categories mic
1076: ,ra_customer_trx_lines l
1077: WHERE d.customer_trx_line_id = l.customer_trx_line_id
1078: AND d.account_class = 'REV'
1079: AND l.line_type = 'LINE'
1102:
1103: CURSOR c_nonrev_trx_total IS
1104: SELECT SUM(NVL(s.non_revenue_amount_split,0))
1105: FROM ra_customer_trx_lines l
1106: ,mtl_item_categories mic
1107: ,ra_cust_trx_line_salesreps s
1108: WHERE l.customer_trx_line_id = s.customer_trx_line_id
1109: AND l.customer_trx_line_id = NVL(AR_RAAPI_UTIL.g_from_cust_trx_line_id,
1110: l.customer_trx_line_id)
1121: AND NVL(s.non_revenue_salesgroup_id,-9999) = NVL(AR_RAAPI_UTIL.g_from_salesgroup_id,NVL(s.non_revenue_salesgroup_id,-9999));
1122:
1123: CURSOR c_nonrev_line_count IS
1124: SELECT COUNT(*)
1125: FROM mtl_item_categories mic
1126: ,ra_customer_trx_lines l
1127: WHERE l.customer_trx_line_id = NVL(AR_RAAPI_UTIL.g_from_cust_trx_line_id,
1128: l.customer_trx_line_id)
1129: AND NVL(l.inventory_item_id,0) =
1155: ,l.memo_line_id
1156: ,l.warehouse_id
1157: ,l.line_number
1158: FROM ra_cust_trx_line_salesreps s
1159: ,mtl_item_categories mic
1160: ,ra_customer_trx_lines l
1161: WHERE l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
1162: AND l.customer_trx_line_id = s.customer_trx_line_id
1163: AND l.customer_trx_line_id =
2134:
2135: CURSOR c_trx_total IS
2136: SELECT SUM(NVL(s.revenue_amount_split,0))
2137: FROM ra_cust_trx_line_salesreps s
2138: ,mtl_item_categories mic
2139: ,ra_customer_trx_lines l
2140: WHERE s.customer_trx_line_id = l.customer_trx_line_id
2141: AND l.line_type = 'LINE'
2142: AND l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
2151: AND mic.category_set_id(+) = AR_RAAPI_UTIL.g_category_set_id;
2152:
2153: CURSOR c_line_count IS
2154: SELECT COUNT(*)
2155: FROM mtl_item_categories mic
2156: ,ra_customer_trx_lines l
2157: WHERE l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
2158: AND l.line_type = 'LINE'
2159: AND l.customer_trx_line_id = NVL(AR_RAAPI_UTIL.g_from_cust_trx_line_id,
2169: CURSOR c_line IS
2170: SELECT l.customer_trx_line_id
2171: ,l.line_number
2172: ,SUM(NVL(s.revenue_amount_split,0)) amount
2173: FROM mtl_item_categories mic
2174: ,ra_cust_trx_line_salesreps s
2175: ,ra_customer_trx_lines l
2176: WHERE l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
2177: AND l.customer_trx_line_id = s.customer_trx_line_id
4201:
4202: CURSOR c_lines_from_total IS
4203: SELECT NVL(SUM(d.amount),0)
4204: FROM ra_cust_trx_line_gl_dist d
4205: ,mtl_item_categories mic
4206: ,ra_customer_trx_lines l
4207: WHERE d.customer_trx_line_id = l.customer_trx_line_id
4208: AND d.account_class = 'REV'
4209: AND l.line_type = 'LINE'
4230: ,l.inventory_item_id
4231: ,l.accounting_rule_id
4232: ,NVL(SUM(d.amount),0) amount
4233: FROM ra_cust_trx_line_gl_dist d
4234: ,mtl_item_categories mic
4235: ,ra_customer_trx_lines l
4236: WHERE d.customer_trx_line_id = l.customer_trx_line_id
4237: AND d.account_class = 'REV'
4238: AND l.line_type = 'LINE'
4268: SELECT NVL(COUNT(DISTINCT tax.item_exception_rate_id||
4269: tax.tax_exemption_id|| tax.vat_tax_id||
4270: tax.sales_tax_id|| tax.tax_rate|| tax.tax_precedence),0)
4271: FROM ra_customer_trx_lines line
4272: ,mtl_item_categories mic
4273: ,ra_customer_trx_lines tax
4274: WHERE line.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
4275: AND tax.line_type = 'TAX'
4276: AND line.customer_trx_line_id = tax.link_to_cust_trx_line_id
4290:
4291: CURSOR c_lines_to_total IS
4292: SELECT NVL(SUM(d.amount),0) amount
4293: FROM ra_cust_trx_line_gl_dist d
4294: ,mtl_item_categories mic
4295: ,ra_customer_trx_lines l
4296: WHERE d.customer_trx_line_id = l.customer_trx_line_id
4297: AND d.account_class = 'REV'
4298: AND l.line_type = 'LINE'
4312: NVL(l.accounting_rule_duration,0),2),2),2) > 1;
4313:
4314: CURSOR c_line_to_count IS
4315: SELECT COUNT(*)
4316: FROM mtl_item_categories mic
4317: ,ra_customer_trx_lines l
4318: WHERE l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
4319: AND l.customer_trx_line_id = NVL(AR_RAAPI_UTIL.g_to_cust_trx_line_id,
4320: l.customer_trx_line_id)
4339: ,l.accounting_rule_id
4340: ,l.accounting_rule_duration
4341: ,SUM(d.amount) amount
4342: FROM ra_cust_trx_line_gl_dist d
4343: ,mtl_item_categories mic
4344: ,ra_customer_trx_lines l
4345: WHERE d.customer_trx_line_id = l.customer_trx_line_id
4346: AND d.account_class = 'REV'
4347: AND l.line_type = 'LINE'
5632: l_fully_recognized_flag VARCHAR2(1) := 'N';
5633:
5634: CURSOR c_line IS
5635: SELECT l.customer_trx_line_id
5636: FROM mtl_item_categories mic
5637: ,ra_rules r
5638: ,ra_customer_trx_lines l
5639: WHERE l.customer_trx_id = p_customer_trx_id
5640: AND l.accounting_rule_id = r.rule_id(+)