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_ALLOCATION_ENGINE_PVT dependencies on OZF_ORDER_SALES_V

Line 297: ozf_order_sales_v bsmv,

293: l_time_id NUMBER) IS
294: SELECT
295: SUM(bsmv.sales) sales
296: FROM
297: ozf_order_sales_v bsmv,
298: ams_party_market_segments a
299: WHERE
300: a.market_qualifier_reference = l_territory_id
301: AND a.market_qualifier_type='TERRITORY'

Line 315: ozf_order_sales_v bsmv,

311: l_fund_id NUMBER) IS
312: SELECT
313: SUM(bsmv.sales) sales
314: FROM
315: ozf_order_sales_v bsmv,
316: ams_party_market_segments a
317: WHERE
318: a.market_qualifier_reference = l_territory_id
319: AND a.market_qualifier_type='TERRITORY'

Line 347: ozf_order_sales_v bsmv,

343: l_fund_id NUMBER) IS
344: SELECT
345: SUM(bsmv.sales) sales
346: FROM
347: ozf_order_sales_v bsmv,
348: ams_party_market_segments a
349: WHERE
350: a.market_qualifier_reference = l_territory_id
351: AND a.market_qualifier_type='TERRITORY'

Line 376: ozf_order_sales_v bsmv,

372: l_fund_id NUMBER) IS
373: SELECT
374: SUM(bsmv.sales) sales
375: FROM
376: ozf_order_sales_v bsmv,
377: ams_party_market_segments a
378: WHERE
379: a.market_qualifier_reference = l_territory_id
380: AND a.market_qualifier_type='TERRITORY'

Line 428: ozf_order_sales_v bsmv,

424: l_fund_id NUMBER) IS
425: SELECT
426: SUM(bsmv.sales) sales
427: FROM
428: ozf_order_sales_v bsmv,
429: ams_party_market_segments a
430: WHERE
431: a.market_qualifier_reference = l_territory_id
432: AND a.market_qualifier_type='TERRITORY'

Line 996: ozf_order_sales_v bsmv,

992: l_time_id NUMBER) IS
993: SELECT
994: SUM(bsmv.sales) sales
995: FROM
996: ozf_order_sales_v bsmv,
997: ams_party_market_segments a
998: WHERE
999: a.market_qualifier_reference = l_territory_id
1000: AND a.market_qualifier_type='TERRITORY'

Line 1013: ozf_order_sales_v bsmv,

1009: l_fund_id NUMBER) IS
1010: SELECT
1011: SUM(bsmv.sales) sales
1012: FROM
1013: ozf_order_sales_v bsmv,
1014: ams_party_market_segments a
1015: WHERE
1016: a.market_qualifier_reference = l_territory_id
1017: AND a.market_qualifier_type='TERRITORY'

Line 1041: ozf_order_sales_v bsmv,

1037: l_fund_id NUMBER) IS
1038: SELECT
1039: SUM(bsmv.sales) sales
1040: FROM
1041: ozf_order_sales_v bsmv,
1042: ams_party_market_segments a
1043: WHERE
1044: a.market_qualifier_reference = l_territory_id
1045: AND a.market_qualifier_type='TERRITORY'

Line 1707: ozf_order_sales_v bsmv,

1703: l_time_id NUMBER) IS
1704: SELECT
1705: SUM(bsmv.sales) sales
1706: FROM
1707: ozf_order_sales_v bsmv,
1708: ams_party_market_segments a
1709: WHERE
1710: a.market_qualifier_reference = l_territory_id
1711: AND a.market_qualifier_type='TERRITORY'

Line 1724: ozf_order_sales_v bsmv,

1720: l_fund_id NUMBER) IS
1721: SELECT
1722: SUM(bsmv.sales) sales
1723: FROM
1724: ozf_order_sales_v bsmv,
1725: ams_party_market_segments a
1726: WHERE
1727: a.market_qualifier_reference = l_territory_id
1728: AND a.market_qualifier_type='TERRITORY'

Line 1752: ozf_order_sales_v bsmv,

1748: l_fund_id NUMBER) IS
1749: SELECT
1750: SUM(bsmv.sales) sales
1751: FROM
1752: ozf_order_sales_v bsmv,
1753: ams_party_market_segments a
1754: WHERE
1755: a.market_qualifier_reference = l_territory_id
1756: AND a.market_qualifier_type='TERRITORY'

Line 2522: ozf_order_sales_v bsmv,

