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_UMP_PROCESSUNIT_PVT dependencies on AHL_UNIT_EFFECTIVITIES_APP_V

Line 1923: FROM AHL_UNIT_EFFECTIVITIES_APP_V

1919:
1920: /*
1921: CURSOR ahl_unit_effectivities_csr (p_csi_item_instance_id IN NUMBER) IS
1922: SELECT UNIT_EFFECTIVITY_ID
1923: FROM AHL_UNIT_EFFECTIVITIES_APP_V
1924: WHERE csi_item_instance_id = p_csi_item_instance_id
1925: AND (status_code IS NULL OR status_code = 'INIT-DUE')
1926: FOR UPDATE OF object_version_number NOWAIT;
1927: */

Line 1935: FROM AHL_UNIT_EFFECTIVITIES_APP_V

1931: -- 13 Jul 08: Modified query to use status_code instead of object_version_number
1932: CURSOR ahl_unit_effectivities_csr (p_csi_item_instance_id IN NUMBER) IS
1933: --SELECT UNIT_EFFECTIVITY_ID
1934: SELECT 1
1935: FROM AHL_UNIT_EFFECTIVITIES_APP_V
1936: WHERE csi_item_instance_id = p_csi_item_instance_id
1937: AND (status_code IS NULL OR status_code IN ('INIT-DUE','EXCEPTION'))
1938: FOR UPDATE OF status_code NOWAIT;
1939: */

Line 1957: FROM AHL_UNIT_EFFECTIVITIES_APP_V UE, II

1953: AND SYSDATE BETWEEN TRUNC(NVL(ACTIVE_START_DATE,SYSDATE))
1954: AND TRUNC(NVL(ACTIVE_END_DATE, SYSDATE+1))
1955: )
1956: SELECT 1
1957: FROM AHL_UNIT_EFFECTIVITIES_APP_V UE, II
1958: WHERE UE.csi_item_instance_id = II.INSTANCE_ID
1959: AND (status_code IS NULL OR status_code IN ('INIT-DUE','EXCEPTION'))
1960: FOR UPDATE OF status_code NOWAIT;
1961:

Line 2545: l_acc_status_code ahl_unit_effectivities_app_v.status_code%TYPE;

2541: -- get the latest deferral.
2542: -- pick only deferrals and not SR related MRs.
2543:
2544: l_acc_unit_effectivity_id NUMBER;
2545: l_acc_status_code ahl_unit_effectivities_app_v.status_code%TYPE;
2546:
2547: l_last_accomplishment_date DATE;
2548: l_last_acc_counter_val_tbl counter_values_tbl_type;
2549: l_due_counter_val_tbl counter_values_tbl_type;

Line 2728: FROM ahl_unit_effectivities_app_v UE, ahl_UE_relationships reln

2724: -- retrieve current unit effectivity records.
2725: CURSOR ahl_unit_effectivity_csr (p_mr_header_id IN NUMBER,
2726: p_csi_item_instance_id IN NUMBER) IS
2727: SELECT ue.unit_effectivity_id, ue.status_code, reln.related_ue_id, reln.originator_ue_id
2728: FROM ahl_unit_effectivities_app_v UE, ahl_UE_relationships reln
2729: WHERE UE.unit_effectivity_id = RELN.RELATED_UE_ID(+)
2730: AND mr_header_id = p_mr_header_id
2731: AND csi_item_instance_id = p_csi_item_instance_id
2732: AND (UE.Status_code IS NULL OR status_code = 'INIT-DUE')

Line 2854: FROM ahl_unit_effectivities_app_v ue

2850: -- Read open Unplanned MRs.
2851: CURSOR ahl_unplanned_MRs_csr(p_item_instance_id IN NUMBER,
2852: p_mr_header_id IN NUMBER) IS
2853: SELECT ue.unit_effectivity_id
2854: FROM ahl_unit_effectivities_app_v ue
2855: WHERE ue.csi_item_instance_id = p_item_instance_id
2856: AND ue.mr_header_id = p_mr_header_id
2857: AND ue.status_code IS NULL
2858: AND ue.manually_planned_flag = 'Y'

Line 3636: FROM ahl_unit_effectivities_app_v ue, ahl_unit_deferrals_vl ud

