56: )
57:
58: IS
59: l_exception_msg varchar2(100);
60: l_bill_to hz_party_site_uses.SITE_USE_TYPE%TYPE;
61: l_ship_to hz_party_site_uses.SITE_USE_TYPE%TYPE;
62: l_mail_to hz_party_site_uses.SITE_USE_TYPE%TYPE;
63:
64: BEGIN
57:
58: IS
59: l_exception_msg varchar2(100);
60: l_bill_to hz_party_site_uses.SITE_USE_TYPE%TYPE;
61: l_ship_to hz_party_site_uses.SITE_USE_TYPE%TYPE;
62: l_mail_to hz_party_site_uses.SITE_USE_TYPE%TYPE;
63:
64: BEGIN
65:
58: IS
59: l_exception_msg varchar2(100);
60: l_bill_to hz_party_site_uses.SITE_USE_TYPE%TYPE;
61: l_ship_to hz_party_site_uses.SITE_USE_TYPE%TYPE;
62: l_mail_to hz_party_site_uses.SITE_USE_TYPE%TYPE;
63:
64: BEGIN
65:
66: l_bill_to := 'BILL_TO';
86: , DECODE (hpsu_mail_to.site_use_type, l_mail_to,'Y','N')
87:
88: FROM hz_locations hl
89: , hz_party_sites hps
90: , hz_party_site_uses hpsu_ship_to
91: , hz_party_site_uses hpsu_bill_to
92: , hz_party_site_uses hpsu_mail_to
93:
94: WHERE hl.location_id = p_location_id
87:
88: FROM hz_locations hl
89: , hz_party_sites hps
90: , hz_party_site_uses hpsu_ship_to
91: , hz_party_site_uses hpsu_bill_to
92: , hz_party_site_uses hpsu_mail_to
93:
94: WHERE hl.location_id = p_location_id
95: AND hps.location_id = hl.location_id
88: FROM hz_locations hl
89: , hz_party_sites hps
90: , hz_party_site_uses hpsu_ship_to
91: , hz_party_site_uses hpsu_bill_to
92: , hz_party_site_uses hpsu_mail_to
93:
94: WHERE hl.location_id = p_location_id
95: AND hps.location_id = hl.location_id
96: AND hpsu_ship_to.party_site_id(+) = hps.party_site_id