[Home] [Help]
138: last_update_date = arp_global.last_update_date,
139: last_updated_by = arp_global.last_updated_by,
140: last_update_login = arp_global.last_update_login
141: WHERE customer_id in (select cust_account_id
142: from hz_cust_accounts c
143: where c.account_number
144: between nvl(P_cust_num_low, c.account_number)
145: and nvl(P_cust_num_high, c.account_number))
146: AND site_use_id between nvl(P_bill_site_low, site_use_id) and
233: last_update_date = arp_global.last_update_date,
234: last_updated_by = arp_global.last_updated_by,
235: last_update_login = arp_global.last_update_login
236: WHERE customer_id in (select cust_account_id
237: from hz_cust_accounts c
238: where c.account_number
239: between nvl(P_cust_num_low, c.account_number)
240: and nvl(P_cust_num_high, c.account_number))
241: AND site_use_id between nvl(P_bill_site_low, site_use_id) and
591: nvl(cp1.cons_bill_level, cp2.cons_bill_level) site_bill_level,
592: cp2.cons_bill_level acct_bill_level,
593: nvl(cp1.standard_terms, cp2.standard_terms) site_term,
594: cp2.standard_terms acct_term
595: FROM hz_cust_accounts acct,
596: hz_cust_acct_sites acct_site,
597: hz_cust_site_uses site_uses,
598: hz_customer_profiles cp1,
599: hz_customer_profiles cp2
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 ' ||
971: 'AND acct.account_number between :cust_num_low and :cust_num_high ';
972: END IF;
973:
974: ELSIF l_cust_num_low is not null THEN
975: c_site_from := c_site_from || ' ,hz_cust_accounts acct ';
976:
977: c_site_where := c_site_where ||
978: 'AND acct.account_number between :cust_num_low and :cust_num_high ' ||
979: 'AND acct.cust_account_id = acct_site.cust_account_id ';
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: