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 2217: FROM okx_cust_site_uses_v site ,

2213: /*CURSOR current_billing_info(p_contract_id NUMBER) IS
2214: SELECT contract.contract_number contract_number,
2215: site.name bill_to_site,
2216: site.description bill_to_address
2217: FROM okx_cust_site_uses_v site ,
2218: okc_k_headers_all_b contract
2219: WHERE contract.id = p_contract_id
2220: AND site.id1 = contract.bill_to_site_use_id; */
2221:

Line 2246: l_current_billing_site okx_cust_site_uses_v.name%type;

2242: current_billing_info_rec current_billing_info%rowtype;
2243:
2244: -- parameters set in the procedure
2245: l_contract_number okc_k_headers_b.contract_number%type;
2246: l_current_billing_site okx_cust_site_uses_v.name%type;
2247: l_current_billing_address okx_cust_site_uses_v.description%type;
2248: l_new_billing_site okx_cust_site_uses_v.name%type;
2249: l_new_billing_address okx_cust_site_uses_v.description%type;
2250: l_username fnd_user.user_name%type;

Line 2247: l_current_billing_address okx_cust_site_uses_v.description%type;

2243:
2244: -- parameters set in the procedure
2245: l_contract_number okc_k_headers_b.contract_number%type;
2246: l_current_billing_site okx_cust_site_uses_v.name%type;
2247: l_current_billing_address okx_cust_site_uses_v.description%type;
2248: l_new_billing_site okx_cust_site_uses_v.name%type;
2249: l_new_billing_address okx_cust_site_uses_v.description%type;
2250: l_username fnd_user.user_name%type;
2251: l_respString VARCHAR2(50);

Line 2248: l_new_billing_site okx_cust_site_uses_v.name%type;

2244: -- parameters set in the procedure
2245: l_contract_number okc_k_headers_b.contract_number%type;
2246: l_current_billing_site okx_cust_site_uses_v.name%type;
2247: l_current_billing_address okx_cust_site_uses_v.description%type;
2248: l_new_billing_site okx_cust_site_uses_v.name%type;
2249: l_new_billing_address okx_cust_site_uses_v.description%type;
2250: l_username fnd_user.user_name%type;
2251: l_respString VARCHAR2(50);
2252: l_respId NUMBER;

Line 2249: l_new_billing_address okx_cust_site_uses_v.description%type;

2245: l_contract_number okc_k_headers_b.contract_number%type;
2246: l_current_billing_site okx_cust_site_uses_v.name%type;
2247: l_current_billing_address okx_cust_site_uses_v.description%type;
2248: l_new_billing_site okx_cust_site_uses_v.name%type;
2249: l_new_billing_address okx_cust_site_uses_v.description%type;
2250: l_username fnd_user.user_name%type;
2251: l_respString VARCHAR2(50);
2252: l_respId NUMBER;
2253: l_resp_key VARCHAR2(30);

Line 2266: from okx_cust_site_uses_v

2262:
2263: --rkuttiya commented for bug #6523600
2264: /*CURSOR new_billing_info(p_billing_site_id NUMBER) IS
2265: select name bill_to_site, description bill_to_address
2266: from okx_cust_site_uses_v
2267: where id1= p_billing_site_id; */
2268:
2269: CURSOR new_billing_info(p_billing_site_id IN VARCHAR2) IS
2270: SELECT CS.LOCATION BILL_TO_SITE,