PJF_UNITS_OF_MEASURE_V

Details

• Schema: FUSION

• Object owner: PJF

• Object type: VIEW

Columns

Name
UOM_CODE UNIT_OF_MEASURE DESCRIPTION ENABLED_FLAG

Query

SQL_Statement

SELECT INV_UOM.UOM_CODE , INV_UOM.UNIT_OF_MEASURE, INV_UOM.DESCRIPTION, CASE WHEN (TRUNC(SYSDATE) < NVL(INV_UOM.DISABLE_DATE,TRUNC(SYSDATE)+1)) THEN 'Y' ELSE 'N' END enabled_flag FROM INV_UNITS_OF_MEASURE_VL INV_UOM UNION ALL SELECT PRJ_UOM.LOOKUP_CODE UOM_CODE, PRJ_UOM.MEANING UNIT_OF_MEASURE , PRJ_UOM.DESCRIPTION DESCRIPTION, CASE WHEN (TRUNC(SYSDATE) BETWEEN PRJ_UOM.start_date_active AND NVL(PRJ_UOM.end_date_active,TRUNC(SYSDATE)) AND (ENABLED_FLAG='Y')) THEN 'Y' ELSE 'N' END enabled_flag FROM FND_LOOKUP_VALUES_VL PRJ_UOM WHERE PRJ_UOM.VIEW_APPLICATION_ID = 0 AND PRJ_UOM.SET_ID = 0 AND LOOKUP_TYPE = 'PJF_UNIT'