DBA Data[Home] [Help]

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 2281: okx_cust_site_uses_v csu

2277: FROM oe_order_lines_all oli,
2278: oe_order_headers_all ohe,
2279: okl_asset_returns_b art,
2280: okc_k_lines_v kle,
2281: okx_cust_site_uses_v csu
2282: WHERE oli.line_id = cp_order_line_id
2283: AND ohe.header_id = oli.header_id
2284: AND art.imr_id = oli.inventory_item_id
2285: AND kle.id = art.kle_id