[Home] [Help]
360:
361: Cursor qty_uom_csr(p_cle_id IN NUMBER) Is
362: SELECT okc.Number_of_items
363: ,tl.Unit_of_measure uom_code
364: FROM okc_k_items OKC
365: ,mtl_units_of_measure_tl tl
366: WHERE okc.cle_id = P_cle_id
367: AND tl.uom_code = OKC.uom_code
368: AND tl.language = USERENV('LANG');
368: AND tl.language = USERENV('LANG');
369:
370: CURSOR inv_item_csr(p_cle_id IN NUMBER) Is
371: SELECT primary_uom_code
372: FROM Okc_K_items Item
373: ,mtl_system_items mtl
374: ,okc_k_lines_b line
375: ,okc_k_headers_b hdr
376: WHERE item.cle_id = p_cle_id
920:
921: CURSOR l_inv_item_csr(p_cle_id Number) Is
922: SELECT mtl.primary_uom_code,
923: line.dnz_chr_id
924: FROM Okc_K_items Item
925: ,mtl_system_items_b mtl --Okx_system_items_v mtl
926: ,okc_k_headers_b hdr
927: ,okc_k_lines_b line
928: WHERE item.cle_id = line.id --p_cle_id
2842: ,cle.price_negotiated
2843: ,cle.cle_id
2844: ,TO_NUMBER(cim.object1_id1) instance_id
2845: FROM Okc_k_lines_b cle,
2846: okc_k_items cim
2847: WHERE cle.id = p_line_id
2848: AND cle.lse_id = 25
2849: AND cle.id = cim.cle_id;
2850:
2891:
2892: Cursor qty_uom_csr(p_cle_id Number) Is
2893: SELECt okc.Number_of_items
2894: ,tl.Unit_of_measure uom_code
2895: FROM OKC_K_ITEMS OKC
2896: ,mtl_units_of_measure_tl tl
2897: WHERE okc.cle_id = P_cle_id
2898: AND tl.uom_code = OKC.uom_code
2899: AND tl.language = USERENV('LANG');
6531: ORDER BY value_timestamp desc,counter_value_id DESC; /*Added for bug:9778692*/
6532:
6533: Cursor inv_item_csr Is
6534: SELECT item.object1_id1
6535: FROM OKC_K_ITEMS item
6536: WHERE item.cle_id = p_cle_id;
6537:
6538: Cursor uom_csr(p_counter_id Number) Is
6539: SELECT uom_code
7832: Is
7833: Select item.Object1_id1,
7834: mtl.usage_item_flag,
7835: mtl.service_item_flag
7836: From Okc_K_items Item,
7837: mtl_system_items_b mtl
7838: Where item.cle_id = p_cle_id
7839: And mtl.inventory_item_id = item.object1_id1;
7840:
7850: Cursor qty_uom_csr(p_cle_id Number)
7851: Is
7852: Select okc.Number_of_items,
7853: tl.Unit_of_measure uom_code
7854: From OKC_K_ITEMS_V OKC,
7855: mtl_units_of_measure_tl tl
7856: Where okc.cle_id = P_cle_id
7857: And tl.uom_code = OKC.uom_code
7858: AND tl.language = USERENV('LANG');
8618: /***************************************************
8619: Cursor cur_subline_sr(p_id IN NUMBER) IS
8620: SELECT 'x'
8621: FROM CS_INCIDENTS_ALL_B sr,
8622: okc_k_items cim
8623: where cim.cle_id = p_id
8624: and sr.customer_product_id = cim.object1_id1
8625: and sr.status_flag = 'O';
8626: ***************************************************/
8626: ***************************************************/
8627:
8628: Cursor cur_subline_sr(p_id IN NUMBER) IS
8629: SELECT 'x'
8630: FROM okc_k_items cim,
8631: CS_INCIDENTS_ALL_B sr
8632: where cim.cle_id = p_cp_line_id
8633: and sr.contract_service_id = p_top_line_id
8634: and sr.customer_product_id = to_number(cim.object1_id1)
9975: line.price_negotiated total_amount,
9976: rline.toplvl_uom_code
9977: FROM okc_k_lines_b line,
9978: oks_k_lines_b rline,
9979: okc_k_items itm
9980: WHERE line.cle_id = p_cle_id
9981: AND line.lse_id in (7,8,9,10,11,13,25,35)
9982: AND line.id = nvl(p_cp_line_id,line.id)
9983: AND rline.cle_id = line.id
10451: rline.toplvl_uom_code,
10452: line.price_negotiated total_amount
10453: FROM okc_k_lines_b line,
10454: oks_k_lines_b rline,
10455: okc_k_items itm
10456: WHERE line.id = p_id
10457: AND rline.cle_id = line.id
10458: AND itm.cle_id = line.id
10459: AND line.date_cancelled is NULL --LLC BUG FIX 4742661
10469: rline.toplvl_uom_code,
10470: line.price_negotiated total_amount
10471: FROM okc_k_lines_b line,
10472: oks_k_lines_b rline,
10473: okc_k_items itm
10474: WHERE line.cle_id = p_cle_id
10475: AND itm.cle_id = line.id
10476: AND rline.cle_id = line.id
10477: AND line.date_cancelled is NULL --LLC BUG FIX 4742661