3632: -- get the unit effectivity record for init-due for this mr and item.
3633: CURSOR ahl_init_due_csr (p_csi_item_instance_id IN NUMBER,
3634: p_mr_header_id IN NUMBER) IS
3635: SELECT ud.set_due_date, ue.unit_effectivity_id, ud.unit_deferral_id
3636: FROM ahl_unit_effectivities_app_v ue, ahl_unit_deferrals_vl ud
3637: WHERE ue.unit_effectivity_id = ud.unit_effectivity_id AND
3638: ud.unit_deferral_type = 'INIT-DUE' AND
3639: ue.csi_item_instance_id = p_csi_item_instance_id AND
3640: ue.mr_header_id = p_mr_header_id AND

Line 6145: --FROM ahl_unit_effectivities_app_v ue1, ahl_unit_effectivities_app_v ue2

6141: p_related_ue_id IN NUMBER ) IS
6142: SELECT ue1.mr_header_id, ue1.csi_item_instance_id,
6143: ue2.mr_header_id related_mr_header_id,
6144: ue2.csi_item_instance_id related_csi_item_instance_id
6145: --FROM ahl_unit_effectivities_app_v ue1, ahl_unit_effectivities_app_v ue2
6146: FROM ahl_unit_effectivities_b ue1, ahl_unit_effectivities_b ue2
6147: WHERE ue1.unit_effectivity_id = p_ue_id AND
6148: ue2.unit_effectivity_id = p_related_ue_id;
6149:

Line 8115: FROM ahl_unit_effectivities_app_v

8111:
8112: -- Get Unit Effectivity details.
8113: CURSOR ahl_unit_effectivity_csr (p_unit_effectivity_id IN NUMBER) IS
8114: SELECT csi_item_instance_id, mr_header_id
8115: FROM ahl_unit_effectivities_app_v
8116: WHERE unit_effectivity_id = p_unit_effectivity_id;
8117:
8118: -- Get MR details.
8119: CURSOR ahl_mr_headers_csr (p_mr_header_id IN NUMBER) IS

Line 8578: FROM ahl_unit_effectivities_app_v UE, ahl_unit_deferrals_b UDF, ahl_mr_headers_b MR

8574: UE.DEFER_FROM_UE_ID,
8575: nvl(MR.whichever_first_code, 'FIRST') whichever_first_code,
8576: UDF.unit_deferral_type, UE.CS_INCIDENT_ID, UDF.DEFERRAL_EFFECTIVE_ON,
8577: UDF.AFFECT_DUE_CALC_FLAG, UDF.SET_DUE_DATE, UDF.unit_deferral_id
8578: FROM ahl_unit_effectivities_app_v UE, ahl_unit_deferrals_b UDF, ahl_mr_headers_b MR
8579: WHERE UE.defer_from_ue_id = UDF.unit_effectivity_id
8580: AND UE.mr_header_id = MR.mr_header_id(+)
8581: AND csi_item_instance_id = p_csi_item_instance_id
8582: AND status_code IS NULL

Line 8640: FROM ahl_ue_relationships uer, ahl_unit_effectivities_app_v ue

8636: -- Read immediate children of the SR.
8637: CURSOR ahl_ue_reln_csr (p_ue_id IN NUMBER) IS
8638: SELECT ue.unit_effectivity_id, ue.status_code,
8639: UE.CSI_ITEM_INSTANCE_ID, UE.MR_HEADER_ID
8640: FROM ahl_ue_relationships uer, ahl_unit_effectivities_app_v ue
8641: WHERE ue.unit_effectivity_id = uer.related_ue_id
8642: AND uer.ue_id = p_ue_id;
8643:
8644: --

Line 8661: l_calc_tolerance_flag ahl_unit_effectivities_app_v.tolerance_flag%TYPE;

8657: l_return_val BOOLEAN;
8658:
8659: l_calc_due_date DATE;
8660: l_calc_counter_id NUMBER;
8661: l_calc_tolerance_flag ahl_unit_effectivities_app_v.tolerance_flag%TYPE;
8662: l_calc_message_code ahl_unit_effectivities_app_v.message_code%TYPE;
8663: l_calc_due_counter_value NUMBER;
8664:
8665: l_visit_start_date DATE;

Line 8662: l_calc_message_code ahl_unit_effectivities_app_v.message_code%TYPE;

8658:
8659: l_calc_due_date DATE;
8660: l_calc_counter_id NUMBER;
8661: l_calc_tolerance_flag ahl_unit_effectivities_app_v.tolerance_flag%TYPE;
8662: l_calc_message_code ahl_unit_effectivities_app_v.message_code%TYPE;
8663: l_calc_due_counter_value NUMBER;
8664:
8665: l_visit_start_date DATE;
8666: l_visit_end_date DATE;

Line 9091: FROM ahl_unit_effectivities_app_v UE

9087: UE.MR_HEADER_ID,
9088: UE.STATUS_CODE,
9089: UE.DUE_DATE,
9090: UE.DUE_COUNTER_VALUE
9091: FROM ahl_unit_effectivities_app_v UE
9092: WHERE UE.OBJECT_TYPE = 'SR'
9093: AND defer_from_ue_id IS NULL
9094: AND csi_item_instance_id = p_csi_item_instance_id
9095: AND status_code IS NULL;

Line 9124: FROM ahl_ue_relationships uer, ahl_unit_effectivities_app_v ue

9120: -- Read immediate children of the SR.
9121: CURSOR ahl_ue_reln_csr (p_ue_id IN NUMBER) IS
9122: SELECT ue.unit_effectivity_id, ue.status_code,
9123: UE.CSI_ITEM_INSTANCE_ID, UE.MR_HEADER_ID
9124: FROM ahl_ue_relationships uer, ahl_unit_effectivities_app_v ue
9125: WHERE ue.unit_effectivity_id = uer.related_ue_id
9126: AND uer.ue_id = p_ue_id;
9127:
9128:

Line 9129: l_calc_tolerance_flag ahl_unit_effectivities_app_v.tolerance_flag%TYPE;

9125: WHERE ue.unit_effectivity_id = uer.related_ue_id
9126: AND uer.ue_id = p_ue_id;
9127:
9128:
9129: l_calc_tolerance_flag ahl_unit_effectivities_app_v.tolerance_flag%TYPE;
9130: l_calc_message_code ahl_unit_effectivities_app_v.message_code%TYPE;
9131:
9132: l_visit_start_date DATE;
9133: l_visit_end_date DATE;

Line 9130: l_calc_message_code ahl_unit_effectivities_app_v.message_code%TYPE;

9126: AND uer.ue_id = p_ue_id;
9127:
9128:
9129: l_calc_tolerance_flag ahl_unit_effectivities_app_v.tolerance_flag%TYPE;
9130: l_calc_message_code ahl_unit_effectivities_app_v.message_code%TYPE;
9131:
9132: l_visit_start_date DATE;
9133: l_visit_end_date DATE;
9134: l_visit_assign_code fnd_lookups.lookup_code%TYPE;

Line 9477: FROM ahl_unit_effectivities_app_v ue

9473: SELECT ue.mr_header_id,
9474: ue.csi_item_instance_id,
9475: ue.unit_effectivity_id,
9476: ue.status_code
9477: FROM ahl_unit_effectivities_app_v ue
9478: /*
9479: WHERE NOT EXISTS ( SELECT 'x'
9480: --FROM ahl_ue_relationships uer, ahl_unit_effectivities_app_v ue1
9481: FROM ahl_ue_relationships uer, ahl_unit_effectivities_b ue1

Line 9480: --FROM ahl_ue_relationships uer, ahl_unit_effectivities_app_v ue1

9476: ue.status_code
9477: FROM ahl_unit_effectivities_app_v ue
9478: /*
9479: WHERE NOT EXISTS ( SELECT 'x'
9480: --FROM ahl_ue_relationships uer, ahl_unit_effectivities_app_v ue1
9481: FROM ahl_ue_relationships uer, ahl_unit_effectivities_b ue1
9482: WHERE uer.related_ue_id = ue.unit_effectivity_id AND
9483: uer.originator_ue_id = ue1.unit_effectivity_id AND
9484: ue1.object_type <> 'SR' )

Line 11957: FROM ahl_unit_effectivities_app_v UE

11953: trunc(nvl(parent.active_start_date, sysdate)) <= trunc(sysdate) and
11954: trunc(sysdate) < trunc(nvl(parent.active_end_date, sysdate+1))
11955: ) Root_instance_id
11956:
11957: FROM ahl_unit_effectivities_app_v UE
11958: WHERE UE.mr_header_id = p_mr_header_id
11959: AND (UE.status_code IS NULL OR UE.status_code IN ('INIT-DUE','EXCEPTION'))
11960: AND NOT EXISTS (Select 1
11961: FROM ahl_mr_instances_temp