[Home] [Help]
379: NVL(CCR2.COUNTER_READING,CCR1.COUNTER_READING) as "LASTREADING",
380: fnd_date.date_to_displayDT(Convert_to_client_time(NVL(CCR2.VALUE_TIMESTAMP,CCR1.VALUE_TIMESTAMP))) as "LASTVALUETIMESTAMP",
381: CB.uom_code as "METERUOM",
382: TO_NUMBER(NULL) as "NEWREADING",
383: EAM_METERS_UTIL.IS_METER_READING_MANDATORY_V(p_wip_id, nvl(CBS.COUNTER_ID,CB.COUNTER_ID)) as "MANDATORY" )) Meter
384: FROM csi_counters_b CB,
385: CSI_COUNTERS_TL CTL,
386: CSI_COUNTERS_TL CTL2,
387: CSI_COUNTERS_B CBS,