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 HZ_PARTIES

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 1424: FROM oe_invoice_to_orgs_v oito,hz_cust_accounts cust_acct,hz_parties party

1420: WHERE customer_id = p_segment_id;
1421:
1422: CURSOR c_segment_billto (p_segment_id IN NUMBER) IS
1423: SELECT 1
1424: FROM oe_invoice_to_orgs_v oito,hz_cust_accounts cust_acct,hz_parties party
1425: WHERE cust_acct.party_id = party.party_id
1426: AND oito.customer_id = cust_acct.cust_account_id
1427: AND oito.organization_id = p_segment_id;
1428: