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_TRANSACTIONS

Line 341: 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

337: CCR.VALUE_TIMESTAMP CURRENT_READING_DATE,
338: CCA.PRIMARY_FAILURE_FLAG,
339: decode(ct.transaction_type_id,92,ct.source_header_ref_id,to_number(null)) WIP_ENTITY_ID,
340: CCB.reading_type METER_TYPE
341: 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
342: and SYSDATE BETWEEN nvl(ccb.start_date_active, SYSDATE-1) AND nvl(ccb.end_date_active, SYSDATE+1)
343: and cctl.language = userenv('|| '''LANG'''|| ') and ccb.counter_type = '||'''REGULAR'''||'
344: AND CCB.COUNTER_ID = CCA.COUNTER_ID
345: AND CCR.COUNTER_ID(+) = CCB.COUNTER_ID

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

685: CCR.VALUE_TIMESTAMP CURRENT_READING_DATE,
686: CCA.PRIMARY_FAILURE_FLAG PRIMARY_FAILURE_METER,
687: decode(ct.transaction_type_id,92,ct.source_header_ref_id,to_number(null)) WIP_ENTITY_ID,
688: CCB.reading_type METER_TYPE
689: FROM csi_counters_b CCB,csi_counters_tl cctl, csi_counter_readings CCR, csi_counter_associations CCA, csi_transactions CT
690: WHERE
691: ccb.counter_id = cctl.counter_id
692: and SYSDATE BETWEEN nvl(ccb.start_date_active, SYSDATE-1) AND nvl(ccb.end_date_active, SYSDATE+1)
693: and cctl.language = userenv('LANG') and ccb.counter_type = 'REGULAR'

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

1131: CCR.VALUE_TIMESTAMP CURRENT_READING_DATE,
1132: CCA.PRIMARY_FAILURE_FLAG PRIMARY_FAILURE_METER,
1133: decode(ct.transaction_type_id,92,ct.source_header_ref_id,to_number(null)) WIP_ENTITY_ID,
1134: CCB.reading_type METER_TYPE
1135: FROM csi_counters_b CCB,csi_counters_tl cctl, csi_counter_readings CCR, csi_counter_associations CCA, csi_transactions CT
1136: WHERE
1137: ccb.counter_id = cctl.counter_id
1138: and SYSDATE BETWEEN nvl(ccb.start_date_active, SYSDATE-1) AND nvl(ccb.end_date_active, SYSDATE+1)
1139: and cctl.language = userenv('LANG') and ccb.counter_type = 'REGULAR'

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

1274: CCR.VALUE_TIMESTAMP CURRENT_READING_DATE,
1275: CCA.PRIMARY_FAILURE_FLAG PRIMARY_FAILURE_METER,
1276: decode(ct.transaction_type_id,92,ct.source_header_ref_id,to_number(null)) WIP_ENTITY_ID,
1277: CCB.reading_type METER_TYPE
1278: FROM csi_counters_b CCB,csi_counters_tl cctl, csi_counter_readings CCR, csi_counter_associations CCA, csi_transactions CT
1279: WHERE
1280: ccb.counter_id = cctl.counter_id
1281: and SYSDATE BETWEEN nvl(ccb.start_date_active, SYSDATE-1) AND nvl(ccb.end_date_active, SYSDATE+1)
1282: and cctl.language = userenv('LANG') and ccb.counter_type = 'REGULAR'

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

2344: CCR.VALUE_TIMESTAMP CURRENT_READING_DATE,
2345: CCA.PRIMARY_FAILURE_FLAG PRIMARY_FAILURE_METER,
2346: decode(ct.transaction_type_id,92,ct.source_header_ref_id,to_number(null)) WIP_ENTITY_ID,
2347: CCB.reading_type METER_TYPE
2348: FROM csi_counters_b CCB,csi_counters_tl cctl, csi_counter_readings CCR, csi_counter_associations CCA, csi_transactions CT
2349: WHERE
2350: ccb.counter_id = cctl.counter_id
2351: and SYSDATE BETWEEN nvl(ccb.start_date_active, SYSDATE-1) AND nvl(ccb.end_date_active, SYSDATE+1)
2352: and cctl.language = userenv('LANG') and ccb.counter_type = 'REGULAR'

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

2787: CCR.VALUE_TIMESTAMP CURRENT_READING_DATE,
2788: CCA.PRIMARY_FAILURE_FLAG,
2789: decode(ct.transaction_type_id,92,ct.source_header_ref_id,to_number(null)) WIP_ENTITY_ID,
2790: CCB.reading_type METER_TYPE
2791: FROM csi_counters_b CCB,csi_counters_tl cctl, csi_counter_readings CCR, csi_counter_associations CCA, csi_transactions CT
2792: WHERE
2793: ccb.counter_id = cctl.counter_id
2794: and SYSDATE BETWEEN nvl(ccb.start_date_active, SYSDATE-1) AND nvl(ccb.end_date_active, SYSDATE+1)
2795: and cctl.language = userenv('LANG') and ccb.counter_type = 'REGULAR'

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

3806: CCR.VALUE_TIMESTAMP CURRENT_READING_DATE,
3807: CCA.PRIMARY_FAILURE_FLAG,
3808: decode(ct.transaction_type_id,92,ct.source_header_ref_id,to_number(null)) WIP_ENTITY_ID,
3809: CCB.reading_type METER_TYPE
3810: FROM csi_counters_b CCB,csi_counters_tl cctl, csi_counter_readings CCR, csi_counter_associations CCA, csi_transactions CT ';
3811: l_sql_stmt2 := 'WHERE ccb.counter_id = cctl.counter_id
3812: and SYSDATE BETWEEN nvl(ccb.start_date_active, SYSDATE-1) AND nvl(ccb.end_date_active, SYSDATE+1)
3813: and cctl.language = userenv('|| '''LANG'''|| ') and ccb.counter_type = '||'''REGULAR'''||'
3814: AND CCB.COUNTER_ID = CCA.COUNTER_ID