APPS.OKL_AM_INVOICES_PVT dependencies on OKX_CUST_SITE_USES_V

Line 175: FROM okx_cust_site_uses_v a,

171: cp_site_use_code IN VARCHAR2) IS
172: SELECT a.cust_account_id cust_account_id,
173: a.cust_acct_site_id cust_acct_site_id,
174: a.payment_term_id payment_term_id
175: FROM okx_cust_site_uses_v a,
176: okx_customer_accounts_v c
177: WHERE a.id1 = cp_site_use_id
178: AND a.site_use_code = cp_site_use_code
179: AND c.id1 = a.cust_account_id;

Line 666: select b.id from okc_k_party_roles_b b,okx_cust_site_uses_v a

662: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
663:
664: --sosharma bug 10288332 Added cursors to find cpl_id and quote type
665: Cursor role_info(c_khr_id IN NUMBER,c_site_id IN NUMBER,c_cust_id IN NUMBER) IS
666: select b.id from okc_k_party_roles_b b,okx_cust_site_uses_v a
667: where b.chr_id=c_khr_id
668: and b.bill_to_site_use_id = a.id1
669: and a.site_use_code='BILL_TO'
670: and a.cust_account_id=b.cust_acct_id

Line 2387: okx_cust_site_uses_v csu

2383: FROM oe_order_lines_all oli,
2384: oe_order_headers_all ohe,
2385: okl_asset_returns_b art,
2386: okc_k_lines_v kle,
2387: okx_cust_site_uses_v csu
2388: WHERE oli.line_id = cp_order_line_id
2389: AND ohe.header_id = oli.header_id
2390: AND art.imr_id = oli.inventory_item_id
2391: AND kle.id = art.kle_id