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_EXTN_PVT dependencies on AHL_TEMP_UNIT_EFFECTIVITIES

Line 35: PROCEDURE create_record (p_x_temp_mr_rec IN OUT NOCOPY ahl_temp_unit_effectivities%ROWTYPE);

31: -- Declare Local Procedures --
32: ------------------------------
33:
34: -- To create ahl_unit_effectivities record.
35: PROCEDURE create_record (p_x_temp_mr_rec IN OUT NOCOPY ahl_temp_unit_effectivities%ROWTYPE);
36:
37:
38: -- To update ahl_unit_effectivities record.
39: PROCEDURE update_record (p_temp_mr_rec IN ahl_temp_unit_effectivities%ROWTYPE,

Line 39: PROCEDURE update_record (p_temp_mr_rec IN ahl_temp_unit_effectivities%ROWTYPE,

35: PROCEDURE create_record (p_x_temp_mr_rec IN OUT NOCOPY ahl_temp_unit_effectivities%ROWTYPE);
36:
37:
38: -- To update ahl_unit_effectivities record.
39: PROCEDURE update_record (p_temp_mr_rec IN ahl_temp_unit_effectivities%ROWTYPE,
40: p_mr_rec IN ahl_unit_effectivities_app_v%ROWTYPE);
41:
42: -- To create decendent records and build relationships if the MR is a group MR.
43: PROCEDURE create_group (p_x_temp_grp_rec IN OUT NOCOPY ahl_temp_unit_effectivities%ROWTYPE);

Line 43: PROCEDURE create_group (p_x_temp_grp_rec IN OUT NOCOPY ahl_temp_unit_effectivities%ROWTYPE);

39: PROCEDURE update_record (p_temp_mr_rec IN ahl_temp_unit_effectivities%ROWTYPE,
40: p_mr_rec IN ahl_unit_effectivities_app_v%ROWTYPE);
41:
42: -- To create decendent records and build relationships if the MR is a group MR.
43: PROCEDURE create_group (p_x_temp_grp_rec IN OUT NOCOPY ahl_temp_unit_effectivities%ROWTYPE);
44:
45: -- To update decendent records and update relationships if the MR is a group MR.
46: PROCEDURE update_group (p_temp_mr_rec IN ahl_temp_unit_effectivities%ROWTYPE,
47: p_mr_rec IN ahl_unit_effectivities_app_v%ROWTYPE);

Line 46: PROCEDURE update_group (p_temp_mr_rec IN ahl_temp_unit_effectivities%ROWTYPE,

42: -- To create decendent records and build relationships if the MR is a group MR.
43: PROCEDURE create_group (p_x_temp_grp_rec IN OUT NOCOPY ahl_temp_unit_effectivities%ROWTYPE);
44:
45: -- To update decendent records and update relationships if the MR is a group MR.
46: PROCEDURE update_group (p_temp_mr_rec IN ahl_temp_unit_effectivities%ROWTYPE,
47: p_mr_rec IN ahl_unit_effectivities_app_v%ROWTYPE);
48:
49: -- Process deferral and SR records.
50: -- Added for 11.5.10.

Line 75: -- To flush the unit effectivities created in the temporary table (ahl_temp_unit_effectivities)

71: ------------------------------
72: -- Define Procedures --
73: ------------------------------
74:
75: -- To flush the unit effectivities created in the temporary table (ahl_temp_unit_effectivities)
76: -- by AHL_UMP_PROCESSUNIT_PVT.Process_Unit into ahl_unit_effectivities and ahl_ue_relationships.
77: -- JKJain, NR Analysis and Forecasting
78: PROCEDURE Flush_From_Temp_table (p_config_node_tbl IN AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type,
79: p_uc_header_id IN NUMBER)

Line 112: FROM ahl_temp_unit_effectivities

108: -- added for SB Enh
109: accomplish_trigger_type,
110: loop_chain_seq_num,
111: start_lc_ue_id
112: FROM ahl_temp_unit_effectivities
113: WHERE MR_header_id = nvl(orig_mr_header_id, mr_header_id) AND
114: csi_item_instance_id = nvl(orig_csi_item_instance_id,csi_item_instance_id)
115: AND nvl(accomplish_trigger_type,'X') NOT IN ('LOOP', 'CHAIN')
116: ORDER by forecast_sequence ASC

Line 123: FROM ahl_temp_unit_effectivities tmp_ue

119: -- Cursor for getting all temp unit effectivities that have preceding MRs.
120: CURSOR dependent_mr_csr IS
121: SELECT preceding_mr_header_id, preceding_csi_item_instance_id,
122: preceding_forecast_seq, unit_effectivity_id
123: FROM ahl_temp_unit_effectivities tmp_ue
124: WHERE preceding_mr_header_id IS NOT NULL AND
125: preceding_csi_item_instance_id IS NOT NULL AND
126: preceding_forecast_seq IS NOT NULL
127: -- added for SB Enh: last accomplishment of MR is available in applicable mrs table.

Line 141: FROM ahl_temp_unit_effectivities atu

137: p_preceding_item_instance IN NUMBER,
138: p_preceding_forecast_seq IN NUMBER) IS
139: SELECT unit_effectivity_id FROM (
140: SELECT atu.unit_effectivity_id unit_effectivity_id, atu.due_date
141: FROM ahl_temp_unit_effectivities atu
142: --WHERE atu.mr_header_id = p_preceding_mr_header_id AND
143: WHERE atu.mr_header_id IN (select mr1.mr_header_id from ahl_mr_headers_b mr1
144: where mr1.title = (select mr2.title from ahl_mr_headers_b mr2
145: where mr2.mr_header_id = p_preceding_mr_header_id)

Line 330: l_temp_mr_rec ahl_temp_unit_effectivities%ROWTYPE;

326: l_start_time DATE;
327:
328: l_temp_individual_mr_rec temp_individual_mrs_csr%ROWTYPE;
329:
330: l_temp_mr_rec ahl_temp_unit_effectivities%ROWTYPE;
331: l_mr_rec ahl_unit_effectivities_app_v%ROWTYPE;
332:
333: l_temp_mr_found BOOLEAN;
334: l_mr_found BOOLEAN;

Line 720: UPDATE ahl_temp_unit_effectivities

716: ELSE
717:
718: create_record(l_temp_mr_rec);
719: -- update unit effectivity ID.
720: UPDATE ahl_temp_unit_effectivities
721: SET unit_effectivity_id = l_temp_mr_rec.unit_effectivity_id
722: WHERE CURRENT OF temp_individual_mrs_csr;
723: END IF;
724: END IF;

Line 901: /* moved processing to before ahl_temp_unit_effectivities to fix bug# 9078331

897: END;
898: END LOOP;
899: END IF;
900:
901: /* moved processing to before ahl_temp_unit_effectivities to fix bug# 9078331
902: * to calculate repetitive_mr_flag.
903: -- Process deferral and SR records.
904: Flush_Unit_SR_Deferrals;
905: */

Line 1328: PROCEDURE create_record (p_x_temp_mr_rec IN OUT NOCOPY ahl_temp_unit_effectivities%ROWTYPE)

1324:
1325: -----------------------------------------------------------------------------
1326: -- To create ahl_unit_effectivities record.
1327:
1328: PROCEDURE create_record (p_x_temp_mr_rec IN OUT NOCOPY ahl_temp_unit_effectivities%ROWTYPE)
1329:
1330: IS
1331: l_unit_effectivity_id NUMBER;
1332: l_rowid VARCHAR2(30);

Line 1434: PROCEDURE update_record (p_temp_mr_rec IN ahl_temp_unit_effectivities%ROWTYPE,

1430:
1431: -----------------------------------------------------------------------------
1432: -- To update ahl_unit_effectivities record.
1433:
1434: PROCEDURE update_record (p_temp_mr_rec IN ahl_temp_unit_effectivities%ROWTYPE,
1435: p_mr_rec IN ahl_unit_effectivities_app_v%ROWTYPE)
1436: IS
1437:
1438: BEGIN

Line 1536: PROCEDURE create_group (p_x_temp_grp_rec IN OUT NOCOPY ahl_temp_unit_effectivities%ROWTYPE)

1532:
1533: -----------------------------------------------------------------------------
1534: -- To create decendent records and build relationships if the MR is a group MR.
1535:
1536: PROCEDURE create_group (p_x_temp_grp_rec IN OUT NOCOPY ahl_temp_unit_effectivities%ROWTYPE)
1537:
1538: IS
1539: -- Read group elements.
1540: CURSOR ahl_temp_grp_csr(p_csi_item_instance_id IN NUMBER,

Line 1562: FROM ahl_temp_unit_effectivities

1558: earliest_due_date,
1559: latest_due_date,
1560: counter_id,
1561: rowid
1562: FROM ahl_temp_unit_effectivities
1563: START WITH parent_csi_item_instance_id = p_csi_item_instance_id
1564: AND parent_mr_header_id = p_mr_header_id
1565: AND orig_csi_item_instance_id = p_csi_item_instance_id
1566: AND orig_mr_header_id = p_mr_header_id

Line 1584: FROM ahl_temp_unit_effectivities

1580: p_orig_csi_item_instance_id IN NUMBER,
1581: p_orig_mr_header_id IN NUMBER,
1582: p_forecast_sequence IN NUMBER) IS
1583: SELECT unit_effectivity_id
1584: FROM ahl_temp_unit_effectivities
1585: WHERE csi_item_instance_id = p_parent_csi_item_instance_id
1586: AND MR_header_id = p_parent_mr_header_id
1587: AND orig_csi_item_instance_id = p_orig_csi_item_instance_id
1588: AND orig_mr_header_id = p_orig_mr_header_id

Line 1599: l_temp_child_rec ahl_temp_unit_effectivities%ROWTYPE;

1595: l_orig_mr_header_id NUMBER;
1596:
1597: l_parent_ue_id NUMBER;
1598:
1599: l_temp_child_rec ahl_temp_unit_effectivities%ROWTYPE;
1600:
1601: BEGIN
1602:
1603: IF G_DEBUG = 'Y' THEN

Line 1611: -- Update ahl_temp_unit_effectivities with the unit effectivity id.

1607:
1608: -- For top node.
1609: Create_Record (p_x_temp_grp_rec);
1610:
1611: -- Update ahl_temp_unit_effectivities with the unit effectivity id.
1612: UPDATE ahl_temp_unit_effectivities
1613: SET unit_effectivity_id = p_x_temp_grp_rec.unit_effectivity_id
1614: WHERE csi_item_instance_id = p_x_temp_grp_rec.csi_item_instance_id AND
1615: mr_header_id = p_x_temp_grp_rec.mr_header_id AND

Line 1612: UPDATE ahl_temp_unit_effectivities

1608: -- For top node.
1609: Create_Record (p_x_temp_grp_rec);
1610:
1611: -- Update ahl_temp_unit_effectivities with the unit effectivity id.
1612: UPDATE ahl_temp_unit_effectivities
1613: SET unit_effectivity_id = p_x_temp_grp_rec.unit_effectivity_id
1614: WHERE csi_item_instance_id = p_x_temp_grp_rec.csi_item_instance_id AND
1615: mr_header_id = p_x_temp_grp_rec.mr_header_id AND
1616: forecast_sequence = p_x_temp_grp_rec.forecast_sequence;

Line 1644: -- Update ahl_temp_unit_effectivities with the unit effectivity id.

1640: l_temp_child_rec.fleet_header_id := p_x_temp_grp_rec.fleet_header_id;
1641: -- Insert into ahl_unit_effectivities.
1642: Create_Record (l_temp_child_rec);
1643:
1644: -- Update ahl_temp_unit_effectivities with the unit effectivity id.
1645: UPDATE ahl_temp_unit_effectivities
1646: SET unit_effectivity_id = l_temp_child_rec.unit_effectivity_id
1647: WHERE rowid = l_temp_grp_rec.rowid;
1648: --WHERE CURRENT OF ahl_temp_grp_csr;

Line 1645: UPDATE ahl_temp_unit_effectivities

1641: -- Insert into ahl_unit_effectivities.
1642: Create_Record (l_temp_child_rec);
1643:
1644: -- Update ahl_temp_unit_effectivities with the unit effectivity id.
1645: UPDATE ahl_temp_unit_effectivities
1646: SET unit_effectivity_id = l_temp_child_rec.unit_effectivity_id
1647: WHERE rowid = l_temp_grp_rec.rowid;
1648: --WHERE CURRENT OF ahl_temp_grp_csr;
1649:

Line 1732: PROCEDURE update_group (p_temp_mr_rec IN ahl_temp_unit_effectivities%ROWTYPE,

1728:
1729: --------------------------------------------------------------------------------
1730: -- To update decendent records and update relationships if the MR is a group MR.
1731:
1732: PROCEDURE update_group (p_temp_mr_rec IN ahl_temp_unit_effectivities%ROWTYPE,
1733: p_mr_rec IN ahl_unit_effectivities_app_v%ROWTYPE)
1734: IS
1735:
1736: -- Read group elements.

Line 1748: FROM ahl_temp_unit_effectivities

1744: parent_mr_header_id,
1745: orig_csi_item_instance_id,
1746: orig_mr_header_id,
1747: forecast_sequence
1748: FROM ahl_temp_unit_effectivities
1749: WHERE level = p_level
1750: START WITH parent_csi_item_instance_id = p_csi_item_instance_id
1751: AND parent_mr_header_id = p_mr_header_id
1752: AND orig_csi_item_instance_id = p_csi_item_instance_id

Line 1874: l_temp_mr_rec ahl_temp_unit_effectivities%ROWTYPE := p_temp_mr_rec;

1870:
1871: i NUMBER;
1872: l_grp_match_flag BOOLEAN;
1873:
1874: l_temp_mr_rec ahl_temp_unit_effectivities%ROWTYPE := p_temp_mr_rec;
1875: l_unit_effectivity_rec ahl_unit_effectivities_app_v%ROWTYPE;
1876:
1877: -- added for bug# 7586838
1878: CURSOR unit_deferral_csr(p_ue_id IN NUMBER) IS

Line 3016: FROM ahl_temp_unit_effectivities tmp_ue, ahl_mr_headers_b mr

3012: tmp_ue.start_mr_header_id,
3013: tmp_ue.start_lc_ue_id,
3014: tmp_ue.rowid,
3015: (select title from ahl_mr_headers_b mr where mr_header_id = tmp_ue.MR_header_id) mr_title
3016: FROM ahl_temp_unit_effectivities tmp_ue, ahl_mr_headers_b mr
3017: WHERE tmp_ue.start_mr_header_id = mr.mr_header_id
3018: AND mr.title = p_mr_title
3019: AND tmp_ue.csi_item_instance_id = p_csi_ii_id
3020: AND tmp_ue.accomplish_trigger_type IN ('LOOP')

Line 3052: FROM ahl_temp_unit_effectivities ue, ahl_mr_headers_b mr

3048: p_csi_ii_id IN NUMBER)
3049:
3050: IS
3051: SELECT ue.unit_effectivity_id
3052: FROM ahl_temp_unit_effectivities ue, ahl_mr_headers_b mr
3053: WHERE ue.start_mr_header_id = mr.mr_header_id
3054: AND mr.title = p_mr_title
3055: AND ue.csi_item_instance_id = p_csi_ii_id
3056: AND ue.accomplish_trigger_type IN ('LOOP')

Line 3064: l_temp_mr_rec ahl_temp_unit_effectivities%ROWTYPE;

3060:
3061: TYPE unitEffectivityTab IS TABLE OF ahl_unit_effectivities_b%ROWTYPE;
3062: l_upd_UE_tbl_records unitEffectivityTab;
3063:
3064: l_temp_mr_rec ahl_temp_unit_effectivities%ROWTYPE;
3065:
3066: l_upd_ue_cnt NUMBER;
3067: l_add_ue_cnt NUMBER;
3068:

Line 3189: UPDATE ahl_temp_unit_effectivities

3185: l_match_tbl(l_old_start_lc_ue_seq) := 'Y';
3186:
3187: l_temp_ue_records(i).UNIT_EFFECTIVITY_ID := l_old_start_lc_ue_tbl(l_old_start_lc_ue_seq);
3188:
3189: UPDATE ahl_temp_unit_effectivities
3190: SET UNIT_EFFECTIVITY_ID = l_temp_ue_records(i).UNIT_EFFECTIVITY_ID
3191: WHERE rowid = l_temp_ue_records(i).rowid;
3192: END IF;
3193:

Line 3263: UPDATE ahl_temp_unit_effectivities

3259:
3260: Create_Record(l_temp_mr_rec);
3261:
3262: -- update unit effectivity ID.
3263: UPDATE ahl_temp_unit_effectivities
3264: SET unit_effectivity_id = l_temp_mr_rec.unit_effectivity_id
3265: WHERE rowid = l_temp_ue_records(i).rowid;
3266:
3267: -- update start_ic_ue_id based on the generated unit_effectivity_id

Line 3394: FROM ahl_temp_unit_effectivities tmp_ue, ahl_mr_headers_b mr

3390: tmp_ue.start_mr_header_id,
3391: tmp_ue.start_lc_ue_id,
3392: tmp_ue.rowid,
3393: (select title from ahl_mr_headers_b mr where mr_header_id = tmp_ue.MR_header_id) mr_title
3394: FROM ahl_temp_unit_effectivities tmp_ue, ahl_mr_headers_b mr
3395: WHERE tmp_ue.start_mr_header_id = mr.mr_header_id
3396: AND mr.title = p_mr_title
3397: AND tmp_ue.csi_item_instance_id = p_csi_ii_id
3398: AND tmp_ue.accomplish_trigger_type IN ('CHAIN')

Line 3434: FROM ahl_temp_unit_effectivities ue, ahl_mr_headers_b mr

3430:
3431: IS
3432: /*
3433: SELECT ue.unit_effectivity_id
3434: FROM ahl_temp_unit_effectivities ue, ahl_mr_headers_b mr
3435: WHERE ue.start_mr_header_id = mr.mr_header_id
3436: AND mr.title = p_mr_title
3437: AND ue.csi_item_instance_id = p_csi_ii_id
3438: AND ue.start_lc_ue_id = p_start_lc_ue_id

Line 3454: from ahl_temp_unit_effectivities ue,ahl_mr_headers_b mr

3450:
3451: CURSOR get_start_ue_id (p_mr_title IN VARCHAR2,
3452: p_csi_ii_id IN NUMBER) IS
3453: select distinct start_lc_ue_id
3454: from ahl_temp_unit_effectivities ue,ahl_mr_headers_b mr
3455: WHERE ue.start_mr_header_id = mr.mr_header_id
3456: AND mr.title = p_mr_title
3457: AND ue.csi_item_instance_id = p_csi_ii_id
3458: AND ue.accomplish_trigger_type IN ('CHAIN');

Line 3464: l_temp_mr_rec ahl_temp_unit_effectivities%ROWTYPE;

3460:
3461: TYPE unitEffectivityTab IS TABLE OF ahl_unit_effectivities_b%ROWTYPE;
3462: l_upd_UE_tbl_records unitEffectivityTab;
3463:
3464: l_temp_mr_rec ahl_temp_unit_effectivities%ROWTYPE;
3465:
3466: l_upd_ue_cnt NUMBER;
3467: l_add_ue_cnt NUMBER;
3468:

Line 3590: UPDATE ahl_temp_unit_effectivities

3586: l_match_tbl(l_old_start_lc_ue_seq) := 'Y';
3587:
3588: l_temp_ue_records(i).UNIT_EFFECTIVITY_ID := l_old_start_lc_ue_tbl(l_old_start_lc_ue_seq);
3589:
3590: UPDATE ahl_temp_unit_effectivities
3591: SET UNIT_EFFECTIVITY_ID = l_temp_ue_records(i).UNIT_EFFECTIVITY_ID
3592: WHERE rowid = l_temp_ue_records(i).rowid;
3593: END IF;
3594:

Line 3664: UPDATE ahl_temp_unit_effectivities

3660:
3661: Create_Record(l_temp_mr_rec);
3662:
3663: -- update unit effectivity ID.
3664: UPDATE ahl_temp_unit_effectivities
3665: SET unit_effectivity_id = l_temp_mr_rec.unit_effectivity_id
3666: WHERE rowid = l_temp_ue_records(i).rowid;
3667:
3668: -- update start_ic_ue_id based on the generated unit_effectivity_id

Line 3813: FROM ahl_temp_unit_effectivities

3809: earliest_due_date,
3810: latest_due_date,
3811: counter_id,
3812: fleet_header_id
3813: FROM ahl_temp_unit_effectivities
3814: WHERE mr_header_id = nvl(orig_mr_header_id, mr_header_id) AND
3815: csi_item_instance_id = nvl(orig_csi_item_instance_id,csi_item_instance_id)
3816: ORDER by forecast_sequence ASC
3817: FOR UPDATE OF unit_effectivity_id;

Line 4001: UPDATE ahl_temp_unit_effectivities

3997: ELSE /* not a group */
3998: --Insert new record in sim ue table
3999: Create_sim_ue_record(p_x_temp_sim_ue_rec => l_temp_sim_ue_rec);
4000:
4001: UPDATE ahl_temp_unit_effectivities
4002: SET unit_effectivity_id = l_temp_sim_ue_rec.SIMULATION_UE_ID
4003: WHERE CURRENT OF temp_individual_mrs_csr;
4004:
4005: END IF;

Line 4238: FROM ahl_temp_unit_effectivities

4234: message_code,
4235: earliest_due_date,
4236: latest_due_date,
4237: counter_id
4238: FROM ahl_temp_unit_effectivities
4239: START WITH parent_csi_item_instance_id = p_csi_item_instance_id
4240: AND parent_mr_header_id = p_mr_header_id
4241: AND orig_csi_item_instance_id = p_csi_item_instance_id
4242: AND orig_mr_header_id = p_mr_header_id

Line 4260: FROM ahl_temp_unit_effectivities

4256: p_orig_csi_item_instance_id IN NUMBER,
4257: p_orig_mr_header_id IN NUMBER,
4258: p_forecast_sequence IN NUMBER) IS
4259: SELECT unit_effectivity_id
4260: FROM ahl_temp_unit_effectivities
4261: WHERE csi_item_instance_id = p_parent_csi_item_instance_id
4262: AND MR_header_id = p_parent_mr_header_id
4263: AND orig_csi_item_instance_id = p_orig_csi_item_instance_id
4264: AND orig_mr_header_id = p_orig_mr_header_id

Line 4289: -- Update ahl_temp_unit_effectivities with the unit effectivity id.

4285:
4286: -- For top node.
4287: create_sim_ue_record (p_x_temp_sim_ue_rec);
4288:
4289: -- Update ahl_temp_unit_effectivities with the unit effectivity id.
4290: UPDATE ahl_temp_unit_effectivities
4291: SET unit_effectivity_id = p_x_temp_sim_ue_rec.simulation_ue_id
4292: WHERE csi_item_instance_id = p_x_temp_sim_ue_rec.csi_item_instance_id AND
4293: mr_header_id = p_x_temp_sim_ue_rec.mr_header_id AND

Line 4290: UPDATE ahl_temp_unit_effectivities

4286: -- For top node.
4287: create_sim_ue_record (p_x_temp_sim_ue_rec);
4288:
4289: -- Update ahl_temp_unit_effectivities with the unit effectivity id.
4290: UPDATE ahl_temp_unit_effectivities
4291: SET unit_effectivity_id = p_x_temp_sim_ue_rec.simulation_ue_id
4292: WHERE csi_item_instance_id = p_x_temp_sim_ue_rec.csi_item_instance_id AND
4293: mr_header_id = p_x_temp_sim_ue_rec.mr_header_id AND
4294: forecast_sequence = p_x_temp_sim_ue_rec.forecast_sequence;

Line 4360: -- Update ahl_temp_unit_effectivities with the sim unit effectivity id.

4356:
4357: -- Insert into AHL_UE_SIMULATIONS
4358: create_sim_ue_record (l_temp_child_rec);
4359:
4360: -- Update ahl_temp_unit_effectivities with the sim unit effectivity id.
4361: UPDATE ahl_temp_unit_effectivities
4362: SET unit_effectivity_id = l_temp_child_rec.simulation_ue_id
4363: WHERE CURRENT OF ahl_temp_grp_csr;
4364:

Line 4361: UPDATE ahl_temp_unit_effectivities

4357: -- Insert into AHL_UE_SIMULATIONS
4358: create_sim_ue_record (l_temp_child_rec);
4359:
4360: -- Update ahl_temp_unit_effectivities with the sim unit effectivity id.
4361: UPDATE ahl_temp_unit_effectivities
4362: SET unit_effectivity_id = l_temp_child_rec.simulation_ue_id
4363: WHERE CURRENT OF ahl_temp_grp_csr;
4364:
4365: