APPS.AHL_PRD_DF_PVT dependencies on AHL_UE_RELATIONSHIPS

Line 433: FROM AHL_UE_RELATIONSHIPS

429: AND UE.unit_effectivity_id IN
430: (
431:
432: SELECT related_ue_id
433: FROM AHL_UE_RELATIONSHIPS
434: WHERE relationship_code = 'PARENT'
435: START WITH ue_id = p_unit_effectivity_id
436: CONNECT BY ue_id = PRIOR related_ue_id
437:

Line 464: FROM AHL_UE_RELATIONSHIPS

460: AND UE.unit_effectivity_id IN
461: (
462:
463: SELECT related_ue_id
464: FROM AHL_UE_RELATIONSHIPS
465: WHERE relationship_code = 'PARENT'
466: START WITH ue_id = p_unit_effectivity_id
467: CONNECT BY ue_id = PRIOR related_ue_id
468:

Line 951: from ahl_ue_relationships

947: IS
948: SELECT cii.serial_number
949: FROM ahl_unit_effectivities_b ue, csi_item_instances cii
950: WHERE unit_effectivity_id in (select originator_ue_id
951: from ahl_ue_relationships
952: where related_ue_id = p_ue_id)
953: AND ue.csi_item_instance_id = cii.instance_id
954: AND cii.quantity > 1
955: AND ue.object_type = 'SR';

Line 3098: FROM AHL_UE_RELATIONSHIPS

3094: WHERE unit_effectivity_id IN
3095: (
3096:
3097: /*SELECT ue_id
3098: FROM AHL_UE_RELATIONSHIPS
3099: WHERE relationship_code = 'PARENT'
3100: START WITH related_ue_id = p_unit_effectivity_id
3101: CONNECT BY related_ue_id = PRIOR ue_id
3102: UNION*/--parents are taken care of by now

Line 3104: FROM AHL_UE_RELATIONSHIPS

3100: START WITH related_ue_id = p_unit_effectivity_id
3101: CONNECT BY related_ue_id = PRIOR ue_id
3102: UNION*/--parents are taken care of by now
3103: SELECT distinct related_ue_id
3104: FROM AHL_UE_RELATIONSHIPS
3105: WHERE relationship_code = 'PARENT'
3106: START WITH ue_id = p_unit_effectivity_id
3107: CONNECT BY ue_id = PRIOR related_ue_id
3108: );

Line 3756: FROM AHL_UE_RELATIONSHIPS

3752: AND UE.unit_effectivity_id IN
3753: (
3754:
3755: SELECT distinct related_ue_id
3756: FROM AHL_UE_RELATIONSHIPS
3757: WHERE relationship_code = 'PARENT'
3758: START WITH ue_id = p_unit_effectivity_id
3759: CONNECT BY ue_id = PRIOR related_ue_id
3760: );

Line 4315: FROM AHL_UE_RELATIONSHIPS

4311: WHERE unit_effectivity_id IN
4312: (
4313:
4314: SELECT distinct related_ue_id
4315: FROM AHL_UE_RELATIONSHIPS
4316: WHERE relationship_code = 'PARENT'
4317: START WITH ue_id = p_unit_effectivity_id
4318: CONNECT BY ue_id = PRIOR related_ue_id
4319: );

Line 4327: FROM AHL_UE_RELATIONSHIPS

4323: l_new_unit_effectivity_id NUMBER;
4324:
4325: CURSOR ue_relns_csr(p_unit_effectivity_id IN NUMBER)IS
4326: SELECT distinct ue_id, related_ue_id, originator_ue_id
4327: FROM AHL_UE_RELATIONSHIPS
4328: WHERE relationship_code = 'PARENT'
4329: START WITH ue_id = p_unit_effectivity_id
4330: CONNECT BY ue_id = PRIOR related_ue_id;
4331:

Line 4670: -- Insert into ahl_ue_relationships.

4666: END LOOP;
4667: -- create tree here
4668: IF (l_ue_relns_tbl.count > 0 AND p_new_status = 'DEFERRED')THEN
4669: FOR k IN l_ue_relns_tbl.FIRST..l_ue_relns_tbl.LAST LOOP
4670: -- Insert into ahl_ue_relationships.
4671: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(
4672: X_UE_RELATIONSHIP_ID => l_ue_relationship_id,
4673: X_UE_ID => l_ue_relns_tbl(k).ue_id,
4674: X_RELATED_UE_ID => l_ue_relns_tbl(k).related_ue_id,

Line 4671: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(

4667: -- create tree here
4668: IF (l_ue_relns_tbl.count > 0 AND p_new_status = 'DEFERRED')THEN
4669: FOR k IN l_ue_relns_tbl.FIRST..l_ue_relns_tbl.LAST LOOP
4670: -- Insert into ahl_ue_relationships.
4671: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(
4672: X_UE_RELATIONSHIP_ID => l_ue_relationship_id,
4673: X_UE_ID => l_ue_relns_tbl(k).ue_id,
4674: X_RELATED_UE_ID => l_ue_relns_tbl(k).related_ue_id,
4675: X_RELATIONSHIP_CODE => 'PARENT',

Line 4802: FROM AHL_UE_RELATIONSHIPS

4798: WHERE defer_from_ue_id IS NOT NULL
4799: --AND NOT EXISTS (Select 'x' from ahl_visit_tasks_b VST where VST.unit_effectivity_id = UE.unit_effectivity_id)
4800: AND defer_from_ue_id IN (
4801: SELECT related_ue_id
4802: FROM AHL_UE_RELATIONSHIPS
4803: WHERE relationship_code = 'PARENT'
4804: START WITH ue_id = p_unit_effectivity_id
4805: CONNECT BY ue_id = PRIOR related_ue_id
4806: );

Line 4815: SELECT ue_relationship_id FROM AHL_UE_RELATIONSHIPS

4811:
4812: l_exists VARCHAR2(1);
4813:
4814: CURSOR ue_rel_id_csr(p_unit_effectivity_id IN NUMBER) IS
4815: SELECT ue_relationship_id FROM AHL_UE_RELATIONSHIPS
4816: WHERE relationship_code = 'PARENT'
4817: AND related_ue_id = p_unit_effectivity_id;
4818:
4819: l_ue_relationship_id NUMBER;

Line 4843: FROM AHL_UE_RELATIONSHIPS

4839: SELECT UD.unit_deferral_id FROM ahl_unit_deferrals_b UD
4840: WHERE UD.unit_deferral_type = 'DEFERRAL'
4841: AND UD.unit_effectivity_id IN (
4842: SELECT related_ue_id
4843: FROM AHL_UE_RELATIONSHIPS
4844: WHERE relationship_code = 'PARENT'
4845: START WITH ue_id = p_unit_effectivity_id
4846: CONNECT BY ue_id = PRIOR related_ue_id
4847: )

Line 4887: AHL_UE_RELATIONSHIPS_PKG.delete_row(l_ue_relationship_id);

4883: AHL_UNIT_EFFECTIVITIES_PKG.delete_row(ue_id_rec.unit_effectivity_id);
4884: OPEN ue_rel_id_csr(ue_id_rec.unit_effectivity_id);
4885: FETCH ue_rel_id_csr INTO l_ue_relationship_id;
4886: IF(ue_rel_id_csr%FOUND) THEN
4887: AHL_UE_RELATIONSHIPS_PKG.delete_row(l_ue_relationship_id);
4888: END IF;
4889: CLOSE ue_rel_id_csr;
4890: ELSE -- assigned to visit -- mark as exception
4891: FOR ue_rec IN unit_effectivity_csr(ue_id_rec.unit_effectivity_id) LOOP

Line 5044: FROM AHL_UE_RELATIONSHIPS

5040: AND UE.unit_effectivity_id IN
5041: (
5042:
5043: SELECT related_ue_id
5044: FROM AHL_UE_RELATIONSHIPS
5045: WHERE relationship_code = 'PARENT'
5046: START WITH ue_id = p_unit_effectivity_id
5047: CONNECT BY ue_id = PRIOR related_ue_id
5048:

Line 5076: FROM AHL_UE_RELATIONSHIPS

5072: AND UE.unit_effectivity_id IN
5073: (
5074:
5075: SELECT related_ue_id
5076: FROM AHL_UE_RELATIONSHIPS
5077: WHERE relationship_code = 'PARENT'
5078: START WITH ue_id = p_unit_effectivity_id
5079: CONNECT BY ue_id = PRIOR related_ue_id
5080: