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_FUND_ALLOCATIONS_PVT dependencies on AMS_PARTY_MARKET_SEGMENTS

Line 316: FROM ams_party_market_segments

312:
313: CURSOR c_get_terr_self_accts (p_node_id IN NUMBER)
314: IS
315: SELECT DISTINCT cust_account_id
316: FROM ams_party_market_segments
317: WHERE market_qualifier_type = 'TERRITORY'
318: AND market_qualifier_reference = p_node_id;
319:
320: CURSOR c_get_terr_rollup_accts (p_node_id IN NUMBER)

Line 323: FROM ams_party_market_segments pms,

319:
320: CURSOR c_get_terr_rollup_accts (p_node_id IN NUMBER)
321: IS
322: SELECT DISTINCT pms.cust_account_id
323: FROM ams_party_market_segments pms,
324: ozf_terr_v terr
325: WHERE pms.market_qualifier_type = 'TERRITORY'
326: AND pms.market_qualifier_reference = terr.node_id
327: AND terr.parent_id = ( SELECT terr1.parent_id