APPS.EAM_WORKORDERREP_PVT dependencies on CSI_COUNTER_READINGS

Line 388: CSI_COUNTER_READINGS CCR1,

384: FROM csi_counters_b CB,
385: CSI_COUNTERS_TL CTL,
386: CSI_COUNTERS_TL CTL2,
387: CSI_COUNTERS_B CBS,
388: CSI_COUNTER_READINGS CCR1,
389: CSI_COUNTER_READINGS CCR2,
390: csi_item_instances cii,
391: wip_discrete_jobs wdj,
392: (

Line 389: CSI_COUNTER_READINGS CCR2,

385: CSI_COUNTERS_TL CTL,
386: CSI_COUNTERS_TL CTL2,
387: CSI_COUNTERS_B CBS,
388: CSI_COUNTER_READINGS CCR1,
389: CSI_COUNTER_READINGS CCR2,
390: csi_item_instances cii,
391: wip_discrete_jobs wdj,
392: (
393: SELECT

Line 428: FROM CSI_COUNTER_READINGS B

424: CCR1.VALUE_TIMESTAMP =
425: (
426: SELECT
427: MAX(VALUE_TIMESTAMP)
428: FROM CSI_COUNTER_READINGS B
429: WHERE CCR1.COUNTER_ID=B.COUNTER_ID
430: AND B.DISABLED_FLAG='N'
431: GROUP BY COUNTER_ID
432: )

Line 437: FROM CSI_COUNTER_READINGS B

433: OR NOT EXISTS
434: (
435: SELECT
436: COUNTER_ID
437: FROM CSI_COUNTER_READINGS B
438: WHERE CB.COUNTER_ID=B.COUNTER_ID
439: AND B.DISABLED_FLAG='N'
440: )
441: )

Line 449: FROM CSI_COUNTER_READINGS B

445: CCR2.VALUE_TIMESTAMP =
446: (
447: SELECT
448: MAX(VALUE_TIMESTAMP)
449: FROM CSI_COUNTER_READINGS B
450: WHERE CCR2.COUNTER_ID=B.COUNTER_ID
451: AND B.DISABLED_FLAG='N'
452: GROUP BY COUNTER_ID
453: )

Line 458: FROM CSI_COUNTER_READINGS B

454: OR NOT EXISTS
455: (
456: SELECT
457: COUNTER_ID
458: FROM CSI_COUNTER_READINGS B
459: WHERE CBS.COUNTER_ID=B.COUNTER_ID
460: AND B.DISABLED_FLAG='N'
461: )
462: )