eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_OC_INT_KTO_PVT dependencies on OKX_CUST_SITE_USES_V

Line 170: party_site_id okx_cust_site_uses_v.party_site_id%TYPE,

166: TYPE bto_sto_rec_typ IS RECORD
167: (
168: chr_id okc_k_headers_b.id%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,

Line 171: cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE,

167: (
168: chr_id okc_k_headers_b.id%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,

Line 172: party_id okx_cust_site_uses_v.party_id%TYPE,

168: chr_id okc_k_headers_b.id%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,

Line 212: l_st_cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE;

208: l_order_type_id varchar2(240):= nvl(fnd_profile.value('OKS_ORDER_TYPE_ID'), okc_api.g_miss_char);
209: l_cust c_cust%ROWTYPE;
210: l_customer c_cust%ROWTYPE;
211:
212: l_st_cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE;
213: l_st_party_site_id okx_cust_site_uses_v.party_site_id%TYPE;
214: l_st_party_id okx_cust_site_uses_v.party_id%TYPE;
215: l_bt_cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE;
216: l_bt_party_site_id okx_cust_site_uses_v.party_site_id%TYPE;

Line 213: l_st_party_site_id okx_cust_site_uses_v.party_site_id%TYPE;

209: l_cust c_cust%ROWTYPE;
210: l_customer c_cust%ROWTYPE;
211:
212: l_st_cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE;
213: l_st_party_site_id okx_cust_site_uses_v.party_site_id%TYPE;
214: l_st_party_id okx_cust_site_uses_v.party_id%TYPE;
215: l_bt_cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE;
216: l_bt_party_site_id okx_cust_site_uses_v.party_site_id%TYPE;
217: l_bt_party_id okx_cust_site_uses_v.party_id%TYPE;

Line 214: l_st_party_id okx_cust_site_uses_v.party_id%TYPE;

210: l_customer c_cust%ROWTYPE;
211:
212: l_st_cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE;
213: l_st_party_site_id okx_cust_site_uses_v.party_site_id%TYPE;
214: l_st_party_id okx_cust_site_uses_v.party_id%TYPE;
215: l_bt_cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE;
216: l_bt_party_site_id okx_cust_site_uses_v.party_site_id%TYPE;
217: l_bt_party_id okx_cust_site_uses_v.party_id%TYPE;
218:

Line 215: l_bt_cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE;

211:
212: l_st_cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE;
213: l_st_party_site_id okx_cust_site_uses_v.party_site_id%TYPE;
214: l_st_party_id okx_cust_site_uses_v.party_id%TYPE;
215: l_bt_cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE;
216: l_bt_party_site_id okx_cust_site_uses_v.party_site_id%TYPE;
217: l_bt_party_id okx_cust_site_uses_v.party_id%TYPE;
218:
219: l_exchange_type okc_conversion_attribs_v.conversion_type%TYPE;

Line 216: l_bt_party_site_id okx_cust_site_uses_v.party_site_id%TYPE;

212: l_st_cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE;
213: l_st_party_site_id okx_cust_site_uses_v.party_site_id%TYPE;
214: l_st_party_id okx_cust_site_uses_v.party_id%TYPE;
215: l_bt_cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE;
216: l_bt_party_site_id okx_cust_site_uses_v.party_site_id%TYPE;
217: l_bt_party_id okx_cust_site_uses_v.party_id%TYPE;
218:
219: l_exchange_type okc_conversion_attribs_v.conversion_type%TYPE;
220: l_exchange_rate okc_conversion_attribs_v.conversion_rate%TYPE;

Line 217: l_bt_party_id okx_cust_site_uses_v.party_id%TYPE;

213: l_st_party_site_id okx_cust_site_uses_v.party_site_id%TYPE;
214: l_st_party_id okx_cust_site_uses_v.party_id%TYPE;
215: l_bt_cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE;
216: l_bt_party_site_id okx_cust_site_uses_v.party_site_id%TYPE;
217: l_bt_party_id okx_cust_site_uses_v.party_id%TYPE;
218:
219: l_exchange_type okc_conversion_attribs_v.conversion_type%TYPE;
220: l_exchange_rate okc_conversion_attribs_v.conversion_rate%TYPE;
221: l_exchange_date okc_conversion_attribs_v.conversion_date%TYPE;

Line 353: FROM okx_cust_site_uses_v

349: ,province
350: ,postal_code
351: ,county
352: ,country
353: FROM okx_cust_site_uses_v
354: WHERE id1 = b_id1;
355: --
356: l_party_site c_party_site%ROWTYPE;
357: e_exit EXCEPTION;