[Home] [Help]
148: last_update_date = arp_global.last_update_date,
149: last_updated_by = arp_global.last_updated_by,
150: last_update_login = arp_global.last_update_login
151: WHERE customer_id in (select cust_account_id
152: from hz_cust_accounts c
153: where c.account_number
154: between nvl(P_cust_num_low, c.account_number)
155: and nvl(P_cust_num_high, c.account_number))
156: AND site_use_id between nvl(P_bill_site_low, site_use_id) and
254: last_update_date = arp_global.last_update_date,
255: last_updated_by = arp_global.last_updated_by,
256: last_update_login = arp_global.last_update_login
257: WHERE customer_id in (select cust_account_id
258: from hz_cust_accounts c
259: where c.account_number
260: between nvl(P_cust_num_low, c.account_number)
261: and nvl(P_cust_num_high, c.account_number))
262: AND site_use_id between nvl(P_bill_site_low, site_use_id) and
610: nvl(cp1.cons_bill_level, cp2.cons_bill_level) site_bill_level,
611: cp2.cons_bill_level acct_bill_level,
612: nvl(cp1.standard_terms, cp2.standard_terms) site_term,
613: cp2.standard_terms acct_term
614: FROM hz_cust_accounts acct,
615: hz_cust_acct_sites acct_site,
616: hz_cust_site_uses site_uses,
617: hz_customer_profiles cp1,
618: hz_customer_profiles cp2
976: ' AND CI2.status = ''DRAFT'') ';
977:
978: -- add on tables/conditions depending on parameters passed in
979: IF l_cust_name_low is not null THEN
980: c_site_from := c_site_from || ', hz_parties party, hz_cust_accounts acct ';
981:
982: c_site_where := c_site_where ||
983: 'AND party.party_name between :cust_name_low and :cust_name_high ' ||
984: 'AND party.party_id = acct.party_id ' ||
989: 'AND acct.account_number between :cust_num_low and :cust_num_high ';
990: END IF;
991:
992: ELSIF l_cust_num_low is not null THEN
993: c_site_from := c_site_from || ' ,hz_cust_accounts acct ';
994:
995: c_site_where := c_site_where ||
996: 'AND acct.account_number between :cust_num_low and :cust_num_high ' ||
997: 'AND acct.cust_account_id = acct_site.cust_account_id ';
1201:
1202: /* get party_id */
1203: select p.party_id
1204: into l_party_id
1205: from hz_parties p, hz_cust_accounts c
1206: where c.cust_account_id = L_sites.customer_id
1207: and c.party_id = p.party_id;
1208:
1209: