APPS.EAM_WORKORDERREP_PVT dependencies on CSI_COUNTER_READINGS

Line 406: CSI_COUNTER_READINGS CCR1,

402: FROM csi_counters_b CB,
403: CSI_COUNTERS_TL CTL,
404: CSI_COUNTERS_TL CTL2,
405: CSI_COUNTERS_B CBS,
406: CSI_COUNTER_READINGS CCR1,
407: CSI_COUNTER_READINGS CCR2,
408: csi_item_instances cii,
409: wip_discrete_jobs wdj,
410: (

Line 407: CSI_COUNTER_READINGS CCR2,

403: CSI_COUNTERS_TL CTL,
404: CSI_COUNTERS_TL CTL2,
405: CSI_COUNTERS_B CBS,
406: CSI_COUNTER_READINGS CCR1,
407: CSI_COUNTER_READINGS CCR2,
408: csi_item_instances cii,
409: wip_discrete_jobs wdj,
410: (
411: SELECT

Line 446: FROM CSI_COUNTER_READINGS B

442: CCR1.VALUE_TIMESTAMP =
443: (
444: SELECT
445: MAX(VALUE_TIMESTAMP)
446: FROM CSI_COUNTER_READINGS B
447: WHERE CCR1.COUNTER_ID=B.COUNTER_ID
448: AND B.DISABLED_FLAG='N'
449: GROUP BY COUNTER_ID
450: )

Line 455: FROM CSI_COUNTER_READINGS B

451: OR NOT EXISTS
452: (
453: SELECT
454: COUNTER_ID
455: FROM CSI_COUNTER_READINGS B
456: WHERE CB.COUNTER_ID=B.COUNTER_ID
457: AND B.DISABLED_FLAG='N'
458: )
459: )

Line 467: FROM CSI_COUNTER_READINGS B

463: CCR2.VALUE_TIMESTAMP =
464: (
465: SELECT
466: MAX(VALUE_TIMESTAMP)
467: FROM CSI_COUNTER_READINGS B
468: WHERE CCR2.COUNTER_ID=B.COUNTER_ID
469: AND B.DISABLED_FLAG='N'
470: GROUP BY COUNTER_ID
471: )

Line 476: FROM CSI_COUNTER_READINGS B

472: OR NOT EXISTS
473: (
474: SELECT
475: COUNTER_ID
476: FROM CSI_COUNTER_READINGS B
477: WHERE CBS.COUNTER_ID=B.COUNTER_ID
478: AND B.DISABLED_FLAG='N'
479: )
480: )