DBA Data[Home] [Help]

APPS.QP_JAVA_ENGINE_CACHE_PVT dependencies on QP_PRICE_FORMULAS

Line 135: FROM qp_price_formulas qpf;

131: and qpl.list_header_id = qph.list_header_id;
132:
133: CURSOR formula_cache_key_cnt_csr IS
134: SELECT count(*)
135: FROM qp_price_formulas qpf;
136:
137: CURSOR factor_cache_key_cnt_csr IS
138: SELECT count(*)
139: FROM qp_list_headers_b qlh

Line 175: FROM qp_price_formulas qpf

171:
172: CURSOR formula_cache_key_csr IS
173: SELECT
174: qpf.price_formula_id
175: FROM qp_price_formulas qpf
176: WHERE ROWNUM < 200;
177:
178: CURSOR factor_cache_key_csr IS
179: SELECT

Line 260: FROM qp_price_formulas

256: WHERE (disable_date is null or disable_date > sysdate) and inventory_item_id = p_cache_key;
257:
258: CURSOR formula_csr(p_cache_key varchar2) IS
259: SELECT count(*)
260: FROM qp_price_formulas
261: WHERE price_formula_id = p_cache_key;
262:
263: CURSOR formula_line_csr(p_cache_key varchar2) IS
264: SELECT count(*)