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.ARP_BF_BILL dependencies on HZ_PARTIES

Line 962: c_site_from := c_site_from || ', hz_parties party, hz_cust_accounts acct ';

958: ' AND CI2.status = ''DRAFT'') ';
959:
960: -- add on tables/conditions depending on parameters passed in
961: IF l_cust_name_low is not null THEN
962: c_site_from := c_site_from || ', hz_parties party, hz_cust_accounts acct ';
963:
964: c_site_where := c_site_where ||
965: 'AND party.party_name between :cust_name_low and :cust_name_high ' ||
966: 'AND party.party_id = acct.party_id ' ||

Line 1187: from hz_parties p, hz_cust_accounts c

1183:
1184: /* get party_id */
1185: select p.party_id
1186: into l_party_id
1187: from hz_parties p, hz_cust_accounts c
1188: where c.cust_account_id = L_sites.customer_id
1189: and c.party_id = p.party_id;
1190:
1191: