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 278: ozf_order_sales_v bsmv,

274: l_time_id NUMBER) IS
275: SELECT
276: SUM(bsmv.sales) sales
277: FROM
278: ozf_order_sales_v bsmv,
279: ams_party_market_segments a
280: WHERE
281: a.market_qualifier_reference = l_territory_id
282: AND a.market_qualifier_type='TERRITORY'

Line 296: ozf_order_sales_v bsmv,

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

Line 328: ozf_order_sales_v bsmv,

324: l_fund_id NUMBER) IS
325: SELECT
326: SUM(bsmv.sales) sales
327: FROM
328: ozf_order_sales_v bsmv,
329: ams_party_market_segments a
330: WHERE
331: a.market_qualifier_reference = l_territory_id
332: AND a.market_qualifier_type='TERRITORY'

Line 357: ozf_order_sales_v bsmv,

353: l_fund_id NUMBER) IS
354: SELECT
355: SUM(bsmv.sales) sales
356: FROM
357: ozf_order_sales_v bsmv,
358: ams_party_market_segments a
359: WHERE
360: a.market_qualifier_reference = l_territory_id
361: AND a.market_qualifier_type='TERRITORY'

Line 409: ozf_order_sales_v bsmv,

405: l_fund_id NUMBER) IS
406: SELECT
407: SUM(bsmv.sales) sales
408: FROM
409: ozf_order_sales_v bsmv,
410: ams_party_market_segments a
411: WHERE
412: a.market_qualifier_reference = l_territory_id
413: AND a.market_qualifier_type='TERRITORY'

Line 977: ozf_order_sales_v bsmv,

973: l_time_id NUMBER) IS
974: SELECT
975: SUM(bsmv.sales) sales
976: FROM
977: ozf_order_sales_v bsmv,
978: ams_party_market_segments a
979: WHERE
980: a.market_qualifier_reference = l_territory_id
981: AND a.market_qualifier_type='TERRITORY'

Line 994: ozf_order_sales_v bsmv,

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

Line 1022: ozf_order_sales_v bsmv,

1018: l_fund_id NUMBER) IS
1019: SELECT
1020: SUM(bsmv.sales) sales
1021: FROM
1022: ozf_order_sales_v bsmv,
1023: ams_party_market_segments a
1024: WHERE
1025: a.market_qualifier_reference = l_territory_id
1026: AND a.market_qualifier_type='TERRITORY'

Line 1686: ozf_order_sales_v bsmv,

1682: l_time_id NUMBER) IS
1683: SELECT
1684: SUM(bsmv.sales) sales
1685: FROM
1686: ozf_order_sales_v bsmv,
1687: ams_party_market_segments a
1688: WHERE
1689: a.market_qualifier_reference = l_territory_id
1690: AND a.market_qualifier_type='TERRITORY'

Line 1703: ozf_order_sales_v bsmv,

1699: l_fund_id NUMBER) IS
1700: SELECT
1701: SUM(bsmv.sales) sales
1702: FROM
1703: ozf_order_sales_v bsmv,
1704: ams_party_market_segments a
1705: WHERE
1706: a.market_qualifier_reference = l_territory_id
1707: AND a.market_qualifier_type='TERRITORY'

Line 1731: ozf_order_sales_v bsmv,

1727: l_fund_id NUMBER) IS
1728: SELECT
1729: SUM(bsmv.sales) sales
1730: FROM
1731: ozf_order_sales_v bsmv,
1732: ams_party_market_segments a
1733: WHERE
1734: a.market_qualifier_reference = l_territory_id
1735: AND a.market_qualifier_type='TERRITORY'

Line 2499: ozf_order_sales_v bsmv,

2495: l_time_id NUMBER) IS
2496: SELECT
2497: SUM(bsmv.sales) sales
2498: FROM
2499: ozf_order_sales_v bsmv,
2500: ams_party_market_segments a
2501: WHERE
2502: a.market_qualifier_reference = l_territory_id
2503: AND a.market_qualifier_type='TERRITORY'

