[Home] [Help]
471: ,l.accounting_rule_id
472: ,l.accounting_rule_duration -- Bug 2168875
473: ,NVL(l.override_auto_accounting_flag,'N')
474: override_auto_accounting_flag-- Bug 3879222
475: FROM mtl_item_categories mic
476: ,ra_customer_trx_lines l
477: WHERE l.line_type = 'LINE'
478: AND l.autorule_complete_flag IS NULL
479: AND l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
964:
965: CURSOR c_trx_total IS
966: SELECT SUM(NVL(s.revenue_amount_split,0))
967: FROM ra_cust_trx_line_salesreps s
968: ,mtl_item_categories mic
969: ,ra_customer_trx_lines l
970: WHERE s.customer_trx_line_id = l.customer_trx_line_id
971: AND l.line_type = 'LINE'
972: AND l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
994:
995: CURSOR c_rev_total IS
996: SELECT NVL(SUM(d.amount),0)
997: FROM ra_cust_trx_line_gl_dist d
998: ,mtl_item_categories mic
999: ,ra_customer_trx_lines l
1000: WHERE d.customer_trx_line_id = l.customer_trx_line_id
1001: AND d.account_class = 'REV'
1002: AND l.line_type = 'LINE'
1025:
1026: CURSOR c_nonrev_trx_total IS
1027: SELECT SUM(NVL(s.non_revenue_amount_split,0))
1028: FROM ra_customer_trx_lines l
1029: ,mtl_item_categories mic
1030: ,ra_cust_trx_line_salesreps s
1031: WHERE l.customer_trx_line_id = s.customer_trx_line_id
1032: AND l.customer_trx_line_id = NVL(AR_RAAPI_UTIL.g_from_cust_trx_line_id,
1033: l.customer_trx_line_id)
1044: AND NVL(s.non_revenue_salesgroup_id,-9999) = NVL(AR_RAAPI_UTIL.g_from_salesgroup_id,NVL(s.non_revenue_salesgroup_id,-9999));
1045:
1046: CURSOR c_nonrev_line_count IS
1047: SELECT COUNT(*)
1048: FROM mtl_item_categories mic
1049: ,ra_customer_trx_lines l
1050: WHERE l.customer_trx_line_id = NVL(AR_RAAPI_UTIL.g_from_cust_trx_line_id,
1051: l.customer_trx_line_id)
1052: AND NVL(l.inventory_item_id,0) =
1078: ,l.memo_line_id
1079: ,l.warehouse_id
1080: ,l.line_number
1081: FROM ra_cust_trx_line_salesreps s
1082: ,mtl_item_categories mic
1083: ,ra_customer_trx_lines l
1084: WHERE l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
1085: AND l.customer_trx_line_id = s.customer_trx_line_id
1086: AND l.customer_trx_line_id =
2057:
2058: CURSOR c_trx_total IS
2059: SELECT SUM(NVL(s.revenue_amount_split,0))
2060: FROM ra_cust_trx_line_salesreps s
2061: ,mtl_item_categories mic
2062: ,ra_customer_trx_lines l
2063: WHERE s.customer_trx_line_id = l.customer_trx_line_id
2064: AND l.line_type = 'LINE'
2065: AND l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
2074: AND mic.category_set_id(+) = AR_RAAPI_UTIL.g_category_set_id;
2075:
2076: CURSOR c_line_count IS
2077: SELECT COUNT(*)
2078: FROM mtl_item_categories mic
2079: ,ra_customer_trx_lines l
2080: WHERE l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
2081: AND l.line_type = 'LINE'
2082: AND l.customer_trx_line_id = NVL(AR_RAAPI_UTIL.g_from_cust_trx_line_id,
2092: CURSOR c_line IS
2093: SELECT l.customer_trx_line_id
2094: ,l.line_number
2095: ,SUM(NVL(s.revenue_amount_split,0)) amount
2096: FROM mtl_item_categories mic
2097: ,ra_cust_trx_line_salesreps s
2098: ,ra_customer_trx_lines l
2099: WHERE l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
2100: AND l.customer_trx_line_id = s.customer_trx_line_id
3985:
3986: CURSOR c_lines_from_total IS
3987: SELECT NVL(SUM(d.amount),0)
3988: FROM ra_cust_trx_line_gl_dist d
3989: ,mtl_item_categories mic
3990: ,ra_customer_trx_lines l
3991: WHERE d.customer_trx_line_id = l.customer_trx_line_id
3992: AND d.account_class = 'REV'
3993: AND l.line_type = 'LINE'
4014: ,l.inventory_item_id
4015: ,l.accounting_rule_id
4016: ,NVL(SUM(d.amount),0) amount
4017: FROM ra_cust_trx_line_gl_dist d
4018: ,mtl_item_categories mic
4019: ,ra_customer_trx_lines l
4020: WHERE d.customer_trx_line_id = l.customer_trx_line_id
4021: AND d.account_class = 'REV'
4022: AND l.line_type = 'LINE'
4052: SELECT NVL(COUNT(DISTINCT tax.item_exception_rate_id||
4053: tax.tax_exemption_id|| tax.vat_tax_id||
4054: tax.sales_tax_id|| tax.tax_rate|| tax.tax_precedence),0)
4055: FROM ra_customer_trx_lines line
4056: ,mtl_item_categories mic
4057: ,ra_customer_trx_lines tax
4058: WHERE line.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
4059: AND tax.line_type = 'TAX'
4060: AND line.customer_trx_line_id = tax.link_to_cust_trx_line_id
4074:
4075: CURSOR c_lines_to_total IS
4076: SELECT NVL(SUM(d.amount),0) amount
4077: FROM ra_cust_trx_line_gl_dist d
4078: ,mtl_item_categories mic
4079: ,ra_customer_trx_lines l
4080: WHERE d.customer_trx_line_id = l.customer_trx_line_id
4081: AND d.account_class = 'REV'
4082: AND l.line_type = 'LINE'
4096: NVL(l.accounting_rule_duration,0),2),2),2) > 1;
4097:
4098: CURSOR c_line_to_count IS
4099: SELECT COUNT(*)
4100: FROM mtl_item_categories mic
4101: ,ra_customer_trx_lines l
4102: WHERE l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
4103: AND l.customer_trx_line_id = NVL(AR_RAAPI_UTIL.g_to_cust_trx_line_id,
4104: l.customer_trx_line_id)
4123: ,l.accounting_rule_id
4124: ,l.accounting_rule_duration
4125: ,SUM(d.amount) amount
4126: FROM ra_cust_trx_line_gl_dist d
4127: ,mtl_item_categories mic
4128: ,ra_customer_trx_lines l
4129: WHERE d.customer_trx_line_id = l.customer_trx_line_id
4130: AND d.account_class = 'REV'
4131: AND l.line_type = 'LINE'
5411: l_fully_recognized_flag VARCHAR2(1) := 'N';
5412:
5413: CURSOR c_line IS
5414: SELECT l.customer_trx_line_id
5415: FROM mtl_item_categories mic
5416: ,ra_rules r
5417: ,ra_customer_trx_lines l
5418: WHERE l.customer_trx_id = p_customer_trx_id
5419: AND l.accounting_rule_id = r.rule_id(+)