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_BILLING_PUB dependencies on OKC_K_ITEMS

Line 535: FROM Okc_K_items Item

531: SELECT item.Object1_id1
532: ,mtl.usage_item_flag
533: ,mtl.service_item_flag
534: ,mtl.primary_uom_code
535: FROM Okc_K_items Item
536: ,mtl_system_items_b mtl --Okx_system_items_v mtl
537: WHERE item.cle_id = p_cle_id
538: --AND mtl.id1 = item.object1_id1
539: AND mtl.inventory_item_id = item.object1_id1

Line 555: FROM okc_k_items okc

551:
552: Cursor qty_uom_csr_sub(p_cle_id Number) Is
553: SELECT okc.Number_of_items
554: ,tl.Unit_of_measure uom_code
555: FROM okc_k_items okc
556: ,mtl_units_of_measure_tl tl
557: WHERE okc.cle_id = p_cle_id
558: AND tl.uom_code = okc.uom_code
559: AND tl.language = USERENV('LANG');

Line 564: FROM OKC_K_ITEMS OKC

560:
561: /*
562: SELECT Number_of_items
563: ,OKX.Unit_of_measure uom_code
564: FROM OKC_K_ITEMS OKC
565: ,OKX_UNITS_OF_MEASURE_V OKX
566: WHERE cle_id = P_cle_id
567: AND Okx.uom_code = OKC.uom_code ;
568: */

Line 648: from cs_counter_values, okc_k_items

644:
645:
646: Cursor get_counter_qty(p_cle_id Number, p_lock_read number) IS
647: select value_timestamp, counter_id
648: from cs_counter_values, okc_k_items
649: where cle_id = p_cle_id
650: and to_char(counter_id) = object1_id1
651: and counter_reading = p_lock_read;
652:

Line 655: from okc_k_items

651: and counter_reading = p_lock_read;
652:
653: Cursor get_counter_vrt(p_cle_id Number) IS
654: select to_number(object1_id1)
655: from okc_k_items
656: where cle_id = p_cle_id;
657:
658:
659: --23-DEC-2005 mchoudha fix for bug#4915367

Line 1479: FROM okc_k_items okc

1475:
1476: Cursor qty_uom_csr(p_cle_id Number) Is
1477: SELECT okc.Number_of_items
1478: ,tl.Unit_of_measure uom_code
1479: FROM okc_k_items okc
1480: ,mtl_units_of_measure_tl tl
1481: WHERE okc.cle_id = p_cle_id
1482: AND tl.uom_code = okc.uom_code
1483: AND tl.language = USERENV('LANG');

Line 1488: From OKC_K_ITEMS OKC

1484:
1485: /*
1486: Select Number_of_items
1487: ,OKX.Unit_of_measure uom_code
1488: From OKC_K_ITEMS OKC
1489: ,OKX_UNITS_OF_MEASURE_V OKX
1490: Where cle_id = P_cle_id
1491: And Okx.uom_code = OKC.uom_code ;
1492: */

Line 2355: FROM Okc_K_items Item

2351: SELECT item.Object1_id1
2352: ,mtl.usage_item_flag
2353: ,mtl.service_item_flag
2354: ,mtl.primary_uom_code
2355: FROM Okc_K_items Item
2356: ,mtl_system_items_b mtl --Okx_system_items_v mtl
2357: WHERE item.cle_id = p_cle_id
2358: --AND mtl.id1 = item.object1_id1
2359: AND mtl.inventory_item_id = item.object1_id1

Line 2365: FROM okc_k_items okc

2361:
2362: Cursor qty_uom_csr(p_cle_id Number) Is
2363: SELECT okc.Number_of_items
2364: ,tl.Unit_of_measure uom_code
2365: FROM okc_k_items okc
2366: ,mtl_units_of_measure_tl tl
2367: WHERE okc.cle_id = p_cle_id
2368: AND tl.uom_code = okc.uom_code
2369: AND tl.language = USERENV('LANG');

Line 2374: FROM OKC_K_ITEMS OKC

2370:
2371: /*
2372: SELECT Number_of_items
2373: ,OKX.Unit_of_measure uom_code
2374: FROM OKC_K_ITEMS OKC
2375: ,OKX_UNITS_OF_MEASURE_V OKX
2376: WHERE cle_id = P_cle_id
2377: AND Okx.uom_code = OKC.uom_code ;
2378: */