DBA Data[Home] [Help]

APPS.OKS_BILL_REC_PUB dependencies on OKC_K_ITEMS

Line 361: FROM okc_k_items OKC

357:
358: Cursor qty_uom_csr(p_cle_id IN NUMBER) Is
359: SELECT okc.Number_of_items
360: ,tl.Unit_of_measure uom_code
361: FROM okc_k_items OKC
362: ,mtl_units_of_measure_tl tl
363: WHERE okc.cle_id = P_cle_id
364: AND tl.uom_code = OKC.uom_code
365: AND tl.language = USERENV('LANG');

Line 369: FROM Okc_K_items Item

365: AND tl.language = USERENV('LANG');
366:
367: CURSOR inv_item_csr(p_cle_id IN NUMBER) Is
368: SELECT primary_uom_code
369: FROM Okc_K_items Item
370: ,mtl_system_items mtl
371: ,okc_k_lines_b line
372: ,okc_k_headers_b hdr
373: WHERE item.cle_id = p_cle_id

Line 905: FROM Okc_K_items Item

901:
902: CURSOR l_inv_item_csr(p_cle_id Number) Is
903: SELECT mtl.primary_uom_code,
904: line.dnz_chr_id
905: FROM Okc_K_items Item
906: ,mtl_system_items_b mtl --Okx_system_items_v mtl
907: ,okc_k_headers_b hdr
908: ,okc_k_lines_b line
909: WHERE item.cle_id = line.id --p_cle_id

Line 2832: okc_k_items cim

2828: ,cle.price_negotiated
2829: ,cle.cle_id
2830: ,TO_NUMBER(cim.object1_id1) instance_id
2831: FROM Okc_k_lines_b cle,
2832: okc_k_items cim
2833: WHERE cle.id = p_line_id
2834: AND cle.lse_id = 25
2835: AND cle.id = cim.cle_id;
2836:

Line 2881: FROM OKC_K_ITEMS OKC

2877:
2878: Cursor qty_uom_csr(p_cle_id Number) Is
2879: SELECt okc.Number_of_items
2880: ,tl.Unit_of_measure uom_code
2881: FROM OKC_K_ITEMS OKC
2882: ,mtl_units_of_measure_tl tl
2883: WHERE okc.cle_id = P_cle_id
2884: AND tl.uom_code = OKC.uom_code
2885: AND tl.language = USERENV('LANG');

Line 6507: FROM OKC_K_ITEMS item

6503: AND nvl(valid_flag,'N') = 'N';
6504:
6505: Cursor inv_item_csr Is
6506: SELECT item.object1_id1
6507: FROM OKC_K_ITEMS item
6508: WHERE item.cle_id = p_cle_id;
6509:
6510: Cursor uom_csr(p_counter_id Number) Is
6511: SELECT uom_code

Line 7804: From Okc_K_items Item,

7800: Is
7801: Select item.Object1_id1,
7802: mtl.usage_item_flag,
7803: mtl.service_item_flag
7804: From Okc_K_items Item,
7805: mtl_system_items_b mtl
7806: Where item.cle_id = p_cle_id
7807: And mtl.inventory_item_id = item.object1_id1;
7808:

Line 7822: From OKC_K_ITEMS_V OKC,

7818: Cursor qty_uom_csr(p_cle_id Number)
7819: Is
7820: Select okc.Number_of_items,
7821: tl.Unit_of_measure uom_code
7822: From OKC_K_ITEMS_V OKC,
7823: mtl_units_of_measure_tl tl
7824: Where okc.cle_id = P_cle_id
7825: And tl.uom_code = OKC.uom_code
7826: AND tl.language = USERENV('LANG');

Line 8582: okc_k_items cim

8578: /***************************************************
8579: Cursor cur_subline_sr(p_id IN NUMBER) IS
8580: SELECT 'x'
8581: FROM CS_INCIDENTS_ALL_B sr,
8582: okc_k_items cim
8583: where cim.cle_id = p_id
8584: and sr.customer_product_id = cim.object1_id1
8585: and sr.status_flag = 'O';
8586: ***************************************************/

Line 8590: FROM okc_k_items cim,

8586: ***************************************************/
8587:
8588: Cursor cur_subline_sr(p_id IN NUMBER) IS
8589: SELECT 'x'
8590: FROM okc_k_items cim,
8591: CS_INCIDENTS_ALL_B sr
8592: where cim.cle_id = p_cp_line_id
8593: and sr.contract_service_id = p_top_line_id
8594: and sr.customer_product_id = to_number(cim.object1_id1)

Line 9889: okc_k_items itm

9885: line.price_negotiated total_amount,
9886: rline.toplvl_uom_code
9887: FROM okc_k_lines_b line,
9888: oks_k_lines_b rline,
9889: okc_k_items itm
9890: WHERE line.cle_id = p_cle_id
9891: AND line.lse_id in (7,8,9,10,11,13,25,35)
9892: AND line.id = nvl(p_cp_line_id,line.id)
9893: AND rline.cle_id = line.id

Line 10337: okc_k_items itm

10333: rline.toplvl_uom_code,
10334: line.price_negotiated total_amount
10335: FROM okc_k_lines_b line,
10336: oks_k_lines_b rline,
10337: okc_k_items itm
10338: WHERE line.id = p_id
10339: AND rline.cle_id = line.id
10340: AND itm.cle_id = line.id
10341: AND line.date_cancelled is NULL --LLC BUG FIX 4742661

Line 10355: okc_k_items itm

10351: rline.toplvl_uom_code,
10352: line.price_negotiated total_amount
10353: FROM okc_k_lines_b line,
10354: oks_k_lines_b rline,
10355: okc_k_items itm
10356: WHERE line.cle_id = p_cle_id
10357: AND itm.cle_id = line.id
10358: AND rline.cle_id = line.id
10359: AND line.date_cancelled is NULL --LLC BUG FIX 4742661