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

Line 1435: FROM ams_party_market_segments ams, hz_parties hz

1431: AND lookup_code = p_segment;
1432:
1433: CURSOR c_segment_buyer (p_segment_id IN NUMBER) IS
1434: SELECT 1
1435: FROM ams_party_market_segments ams, hz_parties hz
1436: WHERE ams.market_qualifier_type = 'BG'
1437: AND ams.market_qualifier_reference = hz.party_id
1438: AND ams.market_qualifier_reference = ams.party_id
1439: AND EXISTS

Line 1441: FROM ams_party_market_segments

1437: AND ams.market_qualifier_reference = hz.party_id
1438: AND ams.market_qualifier_reference = ams.party_id
1439: AND EXISTS
1440: ( SELECT 1
1441: FROM ams_party_market_segments
1442: WHERE market_qualifier_type = 'BG'
1443: AND market_qualifier_reference = ams.market_qualifier_reference
1444: AND market_qualifier_reference <> party_id)
1445: AND hz.party_id = p_segment_id;