[Home] [Help]
800: --** debug ends!!
801:
802: --* site_use_id -> site_id hz_party_site_uses
803: --* site_id -> location_id hz_party_sites_v or hz_party_sites
804: --* location has country code hz_locations, use CSDSERVC.pld as example
805: l_short_string_input := GET_COUNTRY_CODE(p_site_use_id => l_rule_input_rec.SR_BILL_TO_SITE_USE_ID); --get sr bill to country from l_rule_input_rec.SR_BILL_TO_SITE_USE_ID
806: l_return_val := CHECK_CONDITION_MATCH(p_input_param => l_short_string_input,
807: p_operator => p_operator,
808: p_criterion => p_criterion);
1337: ---- cursors ----
1338: CURSOR cur_get_country_code(p_site_use_id NUMBER) IS
1339: SELECT b.country
1340: FROM hz_party_sites a,
1341: hz_locations b,
1342: hz_party_site_uses c
1343: WHERE a.location_id = b.location_id
1344: AND a.party_site_id = c.party_site_id
1345: AND c.party_site_use_id = p_site_use_id
1965: when 'SR_CUSTOMER_ACCOUNT_ID' then
1966: l_join_stmt := 'csb.account_id ' || l_num_condition;
1967: when 'SR_BILL_TO_COUNTRY' then
1968: l_join_stmt := 'csb.bill_to_site_use_id in (select hpsu.party_site_use_id'
1969: || ' from hz_party_sites hps, hz_locations hl, hz_party_site_uses hpsu'
1970: || ' where hps.location_id = hl.location_id'
1971: || ' and hps.party_site_id = hpsu.party_site_id'
1972: || ' and hpsu.party_site_use_id = csb.bill_to_site_use_id'
1973: || ' and hl.country '
1973: || ' and hl.country '
1974: || l_str_condition || ')';
1975: when 'SR_SHIP_TO_COUNTRY' then
1976: l_join_stmt := 'csb.ship_to_site_use_id in (select hpsu.party_site_use_id'
1977: || ' from hz_party_sites hps, hz_locations hl, hz_party_site_uses hpsu'
1978: || ' where hps.location_id = hl.location_id'
1979: || ' and hps.party_site_id = hpsu.party_site_id'
1980: || ' and hpsu.party_site_use_id = csb.ship_to_site_use_id'
1981: || ' and hl.country '