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_OPEN_INTERFACE_PVT dependencies on OKX_CUST_SITE_USES_V

Line 4374: FROM okx_cust_site_uses_v site_use,

4370: p_bill_to_address VARCHAR2,
4371: p_bill_to_address_id NUMBER,
4372: p_customer_account_id NUMBER) IS
4373: SELECT site_use.id1
4374: FROM okx_cust_site_uses_v site_use,
4375: hz_cust_acct_sites_all site
4376: WHERE site.cust_acct_site_id = site_use.cust_acct_site_id
4377: AND ((site_use.name = p_bill_to_address
4378: AND

Line 7747: x_bill_to_address_id OKX_CUST_SITE_USES_V.ID1%TYPE;

7743: header_rule_failed EXCEPTION;
7744: l_proc_name VARCHAR2(35) := 'CREATE_HEADER_RULES';
7745:
7746: x_customer_account_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;
7747: x_bill_to_address_id OKX_CUST_SITE_USES_V.ID1%TYPE;
7748: x_bank_account_id OKX_RCPT_METHOD_ACCOUNTS_V.ID1%TYPE;
7749: x_invoice_format_id OKL_INVOICE_FORMATS_V.ID%TYPE;
7750: x_payment_method_id OKX_RECEIPT_METHODS_V.ID1%TYPE;
7751: x_invoice_format_name okl_invoice_formats_v.name%TYPE;

Line 18399: FROM okx_cust_site_uses_v site_use,

18395: CURSOR cust_ship_csr (p_party_site_id NUMBER,
18396: p_cust_acct_id NUMBER,
18397: p_org_id NUMBER) IS
18398: SELECT site_use.id1
18399: FROM okx_cust_site_uses_v site_use,
18400: hz_cust_acct_sites_all site
18401: WHERE site.cust_acct_site_id = site_use.cust_acct_site_id
18402: AND site_use.party_site_id = p_party_site_id
18403: AND site_use.org_id = p_org_id