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 AHL_UE_RELATIONSHIPS

Line 440: FROM AHL_UE_RELATIONSHIPS

436: AND UE.unit_effectivity_id IN
437: (
438:
439: SELECT related_ue_id
440: FROM AHL_UE_RELATIONSHIPS
441: WHERE relationship_code = 'PARENT'
442: START WITH ue_id = p_unit_effectivity_id
443: CONNECT BY ue_id = PRIOR related_ue_id
444:

Line 471: FROM AHL_UE_RELATIONSHIPS

467: AND UE.unit_effectivity_id IN
468: (
469:
470: SELECT related_ue_id
471: FROM AHL_UE_RELATIONSHIPS
472: WHERE relationship_code = 'PARENT'
473: START WITH ue_id = p_unit_effectivity_id
474: CONNECT BY ue_id = PRIOR related_ue_id
475:

Line 978: from ahl_ue_relationships

974: IS
975: SELECT cii.serial_number
976: FROM ahl_unit_effectivities_b ue, csi_item_instances cii
977: WHERE unit_effectivity_id in (select originator_ue_id
978: from ahl_ue_relationships
979: where related_ue_id = p_ue_id)
980: AND ue.csi_item_instance_id = cii.instance_id
981: AND cii.quantity > 0
982: AND ue.object_type = 'SR';

Line 3235: FROM AHL_UE_RELATIONSHIPS

3231: WHERE unit_effectivity_id IN
3232: (
3233:
3234: /*SELECT ue_id
3235: FROM AHL_UE_RELATIONSHIPS
3236: WHERE relationship_code = 'PARENT'
3237: START WITH related_ue_id = p_unit_effectivity_id
3238: CONNECT BY related_ue_id = PRIOR ue_id
3239: UNION*/--parents are taken care of by now

Line 3241: FROM AHL_UE_RELATIONSHIPS

3237: START WITH related_ue_id = p_unit_effectivity_id
3238: CONNECT BY related_ue_id = PRIOR ue_id
3239: UNION*/--parents are taken care of by now
3240: SELECT distinct related_ue_id
3241: FROM AHL_UE_RELATIONSHIPS
3242: WHERE relationship_code = 'PARENT'
3243: START WITH ue_id = p_unit_effectivity_id
3244: CONNECT BY ue_id = PRIOR related_ue_id
3245: );

Line 3912: FROM AHL_UE_RELATIONSHIPS

3908: AND UE.unit_effectivity_id IN
3909: (
3910:
3911: SELECT distinct related_ue_id
3912: FROM AHL_UE_RELATIONSHIPS
3913: WHERE relationship_code = 'PARENT'
3914: START WITH ue_id = p_unit_effectivity_id
3915: CONNECT BY ue_id = PRIOR related_ue_id
3916: );

Line 4475: FROM AHL_UE_RELATIONSHIPS

4471: WHERE unit_effectivity_id IN
4472: (
4473:
4474: SELECT distinct related_ue_id
4475: FROM AHL_UE_RELATIONSHIPS
4476: WHERE relationship_code = 'PARENT'
4477: START WITH ue_id = p_unit_effectivity_id
4478: CONNECT BY ue_id = PRIOR related_ue_id
4479: );

Line 4497: FROM AHL_UE_RELATIONSHIPS

4493: l_DATE_RUN DATE;
4494:
4495: CURSOR ue_relns_csr(p_unit_effectivity_id IN NUMBER)IS
4496: SELECT distinct ue_id, related_ue_id, originator_ue_id
4497: FROM AHL_UE_RELATIONSHIPS
4498: WHERE relationship_code = 'PARENT'
4499: START WITH ue_id = p_unit_effectivity_id
4500: CONNECT BY ue_id = PRIOR related_ue_id;
4501:

Line 4560: FROM AHL_UE_RELATIONSHIPS

4556: l_deferral_type VARCHAR2(3);
4557:
4558: CURSOR immediate_child_check_csr(p_root_ue_id IN NUMBER,p_child_ue_id IN NUMBER)IS
4559: SELECT 'x'
4560: FROM AHL_UE_RELATIONSHIPS
4561: WHERE related_ue_id = p_child_ue_id
4562: AND relationship_code = 'PARENT'
4563: AND ue_id = p_root_ue_id;
4564:

Line 5040: -- Insert into ahl_ue_relationships.

5036: -- create tree here
5037: IF (l_ue_relns_tbl.count > 0 AND (p_new_status = 'DEFERRED' OR (l_deferral_type = 'MR' AND l_manually_planned_flag = G_NO_FLAG AND p_new_status = 'CANCELLED')
5038: OR (l_deferral_type = 'SR' AND p_new_status = 'CANCELLED' AND l_serial_number IS NOT NULL)))THEN
5039: FOR k IN l_ue_relns_tbl.FIRST..l_ue_relns_tbl.LAST LOOP
5040: -- Insert into ahl_ue_relationships.
5041: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5042: fnd_log.string
5043: (
5044: fnd_log.level_statement,

Line 5049: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(

5045: 'ahl.plsql.AHL_PRD_DF_PVT.process_unit_maint_plan',
5046: 'inserting Relationships :l_ue_relns_tbl.count : ' || l_ue_relns_tbl.count
5047: );
5048: END IF;
5049: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(
5050: X_UE_RELATIONSHIP_ID => l_ue_relationship_id,
5051: X_UE_ID => l_ue_relns_tbl(k).ue_id,
5052: X_RELATED_UE_ID => l_ue_relns_tbl(k).related_ue_id,
5053: X_RELATIONSHIP_CODE => 'PARENT',

Line 5180: FROM AHL_UE_RELATIONSHIPS

5176: WHERE defer_from_ue_id IS NOT NULL
5177: --AND NOT EXISTS (Select 'x' from ahl_visit_tasks_b VST where VST.unit_effectivity_id = UE.unit_effectivity_id)
5178: AND defer_from_ue_id IN (
5179: SELECT related_ue_id
5180: FROM AHL_UE_RELATIONSHIPS
5181: WHERE relationship_code = 'PARENT'
5182: START WITH ue_id = p_unit_effectivity_id
5183: CONNECT BY ue_id = PRIOR related_ue_id
5184: );

Line 5193: SELECT ue_relationship_id FROM AHL_UE_RELATIONSHIPS

5189:
5190: l_exists VARCHAR2(1);
5191:
5192: CURSOR ue_rel_id_csr(p_unit_effectivity_id IN NUMBER) IS
5193: SELECT ue_relationship_id FROM AHL_UE_RELATIONSHIPS
5194: WHERE relationship_code = 'PARENT'
5195: AND related_ue_id = p_unit_effectivity_id;
5196:
5197: l_ue_relationship_id NUMBER;

Line 5221: FROM AHL_UE_RELATIONSHIPS

5217: SELECT UD.unit_deferral_id FROM ahl_unit_deferrals_b UD
5218: WHERE UD.unit_deferral_type = 'DEFERRAL'
5219: AND UD.unit_effectivity_id IN (
5220: SELECT related_ue_id
5221: FROM AHL_UE_RELATIONSHIPS
5222: WHERE relationship_code = 'PARENT'
5223: START WITH ue_id = p_unit_effectivity_id
5224: CONNECT BY ue_id = PRIOR related_ue_id
5225: )

Line 5265: AHL_UE_RELATIONSHIPS_PKG.delete_row(l_ue_relationship_id);

5261: AHL_UNIT_EFFECTIVITIES_PKG.delete_row(ue_id_rec.unit_effectivity_id);
5262: OPEN ue_rel_id_csr(ue_id_rec.unit_effectivity_id);
5263: FETCH ue_rel_id_csr INTO l_ue_relationship_id;
5264: IF(ue_rel_id_csr%FOUND) THEN
5265: AHL_UE_RELATIONSHIPS_PKG.delete_row(l_ue_relationship_id);
5266: END IF;
5267: CLOSE ue_rel_id_csr;
5268: ELSE -- assigned to visit -- mark as exception
5269: FOR ue_rec IN unit_effectivity_csr(ue_id_rec.unit_effectivity_id) LOOP

Line 5427: FROM AHL_UE_RELATIONSHIPS

5423: AND UE.unit_effectivity_id IN
5424: (
5425:
5426: SELECT related_ue_id
5427: FROM AHL_UE_RELATIONSHIPS
5428: WHERE relationship_code = 'PARENT'
5429: START WITH ue_id = p_unit_effectivity_id
5430: CONNECT BY ue_id = PRIOR related_ue_id
5431:

Line 5459: FROM AHL_UE_RELATIONSHIPS

5455: AND UE.unit_effectivity_id IN
5456: (
5457:
5458: SELECT related_ue_id
5459: FROM AHL_UE_RELATIONSHIPS
5460: WHERE relationship_code = 'PARENT'
5461: START WITH ue_id = p_unit_effectivity_id
5462: CONNECT BY ue_id = PRIOR related_ue_id
5463: