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.

[Home] [Help]

APPS.AHL_COMPLETIONS_PVT dependencies on CSI_COUNTER_ASSOCIATIONS

Line 2084: FROM csi_counter_associations CCA, csi_counters_vl CTR

2080: --CTR.type type
2081: CTR.COUNTER_TYPE type
2082: --FROM CSI_CP_COUNTERS_V CTR
2083: --WHERE CTR.customer_product_id = c_item_instance_id
2084: FROM csi_counter_associations CCA, csi_counters_vl CTR
2085: WHERE CCA.counter_id = CTR.counter_id
2086: AND CCA.source_object_id = c_item_instance_id
2087: AND CCA.source_object_code = 'CP'
2088: ORDER BY CTR.counter_id;

Line 2233: FROM csi_counter_associations CCA, csi_counters_vl CTR, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES MRE

2229: --NVL(CTR.net_reading, 0) net_reading,
2230: CTR.COUNTER_TYPE type,
2231: MRI.reset_value reset_value
2232: --FROM CSI_CP_COUNTERS_V CTR, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES MRE
2233: FROM csi_counter_associations CCA, csi_counters_vl CTR, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES MRE
2234: WHERE CCA.counter_id = CTR.counter_id
2235: AND CCA.source_object_id = c_item_instance_id
2236: AND CCA.source_object_code = 'CP'
2237: --AND CTR.counter_name = MRI.counter_name