2518: l_time_id NUMBER) IS
2519: SELECT
2520: SUM(bsmv.sales) sales
2521: FROM
2522: ozf_order_sales_v bsmv,
2523: ams_party_market_segments a
2524: WHERE
2525: a.market_qualifier_reference = l_territory_id
2526: AND a.market_qualifier_type='TERRITORY'

Line 2539: ozf_order_sales_v bsmv,

2535: l_fund_id NUMBER) IS
2536: SELECT
2537: SUM(bsmv.sales) sales
2538: FROM
2539: ozf_order_sales_v bsmv,
2540: ams_party_market_segments a
2541: WHERE
2542: a.market_qualifier_reference = l_territory_id
2543: AND a.market_qualifier_type='TERRITORY'

Line 2569: ozf_order_sales_v bsmv,

2565: l_fund_id NUMBER) IS
2566: SELECT
2567: SUM(bsmv.sales) sales
2568: FROM
2569: ozf_order_sales_v bsmv,
2570: ams_party_market_segments a
2571: WHERE
2572: a.market_qualifier_reference = l_territory_id
2573: AND a.market_qualifier_type='TERRITORY'

Line 4130: ozf_order_sales_v bsmv,

4126: l_time_id NUMBER) IS
4127: SELECT
4128: SUM(bsmv.sales) sales
4129: FROM
4130: ozf_order_sales_v bsmv,
4131: ams_party_market_segments a
4132: WHERE
4133: a.market_qualifier_reference = l_territory_id
4134: AND a.market_qualifier_type='TERRITORY'

Line 4147: ozf_order_sales_v bsmv,

4143: l_fund_id NUMBER) IS
4144: SELECT
4145: SUM(bsmv.sales) sales
4146: FROM
4147: ozf_order_sales_v bsmv,
4148: ams_party_market_segments a
4149: WHERE
4150: a.market_qualifier_reference = l_territory_id
4151: AND a.market_qualifier_type='TERRITORY'

Line 4572: ozf_order_sales_v bsmv,

4568: l_time_id NUMBER) IS
4569: SELECT
4570: SUM(bsmv.sales) sales
4571: FROM
4572: ozf_order_sales_v bsmv,
4573: ams_party_market_segments a
4574: WHERE
4575: a.market_qualifier_reference = l_territory_id
4576: AND a.market_qualifier_type='TERRITORY'

Line 4589: ozf_order_sales_v bsmv,

4585: l_fund_id NUMBER) IS
4586: SELECT
4587: SUM(bsmv.sales) sales
4588: FROM
4589: ozf_order_sales_v bsmv,
4590: ams_party_market_segments a
4591: WHERE
4592: a.market_qualifier_reference = l_territory_id
4593: AND a.market_qualifier_type='TERRITORY'

Line 5034: ozf_order_sales_v bsmv,

5030: IS
5031: SELECT
5032: SUM(bsmv.sales) sales
5033: FROM
5034: ozf_order_sales_v bsmv,
5035: ams_party_market_segments a
5036: WHERE
5037: a.market_qualifier_reference = l_territory_id
5038: AND a.market_qualifier_type='TERRITORY'

Line 5047: ' ozf_order_sales_v bsmv,'||

5043: l_total_lysp_sales_sql varchar2(30000) :=
5044: ' SELECT'||
5045: ' SUM(bsmv.sales) sales'||
5046: ' FROM'||
5047: ' ozf_order_sales_v bsmv,'||
5048: ' ams_party_market_segments a'||
5049: ' WHERE'||
5050: ' a.market_qualifier_reference = :l_territory_id '||
5051: ' AND a.market_qualifier_type=''TERRITORY'' '||

Line 5104: ozf_order_sales_v bsmv

5100: IS
5101: SELECT
5102: SUM(bsmv.sales) account_sales
5103: FROM
5104: ozf_order_sales_v bsmv
5105: WHERE
5106: bsmv.ship_to_site_use_id = l_site_use_id
5107: AND bsmv.time_id IN (l_in_clause);
5108:

Line 5115: ' ozf_order_sales_v bsmv'||

5111: l_account_total_sales_sql varchar2(30000) :=
5112: ' SELECT '||
5113: ' SUM(bsmv.sales) account_sales'||
5114: ' FROM '||
5115: ' ozf_order_sales_v bsmv'||
5116: ' WHERE '||
5117: ' bsmv.ship_to_site_use_id = :l_site_use_id'||
5118: ' AND bsmv.time_id IN (' ;
5119: --l_in_clause);

Line 5131: ozf_order_sales_v bsmv

5127: IS
5128: SELECT
5129: SUM(bsmv.sales) account_sales
5130: FROM
5131: ozf_order_sales_v bsmv
5132: WHERE
5133: bsmv.ship_to_site_use_id = l_site_use_id
5134: AND bsmv.time_id = l_time_id;
5135:

Line 5173: ozf_order_sales_v bsmv,

5169: l_time_id NUMBER) IS
5170: SELECT
5171: SUM(bsmv.sales) sales
5172: FROM
5173: ozf_order_sales_v bsmv,
5174: ams_party_market_segments a
5175: WHERE
5176: a.market_qualifier_reference = l_territory_id
5177: AND a.market_qualifier_type='TERRITORY'

Line 5192: ozf_order_sales_v bsmv,

5188: l_fund_id NUMBER) IS
5189: SELECT
5190: SUM(bsmv.sales) sales
5191: FROM
5192: ozf_order_sales_v bsmv,
5193: ams_party_market_segments a
5194: WHERE
5195: a.market_qualifier_reference = l_territory_id
5196: AND a.market_qualifier_type='TERRITORY'

Line 5222: ozf_order_sales_v bsmv,

5218: l_fund_id NUMBER) IS
5219: SELECT
5220: SUM(bsmv.sales) sales
5221: FROM
5222: ozf_order_sales_v bsmv,
5223: ams_party_market_segments a
5224: WHERE
5225: a.market_qualifier_reference = l_territory_id
5226: AND a.market_qualifier_type='TERRITORY'

Line 6146: ozf_order_sales_v bsmv,

6142: IS
6143: SELECT
6144: SUM(bsmv.sales) sales
6145: FROM
6146: ozf_order_sales_v bsmv,
6147: ams_party_market_segments a
6148: WHERE
6149: a.market_qualifier_reference = l_territory_id
6150: AND a.market_qualifier_type='TERRITORY'

Line 6159: ' ozf_order_sales_v bsmv,'||

6155: l_total_lysp_sales_sql varchar2(30000) :=
6156: ' SELECT'||
6157: ' SUM(bsmv.sales) sales'||
6158: ' FROM'||
6159: ' ozf_order_sales_v bsmv,'||
6160: ' ams_party_market_segments a'||
6161: ' WHERE'||
6162: ' a.market_qualifier_reference = :l_territory_id '||
6163: ' AND a.market_qualifier_type=''TERRITORY'' '||

Line 6216: ozf_order_sales_v bsmv

6212: IS
6213: SELECT
6214: SUM(bsmv.sales) account_sales
6215: FROM
6216: ozf_order_sales_v bsmv
6217: WHERE
6218: bsmv.ship_to_site_use_id = l_site_use_id
6219: AND bsmv.time_id IN (l_in_clause);
6220:

Line 6227: ' ozf_order_sales_v bsmv'||

6223: l_account_total_sales_sql varchar2(30000) :=
6224: ' SELECT '||
6225: ' SUM(bsmv.sales) account_sales'||
6226: ' FROM '||
6227: ' ozf_order_sales_v bsmv'||
6228: ' WHERE '||
6229: ' bsmv.ship_to_site_use_id = :l_site_use_id'||
6230: ' AND bsmv.time_id IN (' ;
6231: --l_in_clause);

Line 6243: ozf_order_sales_v bsmv

6239: IS
6240: SELECT
6241: SUM(bsmv.sales) account_sales
6242: FROM
6243: ozf_order_sales_v bsmv
6244: WHERE
6245: bsmv.ship_to_site_use_id = l_site_use_id
6246: AND bsmv.time_id = l_time_id;
6247:

Line 6285: ozf_order_sales_v bsmv,

6281: l_time_id NUMBER) IS
6282: SELECT
6283: SUM(bsmv.sales) sales
6284: FROM
6285: ozf_order_sales_v bsmv,
6286: ams_party_market_segments a
6287: WHERE
6288: a.market_qualifier_reference = l_territory_id
6289: AND a.market_qualifier_type='TERRITORY'

Line 6304: ozf_order_sales_v bsmv,

6300: l_fund_id NUMBER) IS
6301: SELECT
6302: SUM(bsmv.sales) sales
6303: FROM
6304: ozf_order_sales_v bsmv,
6305: ams_party_market_segments a
6306: WHERE
6307: a.market_qualifier_reference = l_territory_id
6308: AND a.market_qualifier_type='TERRITORY'

