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 AMS_PARTY_MARKET_SEGMENTS

Line 298: ams_party_market_segments a

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'
302: AND a.site_use_id = NVL(l_site_use_id, a.site_use_id)

Line 316: ams_party_market_segments a

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'
320: AND bsmv.ship_to_site_use_id = a.site_use_id

Line 348: ams_party_market_segments a

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'
352: AND a.site_use_id = l_site_use_id

Line 377: ams_party_market_segments a

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'
381: AND bsmv.ship_to_site_use_id = a.site_use_id

Line 429: ams_party_market_segments a

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'
433: AND a.site_use_id = l_site_use_id

Line 997: ams_party_market_segments a

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'
1001: AND a.site_use_id = bsmv.ship_to_site_use_id

Line 1014: ams_party_market_segments a

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'
1018: AND bsmv.ship_to_site_use_id = a.site_use_id

Line 1042: ams_party_market_segments a

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'
1046: AND bsmv.ship_to_site_use_id = a.site_use_id

Line 1708: ams_party_market_segments a

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'
1712: AND a.site_use_id = bsmv.ship_to_site_use_id

Line 1725: ams_party_market_segments a

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'
1729: AND bsmv.ship_to_site_use_id = a.site_use_id

Line 1753: ams_party_market_segments a

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'
1757: AND bsmv.ship_to_site_use_id = a.site_use_id

Line 2523: ams_party_market_segments a

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'
2527: AND bsmv.ship_to_site_use_id = a.site_use_id

Line 2540: ams_party_market_segments a

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'
2544: AND bsmv.ship_to_site_use_id = a.site_use_id

Line 2570: ams_party_market_segments a

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'
2574: AND bsmv.ship_to_site_use_id = a.site_use_id

Line 4131: ams_party_market_segments a

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'
4135: AND bsmv.ship_to_site_use_id = a.site_use_id

Line 4148: ams_party_market_segments a

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'
4152: AND bsmv.ship_to_site_use_id = a.site_use_id

Line 4573: ams_party_market_segments a

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'
4577: AND bsmv.ship_to_site_use_id = a.site_use_id

Line 4590: ams_party_market_segments a

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'
4594: AND bsmv.ship_to_site_use_id = a.site_use_id

Line 5035: ams_party_market_segments a

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'
5039: AND bsmv.ship_to_site_use_id = a.site_use_id

Line 5048: ' ams_party_market_segments a'||

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'' '||
5052: ' AND bsmv.ship_to_site_use_id = a.site_use_id'||

Line 5071: ams_party_market_segments a

5067: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
5068: a.party_id parent_party_id,
5069: NVL(a.rollup_party_id, a.party_id) rollup_party_id
5070: FROM
5071: ams_party_market_segments a
5072: WHERE
5073: a.market_qualifier_reference = l_territory_id
5074: AND a.market_qualifier_type='TERRITORY'
5075: AND a.site_use_code = 'SHIP_TO'

Line 5090: ams_party_market_segments a

5086: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
5087: a.party_id parent_party_id,
5088: a.rollup_party_id rollup_party_id
5089: FROM
5090: ams_party_market_segments a
5091: WHERE
5092: a.market_qualifier_reference = l_territory_id
5093: AND a.market_qualifier_type='TERRITORY';
5094: */

Line 5174: ams_party_market_segments a

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'
5178: AND a.site_use_id = l_site_use_id

Line 5193: ams_party_market_segments a

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'
5197: AND a.site_use_id = l_site_use_id

Line 5223: ams_party_market_segments a

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'
5227: AND a.site_use_id = l_site_use_id

Line 6147: ams_party_market_segments a

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'
6151: AND bsmv.ship_to_site_use_id = a.site_use_id

Line 6160: ' ams_party_market_segments a'||

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'' '||
6164: ' AND bsmv.ship_to_site_use_id = a.site_use_id'||