Line 2516: ozf_order_sales_v bsmv,

2512: l_fund_id NUMBER) IS
2513: SELECT
2514: SUM(bsmv.sales) sales
2515: FROM
2516: ozf_order_sales_v bsmv,
2517: ams_party_market_segments a
2518: WHERE
2519: a.market_qualifier_reference = l_territory_id
2520: AND a.market_qualifier_type='TERRITORY'

Line 2546: ozf_order_sales_v bsmv,

2542: l_fund_id NUMBER) IS
2543: SELECT
2544: SUM(bsmv.sales) sales
2545: FROM
2546: ozf_order_sales_v bsmv,
2547: ams_party_market_segments a
2548: WHERE
2549: a.market_qualifier_reference = l_territory_id
2550: AND a.market_qualifier_type='TERRITORY'

Line 4105: ozf_order_sales_v bsmv,

4101: l_time_id NUMBER) IS
4102: SELECT
4103: SUM(bsmv.sales) sales
4104: FROM
4105: ozf_order_sales_v bsmv,
4106: ams_party_market_segments a
4107: WHERE
4108: a.market_qualifier_reference = l_territory_id
4109: AND a.market_qualifier_type='TERRITORY'

Line 4122: ozf_order_sales_v bsmv,

4118: l_fund_id NUMBER) IS
4119: SELECT
4120: SUM(bsmv.sales) sales
4121: FROM
4122: ozf_order_sales_v bsmv,
4123: ams_party_market_segments a
4124: WHERE
4125: a.market_qualifier_reference = l_territory_id
4126: AND a.market_qualifier_type='TERRITORY'

Line 4545: ozf_order_sales_v bsmv,

4541: l_time_id NUMBER) IS
4542: SELECT
4543: SUM(bsmv.sales) sales
4544: FROM
4545: ozf_order_sales_v bsmv,
4546: ams_party_market_segments a
4547: WHERE
4548: a.market_qualifier_reference = l_territory_id
4549: AND a.market_qualifier_type='TERRITORY'

Line 4562: ozf_order_sales_v bsmv,

4558: l_fund_id NUMBER) IS
4559: SELECT
4560: SUM(bsmv.sales) sales
4561: FROM
4562: ozf_order_sales_v bsmv,
4563: ams_party_market_segments a
4564: WHERE
4565: a.market_qualifier_reference = l_territory_id
4566: AND a.market_qualifier_type='TERRITORY'

Line 5007: ozf_order_sales_v bsmv,

5003: IS
5004: SELECT
5005: SUM(bsmv.sales) sales
5006: FROM
5007: ozf_order_sales_v bsmv,
5008: ams_party_market_segments a
5009: WHERE
5010: a.market_qualifier_reference = l_territory_id
5011: AND a.market_qualifier_type='TERRITORY'

Line 5020: ' ozf_order_sales_v bsmv,'||

5016: l_total_lysp_sales_sql varchar2(30000) :=
5017: ' SELECT'||
5018: ' SUM(bsmv.sales) sales'||
5019: ' FROM'||
5020: ' ozf_order_sales_v bsmv,'||
5021: ' ams_party_market_segments a'||
5022: ' WHERE'||
5023: ' a.market_qualifier_reference = :l_territory_id '||
5024: ' AND a.market_qualifier_type=''TERRITORY'' '||

Line 5077: ozf_order_sales_v bsmv

5073: IS
5074: SELECT
5075: SUM(bsmv.sales) account_sales
5076: FROM
5077: ozf_order_sales_v bsmv
5078: WHERE
5079: bsmv.ship_to_site_use_id = l_site_use_id
5080: AND bsmv.time_id IN (l_in_clause);
5081:

Line 5088: ' ozf_order_sales_v bsmv'||

