[Home] [Help]
489: l_query_string := 'SELECT anstable.'||p_answer_column|| ' from '|| p_answer_table||' anstable, hz_cust_accounts hca WHERE rownum = 1 and hca.'||p_hz_join_column||' = anstable.'||p_answer_join_column||
490: ' and hca.cust_account_id = '||p_customer_id;
491: elsif ( p_customer_site_use_id is not null ) then
492:
493: l_query_string := 'SELECT anstable.'||p_answer_column|| ' from '|| p_answer_table||' anstable,hz_party_sites hps, hz_cust_acct_sites_all hcas, hz_cust_site_uses_all hcsu where hcsu.site_use_id =' || p_customer_site_use_id ||
494: ' and hcsu.cust_acct_site_id = hcas.cust_acct_site_id and hcas.party_site_id = hps.party_site_id and hps.'||p_hz_join_column||' = anstable.'||p_answer_join_column;
495:
496: else
497:
501:
502: SELECT site_use_id into l_site_use_id FROM
503: ( SELECT site_uses.site_use_id FROM
504: fnd_territories_vl Terr,
505: hz_cust_acct_sites acct_sites,
506: hz_party_sites party_sites,
507: hz_locations loc,
508: hz_cust_accounts Cust,
509: hz_parties Party,
520: where rownum=1;
521:
522: arp_standard.debug('oldest bill to site id :: '||l_site_use_id);
523:
524: l_query_string :='SELECT anstable.'||p_answer_column|| ' from '|| p_answer_table||' anstable,hz_party_sites hps, hz_cust_acct_sites_all hcas, hz_cust_site_uses_all hcsu where hcsu.site_use_id =' || l_site_use_id ||
525: ' and hcsu.cust_acct_site_id = hcas.cust_acct_site_id and hcas.party_site_id = hps.party_site_id and hps.'||p_hz_join_column||' = anstable.'||p_answer_join_column;
526:
527: end if;
528: