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_UE_RELATIONSHIPS

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 2860: FROM ahl_ue_relationships uer, ahl_unit_effectivities_b ue1

2856: AND ue.mr_header_id = p_mr_header_id
2857: AND ue.status_code IS NULL
2858: AND ue.manually_planned_flag = 'Y'
2859: AND NOT EXISTS (SELECT 'x'
2860: FROM ahl_ue_relationships uer, ahl_unit_effectivities_b ue1
2861: WHERE uer.related_ue_id = ue.unit_effectivity_id
2862: AND uer.originator_ue_id = ue1.unit_effectivity_id
2863: AND ue1.object_type = 'SR');
2864: -- Do not pick MRs associated to a SR.

Line 6130: FROM ahl_ue_relationships relns

6126:
6127: -- for reading unit effectivity table.
6128: CURSOR ahl_ue_relns_csr ( p_unit_effectivity_id IN NUMBER, p_level IN NUMBER ) IS
6129: SELECT ue_id, related_ue_id
6130: FROM ahl_ue_relationships relns
6131: WHERE level = p_level
6132: START WITH ue_id = p_unit_effectivity_id AND
6133: relationship_code = 'PARENT'
6134: CONNECT BY PRIOR related_ue_id = ue_id AND

Line 8586: FROM ahl_ue_relationships

8582: AND status_code IS NULL
8583: --AND defer_from_ue_id IS NOT NULL -- not required as joining table ahl_unit_deferrals_b
8584: AND UDF.unit_deferral_type IN ('DEFERRAL', 'MEL','CDL')
8585: AND NOT EXISTS (SELECT 'x'
8586: FROM ahl_ue_relationships
8587: WHERE related_ue_id = UE.unit_effectivity_id
8588: AND relationship_code = 'PARENT')
8589: AND UDF.approval_status_code = 'DEFERRED'
8590: ORDER BY DEFERRAL_EFFECTIVE_ON ASC;

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 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 9312: FROM ahl_ue_relationships

9308:
9309: -- Get all child UE's for a given unit effectivity.
9310: CURSOR ahl_ue_relns_csr (p_unit_effectivity_id IN NUMBER) IS
9311: SELECT related_ue_id, ue_id, level
9312: FROM ahl_ue_relationships
9313: START WITH ue_id = p_unit_effectivity_id
9314: AND relationship_code = 'PARENT'
9315: CONNECT BY PRIOR related_ue_id = ue_id
9316: AND relationship_code = 'PARENT'

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 9481: FROM ahl_ue_relationships uer, ahl_unit_effectivities_b ue1

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' )
9485: */

Line 9488: FROM ahl_ue_relationships uer

9484: ue1.object_type <> 'SR' )
9485: */
9486: -- pick up only top nodes.
9487: WHERE NOT EXISTS (SELECT 'x'
9488: FROM ahl_ue_relationships uer
9489: WHERE uer.related_ue_id = ue.unit_effectivity_id
9490: AND relationship_code = 'PARENT')
9491: AND ue.csi_item_instance_id = p_csi_item_instance_id
9492: AND nvl(ue.manually_planned_flag,'N') = 'Y'

Line 9563: -- Read group from ahl_ue_relationships.

9559: FROM ahl_unit_effectivities_vl
9560: WHERE unit_effectivity_id = p_unit_effectivity_id
9561: FOR UPDATE OF message_code NOWAIT;
9562:
9563: -- Read group from ahl_ue_relationships.
9564: CURSOR decendent_csr (p_unit_effectivity_id IN NUMBER) IS
9565: SELECT related_ue_id
9566: FROM ahl_ue_relationships
9567: WHERE relationship_code = 'PARENT' AND

Line 9566: FROM ahl_ue_relationships

9562:
9563: -- Read group from ahl_ue_relationships.
9564: CURSOR decendent_csr (p_unit_effectivity_id IN NUMBER) IS
9565: SELECT related_ue_id
9566: FROM ahl_ue_relationships
9567: WHERE relationship_code = 'PARENT' AND
9568: originator_ue_id = p_unit_effectivity_id;
9569:
9570: l_exception_flag BOOLEAN;