[Home] [Help]
614: SELECT item.Object1_id1
615: ,mtl.usage_item_flag
616: ,mtl.service_item_flag
617: ,mtl.primary_uom_code
618: FROM Okc_K_items Item
619: ,mtl_system_items_b mtl --Okx_system_items_v mtl
620: WHERE item.cle_id = p_cle_id
621: --AND mtl.id1 = item.object1_id1
622: AND mtl.inventory_item_id = item.object1_id1
634:
635: Cursor qty_uom_csr_sub(p_cle_id Number) Is
636: SELECT okc.Number_of_items
637: ,tl.Unit_of_measure uom_code
638: FROM okc_k_items okc
639: ,mtl_units_of_measure_tl tl
640: WHERE okc.cle_id = p_cle_id
641: AND tl.uom_code = okc.uom_code
642: AND tl.language = USERENV('LANG');
643:
644: /*
645: SELECT Number_of_items
646: ,OKX.Unit_of_measure uom_code
647: FROM OKC_K_ITEMS OKC
648: ,OKX_UNITS_OF_MEASURE_V OKX
649: WHERE cle_id = P_cle_id
650: AND Okx.uom_code = OKC.uom_code ;
651: */
727:
728:
729: Cursor get_counter_qty(p_cle_id Number, p_lock_read number) IS
730: select value_timestamp, counter_id
731: from cs_counter_values, okc_k_items
732: where cle_id = p_cle_id
733: and to_char(counter_id) = object1_id1
734: and counter_reading = p_lock_read;
735:
734: and counter_reading = p_lock_read;
735:
736: Cursor get_counter_vrt(p_cle_id Number) IS
737: select to_number(object1_id1)
738: from okc_k_items
739: where cle_id = p_cle_id;
740:
741:
742: --23-DEC-2005 mchoudha fix for bug#4915367
3635: SELECT item.Object1_id1
3636: ,mtl.usage_item_flag
3637: ,mtl.service_item_flag
3638: ,mtl.primary_uom_code
3639: FROM Okc_K_items Item
3640: ,mtl_system_items_b mtl --Okx_system_items_v mtl
3641: WHERE item.cle_id = p_cle_id
3642: --AND mtl.id1 = item.object1_id1
3643: AND mtl.inventory_item_id = item.object1_id1
3655:
3656: Cursor qty_uom_csr_sub(p_cle_id Number) Is
3657: SELECT okc.Number_of_items
3658: ,tl.Unit_of_measure uom_code
3659: FROM okc_k_items okc
3660: ,mtl_units_of_measure_tl tl
3661: WHERE okc.cle_id = p_cle_id
3662: AND tl.uom_code = okc.uom_code
3663: AND tl.language = USERENV('LANG');
3664:
3665: /*
3666: SELECT Number_of_items
3667: ,OKX.Unit_of_measure uom_code
3668: FROM OKC_K_ITEMS OKC
3669: ,OKX_UNITS_OF_MEASURE_V OKX
3670: WHERE cle_id = P_cle_id
3671: AND Okx.uom_code = OKC.uom_code ;
3672: */
3748:
3749:
3750: Cursor get_counter_qty(p_cle_id Number, p_lock_read number) IS
3751: select value_timestamp, counter_id
3752: from cs_counter_values, okc_k_items
3753: where cle_id = p_cle_id
3754: and to_char(counter_id) = object1_id1
3755: and counter_reading = p_lock_read;
3756:
3755: and counter_reading = p_lock_read;
3756:
3757: Cursor get_counter_vrt(p_cle_id Number) IS
3758: select to_number(object1_id1)
3759: from okc_k_items
3760: where cle_id = p_cle_id;
3761:
3762:
3763: --23-DEC-2005 mchoudha fix for bug#4915367
4608:
4609: Cursor qty_uom_csr(p_cle_id Number) Is
4610: SELECT okc.Number_of_items
4611: ,tl.Unit_of_measure uom_code
4612: FROM okc_k_items okc
4613: ,mtl_units_of_measure_tl tl
4614: WHERE okc.cle_id = p_cle_id
4615: AND tl.uom_code = okc.uom_code
4616: AND tl.language = USERENV('LANG');
4617:
4618: /*
4619: Select Number_of_items
4620: ,OKX.Unit_of_measure uom_code
4621: From OKC_K_ITEMS OKC
4622: ,OKX_UNITS_OF_MEASURE_V OKX
4623: Where cle_id = P_cle_id
4624: And Okx.uom_code = OKC.uom_code ;
4625: */
5412: SELECT item.Object1_id1
5413: ,mtl.usage_item_flag
5414: ,mtl.service_item_flag
5415: ,mtl.primary_uom_code
5416: FROM Okc_K_items Item
5417: ,mtl_system_items_b mtl --Okx_system_items_v mtl
5418: WHERE item.cle_id = p_cle_id
5419: --AND mtl.id1 = item.object1_id1
5420: AND mtl.inventory_item_id = item.object1_id1
5422:
5423: Cursor qty_uom_csr(p_cle_id Number) Is
5424: SELECT okc.Number_of_items
5425: ,tl.Unit_of_measure uom_code
5426: FROM okc_k_items okc
5427: ,mtl_units_of_measure_tl tl
5428: WHERE okc.cle_id = p_cle_id
5429: AND tl.uom_code = okc.uom_code
5430: AND tl.language = USERENV('LANG');
5431:
5432: /*
5433: SELECT Number_of_items
5434: ,OKX.Unit_of_measure uom_code
5435: FROM OKC_K_ITEMS OKC
5436: ,OKX_UNITS_OF_MEASURE_V OKX
5437: WHERE cle_id = P_cle_id
5438: AND Okx.uom_code = OKC.uom_code ;
5439: */