169: cle_id okc_k_lines_b.id%TYPE,
170: party_site_id okx_cust_site_uses_v.party_site_id%TYPE,
171: cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE,
172: party_id okx_cust_site_uses_v.party_id%TYPE,
173: address1 HZ_LOCATIONS.address1%TYPE,
174: address2 HZ_LOCATIONS.address2%TYPE,
175: address3 HZ_LOCATIONS.address3%TYPE,
176: address4 HZ_LOCATIONS.address4%TYPE,
177: city HZ_LOCATIONS.city%TYPE,
170: party_site_id okx_cust_site_uses_v.party_site_id%TYPE,
171: cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE,
172: party_id okx_cust_site_uses_v.party_id%TYPE,
173: address1 HZ_LOCATIONS.address1%TYPE,
174: address2 HZ_LOCATIONS.address2%TYPE,
175: address3 HZ_LOCATIONS.address3%TYPE,
176: address4 HZ_LOCATIONS.address4%TYPE,
177: city HZ_LOCATIONS.city%TYPE,
178: postal_code HZ_LOCATIONS.postal_code%TYPE,
171: cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE,
172: party_id okx_cust_site_uses_v.party_id%TYPE,
173: address1 HZ_LOCATIONS.address1%TYPE,
174: address2 HZ_LOCATIONS.address2%TYPE,
175: address3 HZ_LOCATIONS.address3%TYPE,
176: address4 HZ_LOCATIONS.address4%TYPE,
177: city HZ_LOCATIONS.city%TYPE,
178: postal_code HZ_LOCATIONS.postal_code%TYPE,
179: state HZ_LOCATIONS.state%TYPE,
172: party_id okx_cust_site_uses_v.party_id%TYPE,
173: address1 HZ_LOCATIONS.address1%TYPE,
174: address2 HZ_LOCATIONS.address2%TYPE,
175: address3 HZ_LOCATIONS.address3%TYPE,
176: address4 HZ_LOCATIONS.address4%TYPE,
177: city HZ_LOCATIONS.city%TYPE,
178: postal_code HZ_LOCATIONS.postal_code%TYPE,
179: state HZ_LOCATIONS.state%TYPE,
180: province HZ_LOCATIONS.province%TYPE,
173: address1 HZ_LOCATIONS.address1%TYPE,
174: address2 HZ_LOCATIONS.address2%TYPE,
175: address3 HZ_LOCATIONS.address3%TYPE,
176: address4 HZ_LOCATIONS.address4%TYPE,
177: city HZ_LOCATIONS.city%TYPE,
178: postal_code HZ_LOCATIONS.postal_code%TYPE,
179: state HZ_LOCATIONS.state%TYPE,
180: province HZ_LOCATIONS.province%TYPE,
181: county HZ_LOCATIONS.county%TYPE,
174: address2 HZ_LOCATIONS.address2%TYPE,
175: address3 HZ_LOCATIONS.address3%TYPE,
176: address4 HZ_LOCATIONS.address4%TYPE,
177: city HZ_LOCATIONS.city%TYPE,
178: postal_code HZ_LOCATIONS.postal_code%TYPE,
179: state HZ_LOCATIONS.state%TYPE,
180: province HZ_LOCATIONS.province%TYPE,
181: county HZ_LOCATIONS.county%TYPE,
182: country HZ_LOCATIONS.country%TYPE);
175: address3 HZ_LOCATIONS.address3%TYPE,
176: address4 HZ_LOCATIONS.address4%TYPE,
177: city HZ_LOCATIONS.city%TYPE,
178: postal_code HZ_LOCATIONS.postal_code%TYPE,
179: state HZ_LOCATIONS.state%TYPE,
180: province HZ_LOCATIONS.province%TYPE,
181: county HZ_LOCATIONS.county%TYPE,
182: country HZ_LOCATIONS.country%TYPE);
183:
176: address4 HZ_LOCATIONS.address4%TYPE,
177: city HZ_LOCATIONS.city%TYPE,
178: postal_code HZ_LOCATIONS.postal_code%TYPE,
179: state HZ_LOCATIONS.state%TYPE,
180: province HZ_LOCATIONS.province%TYPE,
181: county HZ_LOCATIONS.county%TYPE,
182: country HZ_LOCATIONS.country%TYPE);
183:
184: TYPE l_k_bto_sto_data_tab_typ IS TABLE OF bto_sto_rec_typ INDEX BY BINARY_INTEGER;
177: city HZ_LOCATIONS.city%TYPE,
178: postal_code HZ_LOCATIONS.postal_code%TYPE,
179: state HZ_LOCATIONS.state%TYPE,
180: province HZ_LOCATIONS.province%TYPE,
181: county HZ_LOCATIONS.county%TYPE,
182: country HZ_LOCATIONS.country%TYPE);
183:
184: TYPE l_k_bto_sto_data_tab_typ IS TABLE OF bto_sto_rec_typ INDEX BY BINARY_INTEGER;
185:
178: postal_code HZ_LOCATIONS.postal_code%TYPE,
179: state HZ_LOCATIONS.state%TYPE,
180: province HZ_LOCATIONS.province%TYPE,
181: county HZ_LOCATIONS.county%TYPE,
182: country HZ_LOCATIONS.country%TYPE);
183:
184: TYPE l_k_bto_sto_data_tab_typ IS TABLE OF bto_sto_rec_typ INDEX BY BINARY_INTEGER;
185:
186: --