Line 6183: ams_party_market_segments a

6179: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
6180: a.party_id parent_party_id,
6181: NVL(a.rollup_party_id, a.party_id) rollup_party_id
6182: FROM
6183: ams_party_market_segments a
6184: WHERE
6185: a.market_qualifier_reference = l_territory_id
6186: AND a.market_qualifier_type='TERRITORY'
6187: AND a.site_use_code = 'SHIP_TO'

Line 6202: ams_party_market_segments a

6198: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
6199: a.party_id parent_party_id,
6200: a.rollup_party_id rollup_party_id
6201: FROM
6202: ams_party_market_segments a
6203: WHERE
6204: a.market_qualifier_reference = l_territory_id
6205: AND a.market_qualifier_type='TERRITORY';
6206: */

Line 6286: ams_party_market_segments a

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'
6290: AND a.site_use_id = l_site_use_id

Line 6305: ams_party_market_segments a

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'
6309: AND a.site_use_id = l_site_use_id

Line 6335: ams_party_market_segments a

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'
6339: AND a.site_use_id = l_site_use_id

Line 7915: ams_party_market_segments a

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'
7919: AND a.site_use_id = l_site_use_id

Line 7934: ams_party_market_segments a

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'
7938: AND a.site_use_id = l_site_use_id

Line 7961: ams_party_market_segments a

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'
7965: AND a.site_use_id = l_site_use_id

Line 9416: ams_party_market_segments a

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'
9420: AND a.site_use_id = l_site_use_id

Line 9435: ams_party_market_segments a

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'
9439: AND a.site_use_id = l_site_use_id

Line 9465: ams_party_market_segments a

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'
9469: AND a.site_use_id = l_site_use_id

Line 9697: ams_party_market_segments a

9693: p_acct_alloc_rec.bill_to_location_id,
9694: p_acct_alloc_rec.parent_party_id,
9695: p_acct_alloc_rec.rollup_party_id
9696: FROM
9697: ams_party_market_segments a
9698: WHERE
9699: a.market_qualifier_reference = p_terr_id
9700: AND a.market_qualifier_type='TERRITORY'
9701: AND a.site_use_code = 'SHIP_TO'

Line 10680: ams_party_market_segments a

10676: ---OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
10677: ---a.party_id parent_party_id,
10678: ---NVL(a.rollup_party_id, a.party_id) rollup_party_id
10679: FROM
10680: ams_party_market_segments a
10681: WHERE
10682: a.market_qualifier_reference = l_territory_id
10683: AND a.market_qualifier_type='TERRITORY'
10684: AND a.site_use_code = 'SHIP_TO'

Line 10744: ams_party_market_segments a

10740: ---OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
10741: ---a.party_id parent_party_id,
10742: ---NVL(a.rollup_party_id, a.party_id) rollup_party_id
10743: FROM
10744: ams_party_market_segments a
10745: WHERE
10746: a.market_qualifier_reference = l_territory_id
10747: AND a.market_qualifier_type='TERRITORY'
10748: AND a.site_use_code = 'SHIP_TO'

Line 10847: ams_party_market_segments a

10843: 'D' account_status_code,
10844: a.market_qualifier_reference territory_id,
10845: a.site_use_id site_use_id
10846: FROM
10847: ams_party_market_segments a
10848: WHERE
10849: a.market_qualifier_type='TERRITORY'
10850: AND a.site_use_code = 'SHIP_TO'
10851: AND a.party_id IS NOT NULL

Line 11004: ams_party_market_segments a

11000: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
11001: a.party_id parent_party_id,
11002: NVL(a.rollup_party_id, a.party_id) rollup_party_id
11003: FROM
11004: ams_party_market_segments a
11005: WHERE
11006: a.market_qualifier_reference = alloc.territory_id
11007: AND a.market_qualifier_reference = terr.node_id
11008: AND a.market_qualifier_type='TERRITORY'