5084: l_account_total_sales_sql varchar2(30000) :=
5085: ' SELECT '||
5086: ' SUM(bsmv.sales) account_sales'||
5087: ' FROM '||
5088: ' ozf_order_sales_v bsmv'||
5089: ' WHERE '||
5090: ' bsmv.ship_to_site_use_id = :l_site_use_id'||
5091: ' AND bsmv.time_id IN (' ;
5092: --l_in_clause);

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 = l_time_id;
5108:

Line 5146: ozf_order_sales_v bsmv,

5142: l_time_id NUMBER) IS
5143: SELECT
5144: SUM(bsmv.sales) sales
5145: FROM
5146: ozf_order_sales_v bsmv,
5147: ams_party_market_segments a
5148: WHERE
5149: a.market_qualifier_reference = l_territory_id
5150: AND a.market_qualifier_type='TERRITORY'

Line 5165: ozf_order_sales_v bsmv,

5161: l_fund_id NUMBER) IS
5162: SELECT
5163: SUM(bsmv.sales) sales
5164: FROM
5165: ozf_order_sales_v bsmv,
5166: ams_party_market_segments a
5167: WHERE
5168: a.market_qualifier_reference = l_territory_id
5169: AND a.market_qualifier_type='TERRITORY'

Line 5195: ozf_order_sales_v bsmv,

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

Line 6117: ozf_order_sales_v bsmv,

6113: IS
6114: SELECT
6115: SUM(bsmv.sales) sales
6116: FROM
6117: ozf_order_sales_v bsmv,
6118: ams_party_market_segments a
6119: WHERE
6120: a.market_qualifier_reference = l_territory_id
6121: AND a.market_qualifier_type='TERRITORY'

Line 6130: ' ozf_order_sales_v bsmv,'||

6126: l_total_lysp_sales_sql varchar2(30000) :=
6127: ' SELECT'||
6128: ' SUM(bsmv.sales) sales'||
6129: ' FROM'||
6130: ' ozf_order_sales_v bsmv,'||
6131: ' ams_party_market_segments a'||
6132: ' WHERE'||
6133: ' a.market_qualifier_reference = :l_territory_id '||
6134: ' AND a.market_qualifier_type=''TERRITORY'' '||

Line 6187: ozf_order_sales_v bsmv

6183: IS
6184: SELECT
6185: SUM(bsmv.sales) account_sales
6186: FROM
6187: ozf_order_sales_v bsmv
6188: WHERE
6189: bsmv.ship_to_site_use_id = l_site_use_id
6190: AND bsmv.time_id IN (l_in_clause);
6191:

Line 6198: ' ozf_order_sales_v bsmv'||

6194: l_account_total_sales_sql varchar2(30000) :=
6195: ' SELECT '||
6196: ' SUM(bsmv.sales) account_sales'||
6197: ' FROM '||
6198: ' ozf_order_sales_v bsmv'||
6199: ' WHERE '||
6200: ' bsmv.ship_to_site_use_id = :l_site_use_id'||
6201: ' AND bsmv.time_id IN (' ;
6202: --l_in_clause);

Line 6214: ozf_order_sales_v bsmv

6210: IS
6211: SELECT
6212: SUM(bsmv.sales) account_sales
6213: FROM
6214: ozf_order_sales_v bsmv
6215: WHERE
6216: bsmv.ship_to_site_use_id = l_site_use_id
6217: AND bsmv.time_id = l_time_id;
6218:

Line 6256: ozf_order_sales_v bsmv,

6252: l_time_id NUMBER) IS
6253: SELECT
6254: SUM(bsmv.sales) sales
6255: FROM
6256: ozf_order_sales_v bsmv,
6257: ams_party_market_segments a
6258: WHERE
6259: a.market_qualifier_reference = l_territory_id
6260: AND a.market_qualifier_type='TERRITORY'

Line 6275: ozf_order_sales_v bsmv,

6271: l_fund_id NUMBER) IS
6272: SELECT
6273: SUM(bsmv.sales) sales
6274: FROM
6275: ozf_order_sales_v bsmv,
6276: ams_party_market_segments a
6277: WHERE
6278: a.market_qualifier_reference = l_territory_id
6279: AND a.market_qualifier_type='TERRITORY'

