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.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)

Line 9481: okc_k_lines_b kl,

9477: ki.object1_id1 tl_object_id,
9478: ki.number_of_items tl_qty,
9479: ki.uom_code tl_uom_code
9480: FROM okc_k_headers_all_b kh,
9481: okc_k_lines_b kl,
9482: okc_k_items ki
9483: WHERE kh.ID = kl.chr_id AND
9484: kl.ID = p_detail_rec.line_id AND
9485: ki.cle_id = kl.ID;

Line 9499: FROM okc_k_lines_b kl,

9495: ki.object1_id1 sl_object_id,
9496: ki.number_of_items sl_qty,
9497: ki.uom_code sl_uom_code,
9498: ks.price_uom sl_price_uom
9499: FROM okc_k_lines_b kl,
9500: okc_k_items ki,
9501: oks_k_lines_b ks
9502: WHERE kl.ID = p_detail_rec.subline_id AND
9503: ks.cle_id = kl.ID AND

Line 9513: FROM okc_k_lines_b

9509: p_cle_id NUMBER
9510: )
9511: IS
9512: SELECT dnz_chr_id
9513: FROM okc_k_lines_b
9514: WHERE ID = p_cle_id;
9515:
9516: FUNCTION get_customer_id (
9517: p_chr_id IN NUMBER,

Line 9550: FROM okc_k_lines_b

9546: rl.rule_information_category = 'CAN';
9547: */
9548: SELECT cust_acct_id
9549: INTO l_cust_id
9550: FROM okc_k_lines_b
9551: WHERE ID = p_cle_id;
9552:
9553: -- end debug log
9554: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

Line 12734: okc_k_lines_b kl,

12730: ki.object1_id1 tl_object_id,
12731: ki.number_of_items tl_qty,
12732: ki.uom_code tl_uom_code
12733: FROM okc_k_headers_all_b kh,
12734: okc_k_lines_b kl,
12735: okc_k_items ki
12736: WHERE kh.ID = kl.chr_id AND
12737: kl.ID = p_detail_rec.line_id AND
12738: ki.cle_id = kl.ID;

Line 12752: FROM okc_k_lines_b kl,

12748: ki.object1_id1 sl_object_id,
12749: ki.number_of_items sl_qty,
12750: ki.uom_code sl_uom_code,
12751: ks.price_uom sl_price_uom
12752: FROM okc_k_lines_b kl,
12753: okc_k_items ki,
12754: oks_k_lines_b ks
12755: WHERE kl.ID = p_detail_rec.subline_id AND
12756: ks.cle_id = kl.ID AND

Line 12766: FROM okc_k_lines_b

12762: p_cle_id NUMBER
12763: )
12764: IS
12765: SELECT dnz_chr_id
12766: FROM okc_k_lines_b
12767: WHERE ID = p_cle_id;
12768:
12769:
12770: BEGIN