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.OKL_SSC_WF dependencies on OKX_CUST_SITE_USES_V

Line 2131: FROM okx_cust_site_uses_v site ,

2127: /*CURSOR current_billing_info(p_contract_id NUMBER) IS
2128: SELECT contract.contract_number contract_number,
2129: site.name bill_to_site,
2130: site.description bill_to_address
2131: FROM okx_cust_site_uses_v site ,
2132: okc_k_headers_all_b contract
2133: WHERE contract.id = p_contract_id
2134: AND site.id1 = contract.bill_to_site_use_id; */
2135:

Line 2160: l_current_billing_site okx_cust_site_uses_v.name%type;

2156: current_billing_info_rec current_billing_info%rowtype;
2157:
2158: -- parameters set in the procedure
2159: l_contract_number okc_k_headers_b.contract_number%type;
2160: l_current_billing_site okx_cust_site_uses_v.name%type;
2161: l_current_billing_address okx_cust_site_uses_v.description%type;
2162: l_new_billing_site okx_cust_site_uses_v.name%type;
2163: l_new_billing_address okx_cust_site_uses_v.description%type;
2164: l_username fnd_user.user_name%type;

Line 2161: l_current_billing_address okx_cust_site_uses_v.description%type;

2157:
2158: -- parameters set in the procedure
2159: l_contract_number okc_k_headers_b.contract_number%type;
2160: l_current_billing_site okx_cust_site_uses_v.name%type;
2161: l_current_billing_address okx_cust_site_uses_v.description%type;
2162: l_new_billing_site okx_cust_site_uses_v.name%type;
2163: l_new_billing_address okx_cust_site_uses_v.description%type;
2164: l_username fnd_user.user_name%type;
2165: l_respString VARCHAR2(50);

Line 2162: l_new_billing_site okx_cust_site_uses_v.name%type;

2158: -- parameters set in the procedure
2159: l_contract_number okc_k_headers_b.contract_number%type;
2160: l_current_billing_site okx_cust_site_uses_v.name%type;
2161: l_current_billing_address okx_cust_site_uses_v.description%type;
2162: l_new_billing_site okx_cust_site_uses_v.name%type;
2163: l_new_billing_address okx_cust_site_uses_v.description%type;
2164: l_username fnd_user.user_name%type;
2165: l_respString VARCHAR2(50);
2166: l_respId NUMBER;

Line 2163: l_new_billing_address okx_cust_site_uses_v.description%type;

2159: l_contract_number okc_k_headers_b.contract_number%type;
2160: l_current_billing_site okx_cust_site_uses_v.name%type;
2161: l_current_billing_address okx_cust_site_uses_v.description%type;
2162: l_new_billing_site okx_cust_site_uses_v.name%type;
2163: l_new_billing_address okx_cust_site_uses_v.description%type;
2164: l_username fnd_user.user_name%type;
2165: l_respString VARCHAR2(50);
2166: l_respId NUMBER;
2167: l_resp_key VARCHAR2(30);

Line 2180: from okx_cust_site_uses_v

2176:
2177: --rkuttiya commented for bug #6523600
2178: /*CURSOR new_billing_info(p_billing_site_id NUMBER) IS
2179: select name bill_to_site, description bill_to_address
2180: from okx_cust_site_uses_v
2181: where id1= p_billing_site_id; */
2182:
2183: CURSOR new_billing_info(p_billing_site_id IN VARCHAR2) IS
2184: SELECT CS.LOCATION BILL_TO_SITE,