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 279: ams_party_market_segments a

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

Line 297: ams_party_market_segments a

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

Line 329: ams_party_market_segments a

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

Line 358: ams_party_market_segments a

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

Line 410: ams_party_market_segments a

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

Line 978: ams_party_market_segments a

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

Line 995: ams_party_market_segments a

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

Line 1023: ams_party_market_segments a

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

Line 1687: ams_party_market_segments a

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

Line 1704: ams_party_market_segments a

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

Line 1732: ams_party_market_segments a

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

Line 2500: ams_party_market_segments a

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

Line 2517: ams_party_market_segments a

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

Line 2547: ams_party_market_segments a

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

Line 4106: ams_party_market_segments a

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

Line 4123: ams_party_market_segments a

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

Line 4546: ams_party_market_segments a

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

Line 4563: ams_party_market_segments a

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

Line 5008: ams_party_market_segments a

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

Line 5021: ' ams_party_market_segments a'||

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

Line 5044: ams_party_market_segments a

5040: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
5041: a.party_id parent_party_id,
5042: NVL(a.rollup_party_id, a.party_id) rollup_party_id
5043: FROM
5044: ams_party_market_segments a
5045: WHERE
5046: a.market_qualifier_reference = l_territory_id
5047: AND a.market_qualifier_type='TERRITORY'
5048: AND a.site_use_code = 'SHIP_TO'

Line 5063: ams_party_market_segments a

5059: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
5060: a.party_id parent_party_id,
5061: a.rollup_party_id rollup_party_id
5062: FROM
5063: ams_party_market_segments a
5064: WHERE
5065: a.market_qualifier_reference = l_territory_id
5066: AND a.market_qualifier_type='TERRITORY';
5067: */

Line 5147: ams_party_market_segments a

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

Line 5166: ams_party_market_segments a

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

Line 5196: ams_party_market_segments a

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

Line 6118: ams_party_market_segments a

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

Line 6131: ' ams_party_market_segments a'||

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

Line 6154: ams_party_market_segments a

6150: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
6151: a.party_id parent_party_id,
6152: NVL(a.rollup_party_id, a.party_id) rollup_party_id
6153: FROM
6154: ams_party_market_segments a
6155: WHERE
6156: a.market_qualifier_reference = l_territory_id
6157: AND a.market_qualifier_type='TERRITORY'
6158: AND a.site_use_code = 'SHIP_TO'

Line 6173: ams_party_market_segments a

6169: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
6170: a.party_id parent_party_id,
6171: a.rollup_party_id rollup_party_id
6172: FROM
6173: ams_party_market_segments a
6174: WHERE
6175: a.market_qualifier_reference = l_territory_id
6176: AND a.market_qualifier_type='TERRITORY';
6177: */

Line 6257: ams_party_market_segments a

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

Line 6276: ams_party_market_segments a

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

Line 6306: ams_party_market_segments a

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

Line 7884: ams_party_market_segments a

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

Line 7903: ams_party_market_segments a

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

Line 7930: ams_party_market_segments a

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

Line 9383: ams_party_market_segments a

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

Line 9402: ams_party_market_segments a

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

Line 9432: ams_party_market_segments a

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

Line 9662: ams_party_market_segments a

9658: p_acct_alloc_rec.bill_to_location_id,
9659: p_acct_alloc_rec.parent_party_id,
9660: p_acct_alloc_rec.rollup_party_id
9661: FROM
9662: ams_party_market_segments a
9663: WHERE
9664: a.market_qualifier_reference = p_terr_id
9665: AND a.market_qualifier_type='TERRITORY'
9666: AND a.site_use_code = 'SHIP_TO'

Line 10645: ams_party_market_segments a

10641: ---OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
10642: ---a.party_id parent_party_id,
10643: ---NVL(a.rollup_party_id, a.party_id) rollup_party_id
10644: FROM
10645: ams_party_market_segments a
10646: WHERE
10647: a.market_qualifier_reference = l_territory_id
10648: AND a.market_qualifier_type='TERRITORY'
10649: AND a.site_use_code = 'SHIP_TO'

Line 10709: ams_party_market_segments a

10705: ---OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
10706: ---a.party_id parent_party_id,
10707: ---NVL(a.rollup_party_id, a.party_id) rollup_party_id
10708: FROM
10709: ams_party_market_segments a
10710: WHERE
10711: a.market_qualifier_reference = l_territory_id
10712: AND a.market_qualifier_type='TERRITORY'
10713: AND a.site_use_code = 'SHIP_TO'

Line 10812: ams_party_market_segments a

10808: 'D' account_status_code,
10809: a.market_qualifier_reference territory_id,
10810: a.site_use_id site_use_id
10811: FROM
10812: ams_party_market_segments a
10813: WHERE
10814: a.market_qualifier_type='TERRITORY'
10815: AND a.site_use_code = 'SHIP_TO'
10816: AND a.party_id IS NOT NULL

Line 10969: ams_party_market_segments a

10965: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
10966: a.party_id parent_party_id,
10967: NVL(a.rollup_party_id, a.party_id) rollup_party_id
10968: FROM
10969: ams_party_market_segments a
10970: WHERE
10971: a.market_qualifier_reference = alloc.territory_id
10972: AND a.market_qualifier_reference = terr.node_id
10973: AND a.market_qualifier_type='TERRITORY'