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 1405: FROM ams_party_market_segments ams, hz_parties hz

1401: AND lookup_code = p_segment;
1402:
1403: CURSOR c_segment_buyer (p_segment_id IN NUMBER) IS
1404: SELECT 1
1405: FROM ams_party_market_segments ams, hz_parties hz
1406: WHERE ams.market_qualifier_type = 'BG'
1407: AND ams.market_qualifier_reference = hz.party_id
1408: AND ams.market_qualifier_reference = ams.party_id
1409: AND EXISTS

Line 1411: FROM ams_party_market_segments

1407: AND ams.market_qualifier_reference = hz.party_id
1408: AND ams.market_qualifier_reference = ams.party_id
1409: AND EXISTS
1410: ( SELECT 1
1411: FROM ams_party_market_segments
1412: WHERE market_qualifier_type = 'BG'
1413: AND market_qualifier_reference = ams.market_qualifier_reference
1414: AND market_qualifier_reference <> party_id)
1415: AND hz.party_id = p_segment_id;