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_VOLUME_CALCULATION_PUB dependencies on OZF_VOLUME_DETAIL

Line 222: FROM ozf_volume_detail

218: AND tier_type = 'PBH';
219:
220: CURSOR c_line_processed(p_offer_id NUMBER, p_source_code VARCHAR2, p_line_id NUMBER) IS
221: SELECT 'Y'
222: FROM ozf_volume_detail
223: WHERE offer_id = p_offer_id
224: AND source_code = p_source_code
225: AND order_line_id = p_line_id;
226:

Line 417: INSERT INTO ozf_volume_detail

413: END IF;
414: ozf_utility_pvt.write_conc_log('l_current_volume ' || l_current_volume);
415: IF l_include_volume = 'Y' THEN
416: -- process volume detail
417: INSERT INTO ozf_volume_detail
418: (
419: volume_detail_id
420: ,creation_date
421: ,created_by

Line 446: ozf_volume_detail_s.NEXTVAL

442: ,source_code
443: )
444: VALUES
445: (
446: ozf_volume_detail_s.NEXTVAL
447: ,SYSDATE
448: ,FND_GLOBAL.user_id
449: ,SYSDATE
450: ,FND_GLOBAL.user_id

Line 1371: FROM ozf_volume_detail

1367: IS
1368: -- julou bug 6348078. volume before trx_date
1369: CURSOR c_group_volume(p_volume_track_id NUMBER) IS
1370: SELECT NVL(SUM(volume), 0)
1371: FROM ozf_volume_detail
1372: WHERE include_volume_flag = 'Y'
1373: AND offer_id = p_offer_id
1374: AND group_no = p_volume_track_id
1375: AND pbh_line_id = p_pbh_line_id

Line 1380: FROM ozf_volume_detail

1376: AND transaction_date < p_transaction_date;
1377:
1378: CURSOR c_dist_volume(p_volume_track_id NUMBER) IS
1379: SELECT NVL(SUM(volume), 0)
1380: FROM ozf_volume_detail
1381: WHERE include_volume_flag = 'Y'
1382: AND offer_id = p_offer_id
1383: AND distributor_acct_id = p_volume_track_id
1384: AND pbh_line_id = p_pbh_line_id

Line 1389: FROM ozf_volume_detail

1385: AND transaction_date < p_transaction_date;
1386:
1387: CURSOR c_customer_volume(p_volume_track_id NUMBER) IS
1388: SELECT NVL(SUM(volume), 0)
1389: FROM ozf_volume_detail
1390: WHERE include_volume_flag = 'Y'
1391: AND offer_id = p_offer_id
1392: AND cust_account_id = p_volume_track_id
1393: AND pbh_line_id = p_pbh_line_id

Line 1398: FROM ozf_volume_detail

1394: AND transaction_date < p_transaction_date;
1395:
1396: CURSOR c_billto_volume(p_volume_track_id NUMBER) IS
1397: SELECT NVL(SUM(volume), 0)
1398: FROM ozf_volume_detail
1399: WHERE include_volume_flag = 'Y'
1400: AND offer_id = p_offer_id
1401: AND bill_to_site_use_id = p_volume_track_id
1402: AND pbh_line_id = p_pbh_line_id

Line 1407: FROM ozf_volume_detail

1403: AND transaction_date < p_transaction_date;
1404:
1405: CURSOR c_shipto_volume(p_volume_track_id NUMBER) IS
1406: SELECT NVL(SUM(volume), 0)
1407: FROM ozf_volume_detail
1408: WHERE include_volume_flag = 'Y'
1409: AND offer_id = p_offer_id
1410: AND ship_to_site_use_id = p_volume_track_id
1411: AND pbh_line_id = p_pbh_line_id

Line 1416: FROM ozf_volume_detail

1412: AND transaction_date < p_transaction_date;
1413:
1414: CURSOR c_combine_group_volume(p_volume_track_id NUMBER) IS
1415: SELECT NVL(SUM(volume), 0)
1416: FROM ozf_volume_detail
1417: WHERE include_volume_flag = 'Y'
1418: AND offer_id = p_offer_id
1419: AND group_no = p_volume_track_id
1420: AND transaction_date < p_transaction_date;

Line 1424: FROM ozf_volume_detail

1420: AND transaction_date < p_transaction_date;
1421:
1422: CURSOR c_combine_dist_volume(p_volume_track_id NUMBER) IS
1423: SELECT NVL(SUM(volume), 0)
1424: FROM ozf_volume_detail
1425: WHERE include_volume_flag = 'Y'
1426: AND offer_id = p_offer_id
1427: AND distributor_acct_id = p_volume_track_id
1428: AND transaction_date < p_transaction_date;

Line 1432: FROM ozf_volume_detail

1428: AND transaction_date < p_transaction_date;
1429:
1430: CURSOR c_combine_customer_volume(p_volume_track_id NUMBER) IS
1431: SELECT NVL(SUM(volume), 0)
1432: FROM ozf_volume_detail
1433: WHERE include_volume_flag = 'Y'
1434: AND offer_id = p_offer_id
1435: AND cust_account_id = p_volume_track_id
1436: AND transaction_date < p_transaction_date;

Line 1440: FROM ozf_volume_detail

1436: AND transaction_date < p_transaction_date;
1437:
1438: CURSOR c_combine_billto_volume(p_volume_track_id NUMBER) IS
1439: SELECT NVL(SUM(volume), 0)
1440: FROM ozf_volume_detail
1441: WHERE include_volume_flag = 'Y'
1442: AND offer_id = p_offer_id
1443: AND bill_to_site_use_id = p_volume_track_id
1444: AND transaction_date < p_transaction_date;

Line 1448: FROM ozf_volume_detail

1444: AND transaction_date < p_transaction_date;
1445:
1446: CURSOR c_combine_shipto_volume(p_volume_track_id NUMBER) IS
1447: SELECT NVL(SUM(volume), 0)
1448: FROM ozf_volume_detail
1449: WHERE include_volume_flag = 'Y'
1450: AND offer_id = p_offer_id
1451: AND ship_to_site_use_id = p_volume_track_id
1452: AND transaction_date < p_transaction_date;

Line 1456: FROM ozf_volume_detail

1452: AND transaction_date < p_transaction_date;
1453:
1454: CURSOR c_trx_date_volume_pk IS -- PK of volume rec for given order_line_id.
1455: SELECT volume_detail_id
1456: FROM ozf_volume_detail
1457: WHERE include_volume_flag = 'Y'
1458: AND offer_id = p_offer_id
1459: AND source_code = p_source_code
1460: AND order_line_id = p_order_line_id;

Line 1467: FROM ozf_volume_detail

1463:
1464: -- volume of trx_date. if multiple entries found, sum volume by primary key.
1465: CURSOR c_group_volume2(p_volume_track_id NUMBER, p_volume_detail_id NUMBER) IS
1466: SELECT NVL(SUM(volume), 0)
1467: FROM ozf_volume_detail
1468: WHERE include_volume_flag = 'Y'
1469: AND offer_id = p_offer_id
1470: AND group_no = p_volume_track_id
1471: AND pbh_line_id = p_pbh_line_id

Line 1477: FROM ozf_volume_detail

1473: AND volume_detail_id <= p_volume_detail_id;
1474:
1475: CURSOR c_dist_volume2(p_volume_track_id NUMBER, p_volume_detail_id NUMBER) IS
1476: SELECT NVL(SUM(volume), 0)
1477: FROM ozf_volume_detail
1478: WHERE include_volume_flag = 'Y'
1479: AND offer_id = p_offer_id
1480: AND distributor_acct_id = p_volume_track_id
1481: AND pbh_line_id = p_pbh_line_id

Line 1487: FROM ozf_volume_detail

1483: AND volume_detail_id <= p_volume_detail_id;
1484:
1485: CURSOR c_customer_volume2(p_volume_track_id NUMBER, p_volume_detail_id NUMBER) IS
1486: SELECT NVL(SUM(volume), 0)
1487: FROM ozf_volume_detail
1488: WHERE include_volume_flag = 'Y'
1489: AND offer_id = p_offer_id
1490: AND cust_account_id = p_volume_track_id
1491: AND pbh_line_id = p_pbh_line_id

Line 1497: ozf_volume_detail is 00:00:00.

1493: AND volume_detail_id <= p_volume_detail_id;
1494:
1495: -- fix for bug 7353241
1496: /*The trunc function is needed by off-invoice volume offeras transaction_date in
1497: ozf_volume_detail is 00:00:00.
1498: The input parameter p_transaction_date has to be truncated before comparing with table value.
1499: On the other hand, trunc screws accrual incentive. As you know the calculation has two parts,
1500: one for transactions before the day, the other for transactions on the day.
1501: This is mainly for IDSM transactions as transactions may not come in the order of time.

Line 1506: FROM ozf_volume_detail

1502: So we need 2 cursors to handle two types of incentive of volume offer.*/
1503:
1504: CURSOR c_customer_volume3(p_volume_track_id NUMBER, p_volume_detail_id NUMBER) IS
1505: SELECT NVL(SUM(volume), 0)
1506: FROM ozf_volume_detail
1507: WHERE include_volume_flag = 'Y'
1508: AND offer_id = p_offer_id
1509: AND cust_account_id = p_volume_track_id
1510: AND pbh_line_id = p_pbh_line_id

Line 1516: FROM ozf_volume_detail

1512: AND volume_detail_id <= p_volume_detail_id;
1513:
1514: CURSOR c_billto_volume2(p_volume_track_id NUMBER, p_volume_detail_id NUMBER) IS
1515: SELECT NVL(SUM(volume), 0)
1516: FROM ozf_volume_detail
1517: WHERE include_volume_flag = 'Y'
1518: AND offer_id = p_offer_id
1519: AND bill_to_site_use_id = p_volume_track_id
1520: AND pbh_line_id = p_pbh_line_id

Line 1526: FROM ozf_volume_detail

1522: AND volume_detail_id <= p_volume_detail_id;
1523:
1524: CURSOR c_shipto_volume2(p_volume_track_id NUMBER, p_volume_detail_id NUMBER) IS
1525: SELECT NVL(SUM(volume), 0)
1526: FROM ozf_volume_detail
1527: WHERE include_volume_flag = 'Y'
1528: AND offer_id = p_offer_id
1529: AND ship_to_site_use_id = p_volume_track_id
1530: AND pbh_line_id = p_pbh_line_id

Line 1536: FROM ozf_volume_detail

1532: AND volume_detail_id <= p_volume_detail_id;
1533:
1534: CURSOR c_combine_group_volume2(p_volume_track_id NUMBER, p_volume_detail_id NUMBER) IS
1535: SELECT NVL(SUM(volume), 0)
1536: FROM ozf_volume_detail
1537: WHERE include_volume_flag = 'Y'
1538: AND offer_id = p_offer_id
1539: AND group_no = p_volume_track_id
1540: AND transaction_date = p_transaction_date

Line 1545: FROM ozf_volume_detail

1541: AND volume_detail_id <= p_volume_detail_id;
1542:
1543: CURSOR c_combine_dist_volume2(p_volume_track_id NUMBER, p_volume_detail_id NUMBER) IS
1544: SELECT NVL(SUM(volume), 0)
1545: FROM ozf_volume_detail
1546: WHERE include_volume_flag = 'Y'
1547: AND offer_id = p_offer_id
1548: AND distributor_acct_id = p_volume_track_id
1549: AND transaction_date = p_transaction_date

Line 1554: FROM ozf_volume_detail

1550: AND volume_detail_id <= p_volume_detail_id;
1551:
1552: CURSOR c_combine_customer_volume2(p_volume_track_id NUMBER, p_volume_detail_id NUMBER) IS
1553: SELECT NVL(SUM(volume), 0)
1554: FROM ozf_volume_detail
1555: WHERE include_volume_flag = 'Y'
1556: AND offer_id = p_offer_id
1557: AND cust_account_id = p_volume_track_id
1558: AND transaction_date = p_transaction_date

Line 1563: FROM ozf_volume_detail

1559: AND volume_detail_id <= p_volume_detail_id;
1560:
1561: CURSOR c_combine_billto_volume2(p_volume_track_id NUMBER, p_volume_detail_id NUMBER) IS
1562: SELECT NVL(SUM(volume), 0)
1563: FROM ozf_volume_detail
1564: WHERE include_volume_flag = 'Y'
1565: AND offer_id = p_offer_id
1566: AND bill_to_site_use_id = p_volume_track_id
1567: AND transaction_date = p_transaction_date

Line 1572: FROM ozf_volume_detail

1568: AND volume_detail_id <= p_volume_detail_id;
1569:
1570: CURSOR c_combine_shipto_volume2(p_volume_track_id NUMBER, p_volume_detail_id NUMBER) IS
1571: SELECT NVL(SUM(volume), 0)
1572: FROM ozf_volume_detail
1573: WHERE include_volume_flag = 'Y'
1574: AND offer_id = p_offer_id
1575: AND ship_to_site_use_id = p_volume_track_id
1576: AND transaction_date = p_transaction_date

Line 2320: FROM ozf_volume_detail

2316:
2317: /*
2318: CURSOR c_group_no IS
2319: SELECT group_no
2320: FROM ozf_volume_detail
2321: WHERE offer_id = p_offer_id
2322: AND cust_account_id = p_cust_account_id
2323: AND transaction_date =
2324: (

Line 2326: FROM ozf_volume_detail

2322: AND cust_account_id = p_cust_account_id
2323: AND transaction_date =
2324: (
2325: SELECT MAX(transaction_date)
2326: FROM ozf_volume_detail
2327: WHERE cust_account_id = p_cust_account_id
2328: AND offer_id = p_offer_id
2329: );
2330:

Line 2454: from ozf_volume_detail

2450:
2451: --fixed bug 12887627
2452: select sum(volume) customer_volume
2453: into l_product_volume
2454: from ozf_volume_detail
2455: where offer_id = p_offer_id
2456: and cust_account_id = p_cust_account_id
2457: and pbh_line_id = p_pbh_line_id
2458: and group_no = p_group_no --kdass bug 13256460 - added p_group_no