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_PRD_DF_PVT dependencies on CSI_CP_COUNTERS_V

Line 419: --SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI,AHL_MR_EFFECTIVITIES_APP_V MRE, AHL_UNIT_EFFECTIVITIES_APP_V UE

415: l_manually_planned_flag VARCHAR2(1);
416:
417: -- to check whether MR or any of its children has resettable counters
418: CURSOR reset_counter_csr(p_unit_effectivity_id IN NUMBER) IS
419: --SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI,AHL_MR_EFFECTIVITIES_APP_V MRE, AHL_UNIT_EFFECTIVITIES_APP_V UE
420: /* In R12, modified to use csi_counters_vl instead of csi_cp_counters_v.
421: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI,AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
422: WHERE CP.customer_product_id = UE.csi_item_instance_id
423: AND CP.counter_name = MRI.counter_name

Line 420: /* In R12, modified to use csi_counters_vl instead of csi_cp_counters_v.

416:
417: -- to check whether MR or any of its children has resettable counters
418: CURSOR reset_counter_csr(p_unit_effectivity_id IN NUMBER) IS
419: --SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI,AHL_MR_EFFECTIVITIES_APP_V MRE, AHL_UNIT_EFFECTIVITIES_APP_V UE
420: /* In R12, modified to use csi_counters_vl instead of csi_cp_counters_v.
421: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI,AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
422: WHERE CP.customer_product_id = UE.csi_item_instance_id
423: AND CP.counter_name = MRI.counter_name
424: AND MRI.reset_value IS NOT NULL

Line 421: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI,AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE

417: -- to check whether MR or any of its children has resettable counters
418: CURSOR reset_counter_csr(p_unit_effectivity_id IN NUMBER) IS
419: --SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI,AHL_MR_EFFECTIVITIES_APP_V MRE, AHL_UNIT_EFFECTIVITIES_APP_V UE
420: /* In R12, modified to use csi_counters_vl instead of csi_cp_counters_v.
421: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI,AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
422: WHERE CP.customer_product_id = UE.csi_item_instance_id
423: AND CP.counter_name = MRI.counter_name
424: AND MRI.reset_value IS NOT NULL
425: AND MRI.mr_effectivity_id = MRE.mr_effectivity_id

Line 429: --SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES_APP_V MRE, AHL_UNIT_EFFECTIVITIES_APP_V UE

425: AND MRI.mr_effectivity_id = MRE.mr_effectivity_id
426: AND MRE.mr_header_id = UE.mr_header_id
427: AND UE.unit_effectivity_id = p_unit_effectivity_id
428: UNION
429: --SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES_APP_V MRE, AHL_UNIT_EFFECTIVITIES_APP_V UE
430: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI,AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
431: WHERE CP.customer_product_id = UE.csi_item_instance_id
432: AND CP.counter_name = MRI.counter_name
433: AND MRI.reset_value IS NOT NULL

Line 430: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI,AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE

426: AND MRE.mr_header_id = UE.mr_header_id
427: AND UE.unit_effectivity_id = p_unit_effectivity_id
428: UNION
429: --SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES_APP_V MRE, AHL_UNIT_EFFECTIVITIES_APP_V UE
430: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI,AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
431: WHERE CP.customer_product_id = UE.csi_item_instance_id
432: AND CP.counter_name = MRI.counter_name
433: AND MRI.reset_value IS NOT NULL
434: AND MRI.mr_effectivity_id = MRE.mr_effectivity_id

Line 1889: --SELECT CO.counter_id FROM CSI_CP_COUNTERS_V CO, AHL_UNIT_EFFECTIVITIES_APP_V UE

1885: p_df_header_rec IN AHL_PRD_DF_PVT.df_header_rec_type,
1886: p_x_df_schedules_tbl IN OUT NOCOPY AHL_PRD_DF_PVT.df_schedules_tbl_type)IS
1887:
1888: CURSOR counter_id_csr(p_counter_name IN VARCHAR2,p_unit_effectivity_id IN NUMBER) IS
1889: --SELECT CO.counter_id FROM CSI_CP_COUNTERS_V CO, AHL_UNIT_EFFECTIVITIES_APP_V UE
1890: SELECT CO.counter_id FROM CSI_CP_COUNTERS_V CO, AHL_UNIT_EFFECTIVITIES_B UE -- Undid App usage BLIND changes
1891: WHERE UPPER(co.counter_name) like UPPER(p_counter_name)
1892: AND co.customer_product_id = ue.csi_item_instance_id
1893: AND UE.unit_effectivity_id = p_unit_effectivity_id;

Line 1890: SELECT CO.counter_id FROM CSI_CP_COUNTERS_V CO, AHL_UNIT_EFFECTIVITIES_B UE -- Undid App usage BLIND changes

1886: p_x_df_schedules_tbl IN OUT NOCOPY AHL_PRD_DF_PVT.df_schedules_tbl_type)IS
1887:
1888: CURSOR counter_id_csr(p_counter_name IN VARCHAR2,p_unit_effectivity_id IN NUMBER) IS
1889: --SELECT CO.counter_id FROM CSI_CP_COUNTERS_V CO, AHL_UNIT_EFFECTIVITIES_APP_V UE
1890: SELECT CO.counter_id FROM CSI_CP_COUNTERS_V CO, AHL_UNIT_EFFECTIVITIES_B UE -- Undid App usage BLIND changes
1891: WHERE UPPER(co.counter_name) like UPPER(p_counter_name)
1892: AND co.customer_product_id = ue.csi_item_instance_id
1893: AND UE.unit_effectivity_id = p_unit_effectivity_id;
1894:

Line 2207: --SELECT 'x' FROM CSI_CP_COUNTERS_V CO, AHL_UNIT_EFFECTIVITIES_APP_V UE,AHL_UNIT_DEFERRALS_B UD

2203: p_df_schedules_tbl IN AHL_PRD_DF_PVT.df_schedules_tbl_type)IS
2204:
2205:
2206: CURSOR valid_counter_csr(p_unit_deferral_id IN NUMBER,p_counter_id IN NUMBER) IS
2207: --SELECT 'x' FROM CSI_CP_COUNTERS_V CO, AHL_UNIT_EFFECTIVITIES_APP_V UE,AHL_UNIT_DEFERRALS_B UD
2208: SELECT 'x' FROM CSI_CP_COUNTERS_V CO, AHL_UNIT_EFFECTIVITIES_B UE,AHL_UNIT_DEFERRALS_B UD -- Undid app usage related blind changes
2209: WHERE co.customer_product_id = ue.csi_item_instance_id
2210: AND co.counter_id = p_counter_id
2211: AND UE.unit_effectivity_id = UD.unit_effectivity_id

Line 2208: SELECT 'x' FROM CSI_CP_COUNTERS_V CO, AHL_UNIT_EFFECTIVITIES_B UE,AHL_UNIT_DEFERRALS_B UD -- Undid app usage related blind changes

2204:
2205:
2206: CURSOR valid_counter_csr(p_unit_deferral_id IN NUMBER,p_counter_id IN NUMBER) IS
2207: --SELECT 'x' FROM CSI_CP_COUNTERS_V CO, AHL_UNIT_EFFECTIVITIES_APP_V UE,AHL_UNIT_DEFERRALS_B UD
2208: SELECT 'x' FROM CSI_CP_COUNTERS_V CO, AHL_UNIT_EFFECTIVITIES_B UE,AHL_UNIT_DEFERRALS_B UD -- Undid app usage related blind changes
2209: WHERE co.customer_product_id = ue.csi_item_instance_id
2210: AND co.counter_id = p_counter_id
2211: AND UE.unit_effectivity_id = UD.unit_effectivity_id
2212: AND UD.unit_deferral_id = p_unit_deferral_id;

Line 2215: SELECT 'x' from ahl_unit_effectivities_b UE, ahl_unit_deferrals_b UD,AHL_MR_INTERVALS_V MR,CSI_CP_COUNTERS_V CO

2211: AND UE.unit_effectivity_id = UD.unit_effectivity_id
2212: AND UD.unit_deferral_id = p_unit_deferral_id;
2213:
2214: /*CURSOR mr_valid_counter_csr(p_unit_deferral_id IN NUMBER,p_counter_id IN NUMBER) IS
2215: SELECT 'x' from ahl_unit_effectivities_b UE, ahl_unit_deferrals_b UD,AHL_MR_INTERVALS_V MR,CSI_CP_COUNTERS_V CO
2216: WHERE UD.unit_deferral_id = p_unit_deferral_id
2217: AND UE.unit_effectivity_id = UD.unit_effectivity_id
2218: AND co.customer_product_id = ue.csi_item_instance_id
2219: AND UE.mr_effectivity_id = MR.mr_effectivity_id

Line 5408: /* In R12, modified to use csi_counters_vl instead of csi_cp_counters_v.

5404: AND VST.unit_effectivity_id = p_unit_effectivity_id;
5405:
5406: -- to check whether MR or any of its children has resettable counters
5407: CURSOR reset_counter_csr(p_unit_effectivity_id IN NUMBER) IS
5408: /* In R12, modified to use csi_counters_vl instead of csi_cp_counters_v.
5409: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
5410: WHERE CP.customer_product_id = UE.csi_item_instance_id
5411: AND CP.counter_name = MRI.counter_name
5412: AND MRI.reset_value IS NOT NULL

Line 5409: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE

5405:
5406: -- to check whether MR or any of its children has resettable counters
5407: CURSOR reset_counter_csr(p_unit_effectivity_id IN NUMBER) IS
5408: /* In R12, modified to use csi_counters_vl instead of csi_cp_counters_v.
5409: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
5410: WHERE CP.customer_product_id = UE.csi_item_instance_id
5411: AND CP.counter_name = MRI.counter_name
5412: AND MRI.reset_value IS NOT NULL
5413: AND MRI.mr_effectivity_id = MRE.mr_effectivity_id

Line 5417: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE

5413: AND MRI.mr_effectivity_id = MRE.mr_effectivity_id
5414: AND MRE.mr_header_id = UE.mr_header_id
5415: AND UE.unit_effectivity_id = p_unit_effectivity_id
5416: UNION
5417: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
5418: WHERE CP.customer_product_id = UE.csi_item_instance_id
5419: AND CP.counter_name = MRI.counter_name
5420: AND MRI.reset_value IS NOT NULL
5421: AND MRI.mr_effectivity_id = MRE.mr_effectivity_id