DBA Data[Home] [Help]

APPS.OKS_OC_INT_KTO_PVT dependencies on HZ_LOCATIONS

Line 173: address1 HZ_LOCATIONS.address1%TYPE,

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,

Line 174: address2 HZ_LOCATIONS.address2%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,

Line 175: address3 HZ_LOCATIONS.address3%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,

Line 176: address4 HZ_LOCATIONS.address4%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,

Line 177: city HZ_LOCATIONS.city%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,

Line 178: postal_code HZ_LOCATIONS.postal_code%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);

Line 179: state HZ_LOCATIONS.state%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:

Line 180: province HZ_LOCATIONS.province%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:
184: TYPE l_k_bto_sto_data_tab_typ IS TABLE OF bto_sto_rec_typ INDEX BY BINARY_INTEGER;

Line 181: county HZ_LOCATIONS.county%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;
185:

Line 182: country HZ_LOCATIONS.country%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:
186: --