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.AHL_RA_SETUPS_PVT dependencies on CS_CSI_COUNTER_GROUPS

Line 1186: -- i.e only counter templates, direct reference to cs_csi_counter_groups can be used here.

1182: --Validate CounterId passed
1183: BEGIN
1184: -- Bug 4913954 : Perf Fixes.
1185: -- Since we are using reference to cs_counter_groups with a join condition TEMPLATE_FLAG = 'Y'
1186: -- i.e only counter templates, direct reference to cs_csi_counter_groups can be used here.
1187: SELECT templates.name
1188: INTO l_cou_name
1189: FROM cs_csi_counter_groups cg,
1190: csi_counter_template_vl templates,

Line 1189: FROM cs_csi_counter_groups cg,

1185: -- Since we are using reference to cs_counter_groups with a join condition TEMPLATE_FLAG = 'Y'
1186: -- i.e only counter templates, direct reference to cs_csi_counter_groups can be used here.
1187: SELECT templates.name
1188: INTO l_cou_name
1189: FROM cs_csi_counter_groups cg,
1190: csi_counter_template_vl templates,
1191: csi_ctr_item_associations csia,
1192: ahl_ra_definition_hdr rdh
1193: WHERE templates.counter_id = l_ra_def_dtl_rec.COUNTER_ID

Line 1631: -- i.e only counter templates, direct reference to cs_csi_counter_groups can be used here.

1627: --Validate CounterId passed
1628: BEGIN
1629: -- Bug 4913954 : Perf Fixes.
1630: -- Since we are using reference to cs_counter_groups with a join condition TEMPLATE_FLAG = 'Y'
1631: -- i.e only counter templates, direct reference to cs_csi_counter_groups can be used here.
1632: SELECT templates.name
1633: INTO l_cou_name
1634: FROM cs_csi_counter_groups cg,
1635: csi_counter_template_vl templates,

Line 1634: FROM cs_csi_counter_groups cg,

1630: -- Since we are using reference to cs_counter_groups with a join condition TEMPLATE_FLAG = 'Y'
1631: -- i.e only counter templates, direct reference to cs_csi_counter_groups can be used here.
1632: SELECT templates.name
1633: INTO l_cou_name
1634: FROM cs_csi_counter_groups cg,
1635: csi_counter_template_vl templates,
1636: csi_ctr_item_associations csia,
1637: ahl_ra_definition_hdr rdh
1638: WHERE templates.counter_id = l_ra_def_dtl_rec.COUNTER_ID

Line 2173: -- i.e only counter templates, direct reference to cs_csi_counter_groups can be used here.

2169: --Validate value of the since new counter passed
2170: BEGIN
2171: -- Bug 4913954 : Perf Fixes.
2172: -- Since we are using reference to cs_counter_groups with a join condition TEMPLATE_FLAG = 'Y'
2173: -- i.e only counter templates, direct reference to cs_csi_counter_groups can be used here.
2174: SELECT templates.name,
2175: templates.uom_code
2176: INTO l_new_cou_name,
2177: l_new_cou_uom

Line 2178: FROM cs_csi_counter_groups cg,

2174: SELECT templates.name,
2175: templates.uom_code
2176: INTO l_new_cou_name,
2177: l_new_cou_uom
2178: FROM cs_csi_counter_groups cg,
2179: csi_counter_template_vl templates
2180: WHERE templates.counter_id = l_counter_assoc_rec.SINCE_NEW_COUNTER_ID
2181: AND cg.template_flag = 'Y'
2182: AND templates.group_id = cg.counter_group_id

Line 2207: -- i.e only counter templates, direct reference to cs_csi_counter_groups can be used here.

2203: IF(l_counter_assoc_rec.SINCE_OVERHAUL_COUNTER_ID IS NOT NULL) THEN
2204: BEGIN
2205: -- Bug 4913954 : Perf Fixes.
2206: -- Since we are using reference to cs_counter_groups with a join condition TEMPLATE_FLAG = 'Y'
2207: -- i.e only counter templates, direct reference to cs_csi_counter_groups can be used here.
2208: SELECT templates.name,
2209: templates.uom_code
2210: INTO l_overhaul_cou_name,
2211: l_overhaul_cou_uom

Line 2212: FROM cs_csi_counter_groups cg,

2208: SELECT templates.name,
2209: templates.uom_code
2210: INTO l_overhaul_cou_name,
2211: l_overhaul_cou_uom
2212: FROM cs_csi_counter_groups cg,
2213: csi_counter_template_vl templates
2214: WHERE templates.counter_id = l_counter_assoc_rec.SINCE_OVERHAUL_COUNTER_ID
2215: AND cg.template_flag = 'Y'
2216: AND templates.group_id = cg.counter_group_id