eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_FAILURE_ANALYSIS_PVT dependencies on CSI_COUNTERS_B

Line 348: FROM csi_counters_b CCB,csi_counters_tl cctl, csi_counter_readings CCR, csi_counter_associations CCA, csi_transactions CT WHERE ccb.counter_id = cctl.counter_id

344: CCR.VALUE_TIMESTAMP CURRENT_READING_DATE,
345: CCA.PRIMARY_FAILURE_FLAG,
346: decode(ct.transaction_type_id,92,ct.source_header_ref_id,to_number(null)) WIP_ENTITY_ID,
347: CCB.reading_type METER_TYPE
348: FROM csi_counters_b CCB,csi_counters_tl cctl, csi_counter_readings CCR, csi_counter_associations CCA, csi_transactions CT WHERE ccb.counter_id = cctl.counter_id
349: and SYSDATE BETWEEN nvl(ccb.start_date_active, SYSDATE-1) AND nvl(ccb.end_date_active, SYSDATE+1)
350: and cctl.language = userenv('|| '''LANG'''|| ') and ccb.counter_type = '||'''REGULAR'''||'
351: AND CCB.COUNTER_ID = CCA.COUNTER_ID
352: AND CCR.COUNTER_ID(+) = CCB.COUNTER_ID

Line 697: FROM csi_counters_b CCB,csi_counters_tl cctl, csi_counter_readings CCR, csi_counter_associations CCA, csi_transactions CT

693: CCR.VALUE_TIMESTAMP CURRENT_READING_DATE,
694: CCA.PRIMARY_FAILURE_FLAG PRIMARY_FAILURE_METER,
695: decode(ct.transaction_type_id,92,ct.source_header_ref_id,to_number(null)) WIP_ENTITY_ID,
696: CCB.reading_type METER_TYPE
697: FROM csi_counters_b CCB,csi_counters_tl cctl, csi_counter_readings CCR, csi_counter_associations CCA, csi_transactions CT
698: WHERE
699: ccb.counter_id = cctl.counter_id
700: and SYSDATE BETWEEN nvl(ccb.start_date_active, SYSDATE-1) AND nvl(ccb.end_date_active, SYSDATE+1)
701: and cctl.language = userenv('LANG') and ccb.counter_type = 'REGULAR'

Line 1145: FROM csi_counters_b CCB,csi_counters_tl cctl, csi_counter_readings CCR, csi_counter_associations CCA, csi_transactions CT

1141: CCR.VALUE_TIMESTAMP CURRENT_READING_DATE,
1142: CCA.PRIMARY_FAILURE_FLAG PRIMARY_FAILURE_METER,
1143: decode(ct.transaction_type_id,92,ct.source_header_ref_id,to_number(null)) WIP_ENTITY_ID,
1144: CCB.reading_type METER_TYPE
1145: FROM csi_counters_b CCB,csi_counters_tl cctl, csi_counter_readings CCR, csi_counter_associations CCA, csi_transactions CT
1146: WHERE
1147: ccb.counter_id = cctl.counter_id
1148: and SYSDATE BETWEEN nvl(ccb.start_date_active, SYSDATE-1) AND nvl(ccb.end_date_active, SYSDATE+1)
1149: and cctl.language = userenv('LANG') and ccb.counter_type = 'REGULAR'

Line 1290: FROM csi_counters_b CCB,csi_counters_tl cctl, csi_counter_readings CCR, csi_counter_associations CCA, csi_transactions CT

1286: CCR.VALUE_TIMESTAMP CURRENT_READING_DATE,
1287: CCA.PRIMARY_FAILURE_FLAG PRIMARY_FAILURE_METER,
1288: decode(ct.transaction_type_id,92,ct.source_header_ref_id,to_number(null)) WIP_ENTITY_ID,
1289: CCB.reading_type METER_TYPE
1290: FROM csi_counters_b CCB,csi_counters_tl cctl, csi_counter_readings CCR, csi_counter_associations CCA, csi_transactions CT
1291: WHERE
1292: ccb.counter_id = cctl.counter_id
1293: and SYSDATE BETWEEN nvl(ccb.start_date_active, SYSDATE-1) AND nvl(ccb.end_date_active, SYSDATE+1)
1294: and cctl.language = userenv('LANG') and ccb.counter_type = 'REGULAR'

Line 2552: FROM csi_counters_b CCB,csi_counters_tl cctl, csi_counter_readings CCR, csi_counter_associations CCA, csi_transactions CT

2548: CCR.VALUE_TIMESTAMP CURRENT_READING_DATE,
2549: CCA.PRIMARY_FAILURE_FLAG PRIMARY_FAILURE_METER,
2550: decode(ct.transaction_type_id,92,ct.source_header_ref_id,to_number(null)) WIP_ENTITY_ID,
2551: CCB.reading_type METER_TYPE
2552: FROM csi_counters_b CCB,csi_counters_tl cctl, csi_counter_readings CCR, csi_counter_associations CCA, csi_transactions CT
2553: WHERE
2554: ccb.counter_id = cctl.counter_id
2555: and SYSDATE BETWEEN nvl(ccb.start_date_active, SYSDATE-1) AND nvl(ccb.end_date_active, SYSDATE+1)
2556: and cctl.language = userenv('LANG') and ccb.counter_type = 'REGULAR'

Line 2764: FROM csi_counters_b CCB,csi_counters_tl cctl, csi_counter_readings CCR, csi_counter_associations CCA, csi_transactions CT

2760: CCR.VALUE_TIMESTAMP CURRENT_READING_DATE,
2761: CCA.PRIMARY_FAILURE_FLAG PRIMARY_FAILURE_METER,
2762: decode(ct.transaction_type_id,92,ct.source_header_ref_id,to_number(null)) WIP_ENTITY_ID,
2763: CCB.reading_type METER_TYPE
2764: FROM csi_counters_b CCB,csi_counters_tl cctl, csi_counter_readings CCR, csi_counter_associations CCA, csi_transactions CT
2765: WHERE
2766: ccb.counter_id = cctl.counter_id
2767: and SYSDATE BETWEEN nvl(ccb.start_date_active, SYSDATE-1) AND nvl(ccb.end_date_active, SYSDATE+1)
2768: and cctl.language = userenv('LANG') and ccb.counter_type = 'REGULAR'

Line 3210: FROM csi_counters_b CCB,csi_counters_tl cctl, csi_counter_readings CCR, csi_counter_associations CCA, csi_transactions CT

3206: CCR.VALUE_TIMESTAMP CURRENT_READING_DATE,
3207: CCA.PRIMARY_FAILURE_FLAG,
3208: decode(ct.transaction_type_id,92,ct.source_header_ref_id,to_number(null)) WIP_ENTITY_ID,
3209: CCB.reading_type METER_TYPE
3210: FROM csi_counters_b CCB,csi_counters_tl cctl, csi_counter_readings CCR, csi_counter_associations CCA, csi_transactions CT
3211: WHERE
3212: ccb.counter_id = cctl.counter_id
3213: and SYSDATE BETWEEN nvl(ccb.start_date_active, SYSDATE-1) AND nvl(ccb.end_date_active, SYSDATE+1)
3214: and cctl.language = userenv('LANG') and ccb.counter_type = 'REGULAR'

Line 3340: FROM csi_counters_b CCB,csi_counters_tl cctl, csi_counter_readings CCR, csi_counter_associations CCA, csi_transactions CT

3336: CCR.VALUE_TIMESTAMP CURRENT_READING_DATE,
3337: CCA.PRIMARY_FAILURE_FLAG,
3338: decode(ct.transaction_type_id,92,ct.source_header_ref_id,to_number(null)) WIP_ENTITY_ID,
3339: CCB.reading_type METER_TYPE
3340: FROM csi_counters_b CCB,csi_counters_tl cctl, csi_counter_readings CCR, csi_counter_associations CCA, csi_transactions CT
3341: WHERE
3342: ccb.counter_id = cctl.counter_id
3343: and SYSDATE BETWEEN nvl(ccb.start_date_active, SYSDATE-1) AND nvl(ccb.end_date_active, SYSDATE+1)
3344: and cctl.language = userenv('LANG') and ccb.counter_type = 'REGULAR'

Line 4486: FROM csi_counters_b CCB,csi_counters_tl cctl, csi_counter_readings CCR, csi_counter_associations CCA, csi_transactions CT ';

4482: CCR.VALUE_TIMESTAMP CURRENT_READING_DATE,
4483: CCA.PRIMARY_FAILURE_FLAG,
4484: decode(ct.transaction_type_id,92,ct.source_header_ref_id,to_number(null)) WIP_ENTITY_ID,
4485: CCB.reading_type METER_TYPE
4486: FROM csi_counters_b CCB,csi_counters_tl cctl, csi_counter_readings CCR, csi_counter_associations CCA, csi_transactions CT ';
4487: l_sql_stmt2 := 'WHERE ccb.counter_id = cctl.counter_id
4488: and SYSDATE BETWEEN nvl(ccb.start_date_active, SYSDATE-1) AND nvl(ccb.end_date_active, SYSDATE+1)
4489: and cctl.language = userenv('|| '''LANG'''|| ') and ccb.counter_type = '||'''REGULAR'''||'
4490: AND CCB.COUNTER_ID = CCA.COUNTER_ID