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.CSI_COUNTER_TEMPLATE_PVT dependencies on CSI_COUNTERS_B

Line 170: FROM csi_counters_b

166:
167: BEGIN
168: SELECT direction, start_date_active, end_date_active
169: INTO x_direction, x_start_date, x_end_date
170: FROM csi_counters_b
171: WHERE counter_id = p_counter_id;
172:
173: EXCEPTION
174: WHEN no_data_found THEN

Line 2968: FROM csi_counters_bc_v

2964: BEGIN
2965: -- validate all counters
2966: SELECT nvl(type, 'REGULAR'), name
2967: into l_type, l_name
2968: FROM csi_counters_bc_v
2969: WHERE counter_id = l_ctr_derived_filters_rec.counter_id;
2970:
2971: EXCEPTION
2972: WHEN NO_DATA_FOUND THEN

Line 3131: UPDATE csi_counters_b

3127: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3128: RAISE FND_API.G_EXC_ERROR;
3129: END IF;
3130:
3131: UPDATE csi_counters_b
3132: SET valid_flag = decode(l_valid_flag, 'Y', 'Y', 'N')
3133: WHERE counter_id = l_ctr_derived_filters_rec.COUNTER_ID;
3134:
3135: --l_ctr_derived_filters_rec.OBJECT_VERSION_NUMBER := 1;

Line 5876: FROM csi_counters_bc_v

5872: BEGIN
5873: -- validate all counters
5874: SELECT NVL(type, 'REGULAR'), name
5875: INTO l_type, l_name
5876: FROM csi_counters_bc_v
5877: WHERE counter_id = p_ctr_derived_filters_tbl(tab_row).counter_id;
5878: EXCEPTION WHEN NO_DATA_FOUND THEN
5879: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_API_CTR_INVALID');
5880: END;

Line 6037: UPDATE csi_counters_b

6033: WHERE counter_id = p_ctr_derived_filters_tbl(tab_row).COUNTER_ID;
6034: csi_ctr_gen_utility_pvt.put_line('after updating csi_counters_vl');
6035: EXCEPTION
6036: WHEN NO_DATA_FOUND THEN
6037: UPDATE csi_counters_b
6038: SET valid_flag = decode(l_valid_flag, 'Y', 'Y', 'N')
6039: WHERE counter_id = p_ctr_derived_filters_tbl(tab_row).COUNTER_ID;
6040: csi_ctr_gen_utility_pvt.put_line('after updating csi_counters_vl');
6041: END;

Line 7182: FROM csi_counters_b

7178:
7179: -- Bug 9068223 Fixing in both R12 and 12.1 code
7180: /*SELECT max(counter_id)
7181: INTO l_new_derive_counter_id
7182: FROM csi_counters_b
7183: WHERE created_from_counter_tmpl_id = ctr_cur_rec.derive_counter_id;*/
7184:
7185: -- To fetch the maximum counter id
7186: SELECT counter_id INTO l_new_derive_counter_id FROM

Line 7188: FROM csi_counters_b

7184:
7185: -- To fetch the maximum counter id
7186: SELECT counter_id INTO l_new_derive_counter_id FROM
7187: (SELECT counter_id
7188: FROM csi_counters_b
7189: WHERE created_from_counter_tmpl_id = ctr_cur_rec.derive_counter_id
7190: ORDER BY counter_id DESC)
7191: WHERE ROWNUM = 1;
7192:

Line 7594: FROM csi_counters_b

7590: LOOP
7591: -- Bug 9068223 Fixing in both R12 and 12.1 code
7592: /*SELECT max(counter_id)
7593: INTO l_new_mapped_ctr_id
7594: FROM csi_counters_b
7595: WHERE created_from_counter_tmpl_id = ctr_formula_bvars_cur_rec.source_counter_id;*/
7596:
7597: -- To fetch the maximum counter id
7598: SELECT counter_id INTO l_new_mapped_ctr_id FROM

Line 7600: FROM csi_counters_b

7596:
7597: -- To fetch the maximum counter id
7598: SELECT counter_id INTO l_new_mapped_ctr_id FROM
7599: (SELECT counter_id
7600: FROM csi_counters_b
7601: WHERE created_from_counter_tmpl_id = ctr_formula_bvars_cur_rec.source_counter_id
7602: ORDER BY counter_id DESC)
7603: WHERE ROWNUM = 1;
7604:

Line 8202: FROM csi_counters_b

8198: BEGIN
8199: -- Bug 9068223 Fixing in both R12 and 12.1 code
8200: /*SELECT max(counter_id)
8201: INTO l_new_derive_counter_id
8202: FROM csi_counters_b
8203: WHERE created_from_counter_tmpl_id = ctr_cur_rec.derive_counter_id;*/
8204:
8205: -- To fetch the maximum counter id
8206: SELECT counter_id INTO l_new_derive_counter_id FROM

Line 8208: FROM csi_counters_b

8204:
8205: -- To fetch the maximum counter id
8206: SELECT counter_id INTO l_new_derive_counter_id FROM
8207: (SELECT counter_id
8208: FROM csi_counters_b
8209: WHERE created_from_counter_tmpl_id = ctr_cur_rec.derive_counter_id
8210: ORDER BY counter_id DESC)
8211: WHERE ROWNUM = 1;
8212:

Line 8480: FROM csi_counters_b

8476: csi_ctr_gen_utility_pvt.put_line('Created from ctr id = '||to_char(fmla_ctr_cur_rec.counter_id));
8477: BEGIN
8478: SELECT created_from_counter_tmpl_id
8479: INTO l_created_map_id
8480: FROM csi_counters_b
8481: WHERE counter_id = fmla_ctr_cur_rec.counter_id;
8482: EXCEPTION
8483: WHEN OTHERS THEN NULL;
8484: END;

Line 8492: --FROM csi_counters_b

8488: LOOP
8489: -- Bug 9068223 Fixing in both R12 and 12.1 code
8490: --SELECT max(counter_id)
8491: --INTO l_new_mapped_ctr_id
8492: --FROM csi_counters_b
8493: --WHERE created_from_counter_tmpl_id = ctr_formula_bvars_cur_rec.source_counter_id;
8494: -- AND group_id = l_ctr_grp_rec.counter_group_id;
8495:
8496: -- To fetch the maximum counter id

Line 8501: FROM csi_counters_b

8497: -- Bug 9864058 Fixing in both R12 and 12.1 code
8498:
8499: SELECT counter_id INTO l_new_mapped_ctr_id FROM
8500: (SELECT counter_id
8501: FROM csi_counters_b
8502: WHERE created_from_counter_tmpl_id = ctr_formula_bvars_cur_rec.source_counter_id
8503: AND group_id = l_ctr_grp_rec.counter_group_id
8504: ORDER BY counter_id DESC)
8505: WHERE ROWNUM = 1;

Line 8709: FROM csi_counters_b

8705: AND inventory_item_id = p_inv_id;
8706:
8707: CURSOR check_counters(p_counter_id NUMBER) IS
8708: SELECT counter_id instantiated_counter_id
8709: FROM csi_counters_b
8710: WHERE created_from_counter_tmpl_id = p_counter_id;
8711: BEGIN
8712: -- Standard Start of API savepoint
8713: SAVEPOINT delete_item_association_pvt;