DBA Data[Home] [Help]

APPS.OKS_QP_PKG dependencies on OKC_K_LINES_B

Line 274: FROM okc_k_lines_b

270: )
271: IS
272: SELECT cle_id,
273: dnz_chr_id
274: FROM okc_k_lines_b
275: WHERE ID = cp_subline_id;
276:
277: --- find modifier for top line
278: CURSOR cs_topline_mod (

Line 4733: okc_k_lines_b kl,

4729: ki.object1_id1 tl_object_id,
4730: ki.number_of_items tl_qty,
4731: ki.uom_code tl_uom_code
4732: FROM okc_k_headers_all_b kh,
4733: okc_k_lines_b kl,
4734: okc_k_items ki
4735: WHERE kh.ID = kl.chr_id AND
4736: kl.ID = p_detail_rec.line_id AND
4737: ki.cle_id = kl.ID;

Line 4751: FROM okc_k_lines_b kl,

4747: ki.object1_id1 sl_object_id,
4748: ki.number_of_items sl_qty,
4749: ki.uom_code sl_uom_code,
4750: ks.price_uom sl_price_uom
4751: FROM okc_k_lines_b kl,
4752: okc_k_items ki,
4753: oks_k_lines_b ks
4754: WHERE kl.ID = p_detail_rec.subline_id AND
4755: ks.cle_id = kl.ID AND

Line 4765: FROM okc_k_lines_b

4761: p_cle_id NUMBER
4762: )
4763: IS
4764: SELECT dnz_chr_id
4765: FROM okc_k_lines_b
4766: WHERE ID = p_cle_id;
4767:
4768: FUNCTION get_customer_id (
4769: p_chr_id IN NUMBER,

Line 4802: FROM okc_k_lines_b

4798: rl.rule_information_category = 'CAN';
4799: */
4800: SELECT cust_acct_id
4801: INTO l_cust_id
4802: FROM okc_k_lines_b
4803: WHERE ID = p_cle_id;
4804:
4805: -- end debug log
4806: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)