Line 6305: ozf_order_sales_v bsmv,

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

Line 7792: ozf_order_sales_v bsmv,

7788: IS
7789: SELECT
7790: SUM(bsmv.sales) sales
7791: FROM
7792: ozf_order_sales_v bsmv,
7793: ozf_account_allocations a
7794: WHERE
7795: a.allocation_for = 'FUND'
7796: AND a.allocation_for_id = l_fund_id

Line 7828: ozf_order_sales_v bsmv

7824: IS
7825: SELECT
7826: SUM(bsmv.sales) account_sales
7827: FROM
7828: ozf_order_sales_v bsmv
7829: WHERE
7830: bsmv.ship_to_site_use_id = l_site_use_id
7831: AND bsmv.time_id IN (l_in_clause);
7832:

Line 7841: ozf_order_sales_v bsmv

7837: IS
7838: SELECT
7839: SUM(bsmv.sales) account_sales
7840: FROM
7841: ozf_order_sales_v bsmv
7842: WHERE
7843: bsmv.ship_to_site_use_id = l_site_use_id
7844: AND bsmv.time_id = l_time_id;
7845:

Line 7883: ozf_order_sales_v bsmv,

7879: l_time_id NUMBER) IS
7880: SELECT
7881: SUM(bsmv.sales) sales
7882: FROM
7883: ozf_order_sales_v bsmv,
7884: ams_party_market_segments a
7885: WHERE
7886: a.market_qualifier_reference = l_territory_id
7887: AND a.market_qualifier_type='TERRITORY'

Line 7902: ozf_order_sales_v bsmv,

7898: l_fund_id NUMBER) IS
7899: SELECT
7900: SUM(bsmv.sales) sales
7901: FROM
7902: ozf_order_sales_v bsmv,
7903: ams_party_market_segments a
7904: WHERE
7905: a.market_qualifier_reference = l_territory_id
7906: AND a.market_qualifier_type='TERRITORY'

Line 7929: ozf_order_sales_v bsmv,

7925: l_fund_id NUMBER) IS
7926: SELECT
7927: SUM(bsmv.sales) sales
7928: FROM
7929: ozf_order_sales_v bsmv,
7930: ams_party_market_segments a
7931: WHERE
7932: a.market_qualifier_reference = l_territory_id
7933: AND a.market_qualifier_type='TERRITORY'

Line 9382: ozf_order_sales_v bsmv,

9378: l_time_id NUMBER) IS
9379: SELECT
9380: SUM(bsmv.sales) sales
9381: FROM
9382: ozf_order_sales_v bsmv,
9383: ams_party_market_segments a
9384: WHERE
9385: a.market_qualifier_reference = l_territory_id
9386: AND a.market_qualifier_type='TERRITORY'

Line 9401: ozf_order_sales_v bsmv,

9397: l_fund_id NUMBER) IS
9398: SELECT
9399: SUM(bsmv.sales) sales
9400: FROM
9401: ozf_order_sales_v bsmv,
9402: ams_party_market_segments a
9403: WHERE
9404: a.market_qualifier_reference = l_territory_id
9405: AND a.market_qualifier_type='TERRITORY'

Line 9431: ozf_order_sales_v bsmv,

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

Line 9859: FROM ozf_order_sales_v bsmv

9855: update ozf_time_allocations tt
9856: set tt.target = 0,
9857: tt.lysp_sales = (
9858: SELECT SUM(bsmv.sales)
9859: FROM ozf_order_sales_v bsmv
9860: WHERE bsmv.ship_to_site_use_id = p_ship_to_site_use_id
9861: AND bsmv.time_id = OZF_TIME_API_PVT.get_lysp_id(tt.time_id, tt.period_type_id)
9862: )
9863: WHERE tt.allocation_for = 'CUST'