eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_GL_INTERFACE_PVT dependencies on OZF_CLAIM_LINES_UTIL_ALL

Line 162: from ozf_claim_lines_util_all u

158: , f.product_level_type
159: , f.product_id
160: , f.price_adjustment_id
161: , f.cust_account_id
162: from ozf_claim_lines_util_all u
163: , ozf_claim_lines_all l
164: , ozf_claims_all c
165: , ozf_funds_utilized_all_b f
166: where u.claim_line_id = l.claim_line_id

Line 180: FROM ozf_claim_lines_util_all u

176: --, SUM(l.acctd_amount)
177: SELECT SUM(u.amount)
178: , SUM(u.acctd_amount)
179: , c.currency_code
180: FROM ozf_claim_lines_util_all u
181: , ozf_claim_lines_all l
182: , ozf_claims_all c
183: WHERE l.claim_id = c.claim_id
184: AND l.earnings_associated_flag = 'T'

Line 207: from ozf_claim_lines_util_all u

203: , f.product_id
204: , f.price_adjustment_id
205: , f.cust_account_id
206: , c.claim_id
207: from ozf_claim_lines_util_all u
208: , ozf_claim_lines_all l
209: , ozf_claims_all c
210: , ozf_funds_utilized_all_b f
211: where u.claim_line_id = l.claim_line_id

Line 246: from ozf_claim_lines_util_all u

242: , l.item_id
243: , f.price_adjustment_id
244: , f.cust_account_id
245: , c.claim_id
246: from ozf_claim_lines_util_all u
247: , ozf_claim_lines_all l
248: , ozf_claims_all c
249: , ozf_funds_utilized_all_b f
250: where u.claim_line_id = l.claim_line_id

Line 560: ELSIF upper(p_source_table) = 'OZF_CLAIM_LINES_UTIL_ALL' THEN

556: l_acct_gen_tbl(l_rec_num).currency_code,
557: l_acct_gen_tbl(l_rec_num).claim_id;
558: CLOSE get_claim_line_amt_csr;
559: END IF;
560: ELSIF upper(p_source_table) = 'OZF_CLAIM_LINES_UTIL_ALL' THEN
561: IF p_account_type = 'ACCRUAL_LIABILITY' OR
562: p_account_type = 'EXPENSE ACCOUNT'
563: THEN
564: OPEN get_line_util_csr(p_source_id);

Line 713: IF upper(p_source_table) = 'OZF_CLAIM_LINES_UTIL_ALL' THEN

709: OPEN get_claim_payment_method_csr(l_claim_id);
710: FETCH get_claim_payment_method_csr INTO l_payment_method;
711: CLOSE get_claim_payment_method_csr;
712:
713: IF upper(p_source_table) = 'OZF_CLAIM_LINES_UTIL_ALL' THEN
714: -- use account generator for reposting utilization;
715: -- otherwise use the utilization's original account
716: -- R12.1 Enhancement : Call the Account Generator for clearing Account
717: IF (p_account_type = 'EXPENSE ACCOUNT' AND p_event_type = 'DR') OR

Line 1304: , ozf_claim_lines_util_all lu

1300:
1301: CURSOR get_product_line_csr(p_claim_id in number) IS
1302: select lu.claim_line_util_id
1303: from ozf_claim_lines_all ln
1304: , ozf_claim_lines_util_all lu
1305: , ozf_funds_utilized_all_b fu
1306: , ozf_offers o
1307: , ams_custom_setup_attr c
1308: where ln.claim_line_id = lu.claim_line_id

Line 1446: p_source_table => 'OZF_CLAIM_LINES_UTIL_ALL',

1442: x_msg_data => l_msg_data,
1443: x_msg_count => l_msg_count,
1444: x_return_status => x_return_status,
1445: p_source_id => l_claim_line_util_id,
1446: p_source_table => 'OZF_CLAIM_LINES_UTIL_ALL',
1447: p_account_type => 'ACCRUAL_LIABILITY',
1448: p_event_type => l_debit_event,
1449: x_cc_id_tbl => l_prod_dr_cc_id_tbl_1);
1450: IF x_return_status = FND_API.g_ret_sts_error THEN

Line 1468: p_source_table => 'OZF_CLAIM_LINES_UTIL_ALL',

1464: x_msg_data => l_msg_data,
1465: x_msg_count => l_msg_count,
1466: x_return_status => x_return_status,
1467: p_source_id => l_claim_line_util_id,
1468: p_source_table => 'OZF_CLAIM_LINES_UTIL_ALL',
1469: p_account_type => 'EXPENSE ACCOUNT',
1470: p_event_type => l_credit_event,
1471: x_cc_id_tbl => l_prod_cr_cc_id_tbl_1);
1472: IF x_return_status = FND_API.g_ret_sts_error THEN

Line 1490: p_source_table => 'OZF_CLAIM_LINES_UTIL_ALL',

1486: x_msg_data => l_msg_data,
1487: x_msg_count => l_msg_count,
1488: x_return_status => x_return_status,
1489: p_source_id => l_claim_line_util_id,
1490: p_source_table => 'OZF_CLAIM_LINES_UTIL_ALL',
1491: p_account_type => 'EXPENSE ACCOUNT',
1492: p_event_type => l_debit_event,
1493: x_cc_id_tbl => l_prod_dr_cc_id_tbl_2);
1494: IF x_return_status = FND_API.g_ret_sts_error THEN

Line 1512: p_source_table => 'OZF_CLAIM_LINES_UTIL_ALL',

1508: x_msg_data => l_msg_data,
1509: x_msg_count => l_msg_count,
1510: x_return_status => x_return_status,
1511: p_source_id => l_claim_line_util_id,
1512: p_source_table => 'OZF_CLAIM_LINES_UTIL_ALL',
1513: p_account_type => 'ACCRUAL_LIABILITY',
1514: p_event_type => l_credit_event,
1515: x_cc_id_tbl => l_prod_cr_cc_id_tbl_2);
1516: IF x_return_status = FND_API.g_ret_sts_error THEN

Line 2094: FROM ozf_claim_lines_util_all u

2090: CURSOR get_fxgl_amt_csr( p_claim_id in number) IS
2091: SELECT SUM(u.amount)
2092: , SUM(u.fxgl_acctd_amount)
2093: , c.currency_code
2094: FROM ozf_claim_lines_util_all u
2095: , ozf_claim_lines_all l
2096: , ozf_claims_all c
2097: WHERE l.claim_id = c.claim_id
2098: AND l.earnings_associated_flag = 'T'

Line 2506: from ozf_claim_lines_util_all lu

2502: */
2503:
2504: CURSOR promo_claim_csr(p_id in number) IS
2505: select nvl(sum(lu.amount), 0)
2506: from ozf_claim_lines_util_all lu
2507: where lu.claim_line_id in (select l.claim_line_id
2508: from ozf_claim_lines_all l
2509: where l.claim_id = p_id);
2510: