DBA Data[Home] [Help]

APPS.OKS_IBINT_PUB dependencies on MTL_UNITS_OF_MEASURE_TL

Line 3567: FROM MTL_UNITS_OF_MEASURE_TL

3563: IS
3564: SELECT 'Y'
3565: FROM CSI_ITEM_INSTANCES CII,
3566: (SELECT UNIT_OF_MEASURE , UOM_CODE ,DISABLE_DATE
3567: FROM MTL_UNITS_OF_MEASURE_TL
3568: WHERE LANGUAGE = USERENV('LANG')) UOM
3569: WHERE CII.Unit_Of_Measure = UOM.uom_code
3570: AND TRUNC(NVL(UOM.disable_date, SYSDATE)) >= TRUNC(SYSDATE)
3571: AND cii.instance_id=p_cust_prod_id;