Line 6334: ozf_order_sales_v bsmv,

6330: l_fund_id NUMBER) IS
6331: SELECT
6332: SUM(bsmv.sales) sales
6333: FROM
6334: ozf_order_sales_v bsmv,
6335: ams_party_market_segments a
6336: WHERE
6337: a.market_qualifier_reference = l_territory_id
6338: AND a.market_qualifier_type='TERRITORY'

Line 7823: ozf_order_sales_v bsmv,

7819: IS
7820: SELECT
7821: SUM(bsmv.sales) sales
7822: FROM
7823: ozf_order_sales_v bsmv,
7824: ozf_account_allocations a
7825: WHERE
7826: a.allocation_for = 'FUND'
7827: AND a.allocation_for_id = l_fund_id

Line 7859: ozf_order_sales_v bsmv

7855: IS
7856: SELECT
7857: SUM(bsmv.sales) account_sales
7858: FROM
7859: ozf_order_sales_v bsmv
7860: WHERE
7861: bsmv.ship_to_site_use_id = l_site_use_id
7862: AND bsmv.time_id IN (l_in_clause);
7863:

Line 7872: ozf_order_sales_v bsmv

7868: IS
7869: SELECT
7870: SUM(bsmv.sales) account_sales
7871: FROM
7872: ozf_order_sales_v bsmv
7873: WHERE
7874: bsmv.ship_to_site_use_id = l_site_use_id
7875: AND bsmv.time_id = l_time_id;
7876:

Line 7914: ozf_order_sales_v bsmv,

7910: l_time_id NUMBER) IS
7911: SELECT
7912: SUM(bsmv.sales) sales
7913: FROM
7914: ozf_order_sales_v bsmv,
7915: ams_party_market_segments a
7916: WHERE
7917: a.market_qualifier_reference = l_territory_id
7918: AND a.market_qualifier_type='TERRITORY'

Line 7933: ozf_order_sales_v bsmv,

7929: l_fund_id NUMBER) IS
7930: SELECT
7931: SUM(bsmv.sales) sales
7932: FROM
7933: ozf_order_sales_v bsmv,
7934: ams_party_market_segments a
7935: WHERE
7936: a.market_qualifier_reference = l_territory_id
7937: AND a.market_qualifier_type='TERRITORY'

Line 7960: ozf_order_sales_v bsmv,

7956: l_fund_id NUMBER) IS
7957: SELECT
7958: SUM(bsmv.sales) sales
7959: FROM
7960: ozf_order_sales_v bsmv,
7961: ams_party_market_segments a
7962: WHERE
7963: a.market_qualifier_reference = l_territory_id
7964: AND a.market_qualifier_type='TERRITORY'

Line 9415: ozf_order_sales_v bsmv,

9411: l_time_id NUMBER) IS
9412: SELECT
9413: SUM(bsmv.sales) sales
9414: FROM
9415: ozf_order_sales_v bsmv,
9416: ams_party_market_segments a
9417: WHERE
9418: a.market_qualifier_reference = l_territory_id
9419: AND a.market_qualifier_type='TERRITORY'

Line 9434: ozf_order_sales_v bsmv,

9430: l_fund_id NUMBER) IS
9431: SELECT
9432: SUM(bsmv.sales) sales
9433: FROM
9434: ozf_order_sales_v bsmv,
9435: ams_party_market_segments a
9436: WHERE
9437: a.market_qualifier_reference = l_territory_id
9438: AND a.market_qualifier_type='TERRITORY'

Line 9464: ozf_order_sales_v bsmv,

9460: l_fund_id NUMBER) IS
9461: SELECT
9462: SUM(bsmv.sales) sales
9463: FROM
9464: ozf_order_sales_v bsmv,
9465: ams_party_market_segments a
9466: WHERE
9467: a.market_qualifier_reference = l_territory_id
9468: AND a.market_qualifier_type='TERRITORY'

Line 9894: FROM ozf_order_sales_v bsmv

9890: update ozf_time_allocations tt
9891: set tt.target = 0,
9892: tt.lysp_sales = (
9893: SELECT SUM(bsmv.sales)
9894: FROM ozf_order_sales_v bsmv
9895: WHERE bsmv.ship_to_site_use_id = p_ship_to_site_use_id
9896: AND bsmv.time_id = OZF_TIME_API_PVT.get_lysp_id(tt.time_id, tt.period_type_id)
9897: )
9898: WHERE tt.allocation_for = 'CUST'