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 412: --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

408: l_manually_planned_flag VARCHAR2(1);
409:
410: -- to check whether MR or any of its children has resettable counters
411: CURSOR reset_counter_csr(p_unit_effectivity_id IN NUMBER) IS
412: --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
413: /* In R12, modified to use csi_counters_vl instead of csi_cp_counters_v.
414: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI,AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
415: WHERE CP.customer_product_id = UE.csi_item_instance_id
416: AND CP.counter_name = MRI.counter_name

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

409:
410: -- to check whether MR or any of its children has resettable counters
411: CURSOR reset_counter_csr(p_unit_effectivity_id IN NUMBER) IS
412: --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
413: /* In R12, modified to use csi_counters_vl instead of csi_cp_counters_v.
414: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI,AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
415: WHERE CP.customer_product_id = UE.csi_item_instance_id
416: AND CP.counter_name = MRI.counter_name
417: AND MRI.reset_value IS NOT NULL

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

410: -- to check whether MR or any of its children has resettable counters
411: CURSOR reset_counter_csr(p_unit_effectivity_id IN NUMBER) IS
412: --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
413: /* In R12, modified to use csi_counters_vl instead of csi_cp_counters_v.
414: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI,AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
415: WHERE CP.customer_product_id = UE.csi_item_instance_id
416: AND CP.counter_name = MRI.counter_name
417: AND MRI.reset_value IS NOT NULL
418: AND MRI.mr_effectivity_id = MRE.mr_effectivity_id

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

418: AND MRI.mr_effectivity_id = MRE.mr_effectivity_id
419: AND MRE.mr_header_id = UE.mr_header_id
420: AND UE.unit_effectivity_id = p_unit_effectivity_id
421: UNION
422: --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
423: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI,AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
424: WHERE CP.customer_product_id = UE.csi_item_instance_id
425: AND CP.counter_name = MRI.counter_name
426: AND MRI.reset_value IS NOT NULL

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

419: AND MRE.mr_header_id = UE.mr_header_id
420: AND UE.unit_effectivity_id = p_unit_effectivity_id
421: UNION
422: --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
423: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI,AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
424: WHERE CP.customer_product_id = UE.csi_item_instance_id
425: AND CP.counter_name = MRI.counter_name
426: AND MRI.reset_value IS NOT NULL
427: AND MRI.mr_effectivity_id = MRE.mr_effectivity_id

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

1822: p_df_header_rec IN AHL_PRD_DF_PVT.df_header_rec_type,
1823: p_x_df_schedules_tbl IN OUT NOCOPY AHL_PRD_DF_PVT.df_schedules_tbl_type)IS
1824:
1825: CURSOR counter_id_csr(p_counter_name IN VARCHAR2,p_unit_effectivity_id IN NUMBER) IS
1826: --SELECT CO.counter_id FROM CSI_CP_COUNTERS_V CO, AHL_UNIT_EFFECTIVITIES_APP_V UE
1827: SELECT CO.counter_id FROM CSI_CP_COUNTERS_V CO, AHL_UNIT_EFFECTIVITIES_B UE -- Undid App usage BLIND changes
1828: WHERE UPPER(co.counter_name) like UPPER(p_counter_name)
1829: AND co.customer_product_id = ue.csi_item_instance_id
1830: AND UE.unit_effectivity_id = p_unit_effectivity_id;

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

1823: p_x_df_schedules_tbl IN OUT NOCOPY AHL_PRD_DF_PVT.df_schedules_tbl_type)IS
1824:
1825: CURSOR counter_id_csr(p_counter_name IN VARCHAR2,p_unit_effectivity_id IN NUMBER) IS
1826: --SELECT CO.counter_id FROM CSI_CP_COUNTERS_V CO, AHL_UNIT_EFFECTIVITIES_APP_V UE
1827: SELECT CO.counter_id FROM CSI_CP_COUNTERS_V CO, AHL_UNIT_EFFECTIVITIES_B UE -- Undid App usage BLIND changes
1828: WHERE UPPER(co.counter_name) like UPPER(p_counter_name)
1829: AND co.customer_product_id = ue.csi_item_instance_id
1830: AND UE.unit_effectivity_id = p_unit_effectivity_id;
1831:

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

2140: p_df_schedules_tbl IN AHL_PRD_DF_PVT.df_schedules_tbl_type)IS
2141:
2142:
2143: CURSOR valid_counter_csr(p_unit_deferral_id IN NUMBER,p_counter_id IN NUMBER) IS
2144: --SELECT 'x' FROM CSI_CP_COUNTERS_V CO, AHL_UNIT_EFFECTIVITIES_APP_V UE,AHL_UNIT_DEFERRALS_B UD
2145: SELECT 'x' FROM CSI_CP_COUNTERS_V CO, AHL_UNIT_EFFECTIVITIES_B UE,AHL_UNIT_DEFERRALS_B UD -- Undid app usage related blind changes
2146: WHERE co.customer_product_id = ue.csi_item_instance_id
2147: AND co.counter_id = p_counter_id
2148: AND UE.unit_effectivity_id = UD.unit_effectivity_id

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

2141:
2142:
2143: CURSOR valid_counter_csr(p_unit_deferral_id IN NUMBER,p_counter_id IN NUMBER) IS
2144: --SELECT 'x' FROM CSI_CP_COUNTERS_V CO, AHL_UNIT_EFFECTIVITIES_APP_V UE,AHL_UNIT_DEFERRALS_B UD
2145: SELECT 'x' FROM CSI_CP_COUNTERS_V CO, AHL_UNIT_EFFECTIVITIES_B UE,AHL_UNIT_DEFERRALS_B UD -- Undid app usage related blind changes
2146: WHERE co.customer_product_id = ue.csi_item_instance_id
2147: AND co.counter_id = p_counter_id
2148: AND UE.unit_effectivity_id = UD.unit_effectivity_id
2149: AND UD.unit_deferral_id = p_unit_deferral_id;

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

2148: AND UE.unit_effectivity_id = UD.unit_effectivity_id
2149: AND UD.unit_deferral_id = p_unit_deferral_id;
2150:
2151: /*CURSOR mr_valid_counter_csr(p_unit_deferral_id IN NUMBER,p_counter_id IN NUMBER) IS
2152: SELECT 'x' from ahl_unit_effectivities_b UE, ahl_unit_deferrals_b UD,AHL_MR_INTERVALS_V MR,CSI_CP_COUNTERS_V CO
2153: WHERE UD.unit_deferral_id = p_unit_deferral_id
2154: AND UE.unit_effectivity_id = UD.unit_effectivity_id
2155: AND co.customer_product_id = ue.csi_item_instance_id
2156: AND UE.mr_effectivity_id = MR.mr_effectivity_id

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

5021: AND VST.unit_effectivity_id = p_unit_effectivity_id;
5022:
5023: -- to check whether MR or any of its children has resettable counters
5024: CURSOR reset_counter_csr(p_unit_effectivity_id IN NUMBER) IS
5025: /* In R12, modified to use csi_counters_vl instead of csi_cp_counters_v.
5026: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
5027: WHERE CP.customer_product_id = UE.csi_item_instance_id
5028: AND CP.counter_name = MRI.counter_name
5029: AND MRI.reset_value IS NOT NULL

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

5022:
5023: -- to check whether MR or any of its children has resettable counters
5024: CURSOR reset_counter_csr(p_unit_effectivity_id IN NUMBER) IS
5025: /* In R12, modified to use csi_counters_vl instead of csi_cp_counters_v.
5026: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
5027: WHERE CP.customer_product_id = UE.csi_item_instance_id
5028: AND CP.counter_name = MRI.counter_name
5029: AND MRI.reset_value IS NOT NULL
5030: AND MRI.mr_effectivity_id = MRE.mr_effectivity_id

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

5030: AND MRI.mr_effectivity_id = MRE.mr_effectivity_id
5031: AND MRE.mr_header_id = UE.mr_header_id
5032: AND UE.unit_effectivity_id = p_unit_effectivity_id
5033: UNION
5034: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
5035: WHERE CP.customer_product_id = UE.csi_item_instance_id
5036: AND CP.counter_name = MRI.counter_name
5037: AND MRI.reset_value IS NOT NULL
5038: AND MRI.mr_effectivity_id = MRE.mr_effectivity_id