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 3394: FROM ahl_unit_effectivities_app_v UE, ahl_UE_relationships reln

3390: -- retrieve current unit effectivity records.
3391: CURSOR ahl_unit_effectivity_csr (p_mr_header_id IN NUMBER,
3392: p_csi_item_instance_id IN NUMBER) IS
3393: SELECT ue.unit_effectivity_id, ue.status_code, reln.related_ue_id, reln.originator_ue_id
3394: FROM ahl_unit_effectivities_app_v UE, ahl_UE_relationships reln
3395: WHERE UE.unit_effectivity_id = RELN.RELATED_UE_ID(+)
3396: AND mr_header_id = p_mr_header_id
3397: AND csi_item_instance_id = p_csi_item_instance_id
3398: AND (UE.Status_code IS NULL OR status_code = 'INIT-DUE')

Line 3413: --FROM ahl_unit_effectivities_app_v UE, ahl_UE_relationships reln,

3409: CURSOR ahl_unit_effectivity_csr (p_title IN VARCHAR2,
3410: p_csi_item_instance_id IN NUMBER,
3411: p_appln_usg_code IN VARCHAR2) IS
3412: SELECT ue.unit_effectivity_id, ue.status_code, reln.related_ue_id, reln.originator_ue_id, ue.mr_header_id
3413: --FROM ahl_unit_effectivities_app_v UE, ahl_UE_relationships reln,
3414: FROM ahl_unit_effectivities_b UE, ahl_UE_relationships reln,
3415: ahl_mr_headers_b mr
3416: WHERE UE.unit_effectivity_id = RELN.RELATED_UE_ID(+)
3417: AND UE.mr_header_id = mr.mr_header_id

Line 3414: FROM ahl_unit_effectivities_b UE, ahl_UE_relationships reln,

3410: p_csi_item_instance_id IN NUMBER,
3411: p_appln_usg_code IN VARCHAR2) IS
3412: SELECT ue.unit_effectivity_id, ue.status_code, reln.related_ue_id, reln.originator_ue_id, ue.mr_header_id
3413: --FROM ahl_unit_effectivities_app_v UE, ahl_UE_relationships reln,
3414: FROM ahl_unit_effectivities_b UE, ahl_UE_relationships reln,
3415: ahl_mr_headers_b mr
3416: WHERE UE.unit_effectivity_id = RELN.RELATED_UE_ID(+)
3417: AND UE.mr_header_id = mr.mr_header_id
3418: AND mr.mr_header_id IN (select mr1.mr_header_id from ahl_mr_headers_b mr1 where mr1.title = p_title)

Line 3577: FROM ahl_ue_relationships uer, ahl_unit_effectivities_b ue1

3573: AND ue.mr_header_id IN (select amh.mr_header_id from ahl_mr_headers_b amh where amh.title = p_title)
3574: AND ue.status_code IS NULL
3575: AND ue.manually_planned_flag = 'Y'
3576: AND NOT EXISTS (SELECT 'x'
3577: FROM ahl_ue_relationships uer, ahl_unit_effectivities_b ue1
3578: WHERE uer.related_ue_id = ue.unit_effectivity_id
3579: AND uer.originator_ue_id = ue1.unit_effectivity_id
3580: AND ue1.object_type = 'SR');
3581: -- Do not pick MRs associated to a SR.

Line 7416: FROM ahl_ue_relationships relns

7412:
7413: -- for reading unit effectivity table.
7414: CURSOR ahl_ue_relns_csr ( p_unit_effectivity_id IN NUMBER, p_level IN NUMBER ) IS
7415: SELECT ue_id, related_ue_id
7416: FROM ahl_ue_relationships relns
7417: WHERE level = p_level
7418: START WITH ue_id = p_unit_effectivity_id AND
7419: relationship_code = 'PARENT'
7420: CONNECT BY PRIOR related_ue_id = ue_id AND

Line 10075: FROM ahl_ue_relationships

10071: AND status_code IS NULL
10072: --AND defer_from_ue_id IS NOT NULL -- not required as joining table ahl_unit_deferrals_b
10073: AND UDF.unit_deferral_type IN ('DEFERRAL', 'MEL','CDL')
10074: AND NOT EXISTS (SELECT 'x'
10075: FROM ahl_ue_relationships
10076: WHERE related_ue_id = UE.unit_effectivity_id
10077: AND relationship_code = 'PARENT')
10078: AND UDF.approval_status_code = 'DEFERRED'
10079: ORDER BY DEFERRAL_EFFECTIVE_ON ASC;

Line 10129: FROM ahl_ue_relationships uer, ahl_unit_effectivities_b ue

10125: -- Read immediate children of the SR.
10126: CURSOR ahl_ue_reln_csr (p_ue_id IN NUMBER) IS
10127: SELECT ue.unit_effectivity_id, ue.status_code,
10128: UE.CSI_ITEM_INSTANCE_ID, UE.MR_HEADER_ID
10129: FROM ahl_ue_relationships uer, ahl_unit_effectivities_b ue
10130: WHERE ue.unit_effectivity_id = uer.related_ue_id
10131: AND uer.ue_id = p_ue_id;
10132:
10133: --

Line 10634: FROM ahl_ue_relationships uer, ahl_unit_effectivities_app_v ue

10630: -- Read immediate children of the SR.
10631: CURSOR ahl_ue_reln_csr (p_ue_id IN NUMBER) IS
10632: SELECT ue.unit_effectivity_id, ue.status_code,
10633: UE.CSI_ITEM_INSTANCE_ID, UE.MR_HEADER_ID
10634: FROM ahl_ue_relationships uer, ahl_unit_effectivities_app_v ue
10635: WHERE ue.unit_effectivity_id = uer.related_ue_id
10636: AND uer.ue_id = p_ue_id;
10637:
10638:

Line 10843: FROM ahl_ue_relationships

10839:
10840: -- Get all child UE's for a given unit effectivity.
10841: CURSOR ahl_ue_relns_csr (p_unit_effectivity_id IN NUMBER) IS
10842: SELECT related_ue_id, ue_id, level
10843: FROM ahl_ue_relationships
10844: START WITH ue_id = p_unit_effectivity_id
10845: AND relationship_code = 'PARENT'
10846: CONNECT BY PRIOR related_ue_id = ue_id
10847: AND relationship_code = 'PARENT'

Line 11015: --FROM ahl_ue_relationships uer, ahl_unit_effectivities_app_v ue1

11011: ue.status_code
11012: FROM ahl_unit_effectivities_b ue
11013: /*
11014: WHERE NOT EXISTS ( SELECT 'x'
11015: --FROM ahl_ue_relationships uer, ahl_unit_effectivities_app_v ue1
11016: FROM ahl_ue_relationships uer, ahl_unit_effectivities_b ue1
11017: WHERE uer.related_ue_id = ue.unit_effectivity_id AND
11018: uer.originator_ue_id = ue1.unit_effectivity_id AND
11019: ue1.object_type <> 'SR' )

Line 11016: FROM ahl_ue_relationships uer, ahl_unit_effectivities_b ue1

11012: FROM ahl_unit_effectivities_b ue
11013: /*
11014: WHERE NOT EXISTS ( SELECT 'x'
11015: --FROM ahl_ue_relationships uer, ahl_unit_effectivities_app_v ue1
11016: FROM ahl_ue_relationships uer, ahl_unit_effectivities_b ue1
11017: WHERE uer.related_ue_id = ue.unit_effectivity_id AND
11018: uer.originator_ue_id = ue1.unit_effectivity_id AND
11019: ue1.object_type <> 'SR' )
11020: */

Line 11023: FROM ahl_ue_relationships uer

11019: ue1.object_type <> 'SR' )
11020: */
11021: -- pick up only top nodes.
11022: WHERE NOT EXISTS (SELECT 'x'
11023: FROM ahl_ue_relationships uer
11024: WHERE uer.related_ue_id = ue.unit_effectivity_id
11025: AND relationship_code = 'PARENT')
11026: AND ue.csi_item_instance_id = p_csi_item_instance_id
11027: AND ue.application_usg_code = p_appln_usage_code

Line 11102: -- Read group from ahl_ue_relationships.

11098: FROM ahl_unit_effectivities_vl
11099: WHERE unit_effectivity_id = p_unit_effectivity_id
11100: FOR UPDATE OF message_code NOWAIT;
11101:
11102: -- Read group from ahl_ue_relationships.
11103: CURSOR decendent_csr (p_unit_effectivity_id IN NUMBER) IS
11104: SELECT related_ue_id
11105: FROM ahl_ue_relationships
11106: WHERE relationship_code = 'PARENT' AND

Line 11105: FROM ahl_ue_relationships

11101:
11102: -- Read group from ahl_ue_relationships.
11103: CURSOR decendent_csr (p_unit_effectivity_id IN NUMBER) IS
11104: SELECT related_ue_id
11105: FROM ahl_ue_relationships
11106: WHERE relationship_code = 'PARENT' AND
11107: originator_ue_id = p_unit_effectivity_id;
11108:
11109: l_exception_flag BOOLEAN;

Line 14174: FROM ahl_ue_relationships relns

14170:
14171: -- for reading unit effectivity table.
14172: CURSOR ahl_ue_relns_csr ( p_unit_effectivity_id IN NUMBER ) IS
14173: SELECT ue_id, related_ue_id
14174: FROM ahl_ue_relationships relns
14175: START WITH ue_id = p_unit_effectivity_id AND
14176: relationship_code = 'PARENT'
14177: CONNECT BY PRIOR related_ue_id = ue_id AND
14178: originator_ue_id = p_unit_effectivity_id AND

Line 14226: FROM ahl_ue_relationships

14222:
14223: -- group UE check.
14224: CURSOR chk_grp_mr(p_ue_id IN NUMBER) IS
14225: SELECT 'x'
14226: FROM ahl_ue_relationships
14227: WHERE originator_ue_id = p_ue_id;
14228:
14229: -- Added for SB Enh.
14230: -- for prior MR, retain accomplishment trigger details.

Line 14403: FROM ahl_ue_relationships uer

14399: FROM ahl_unit_effectivities_app_v UE, ahl_mr_headers_b mr
14400: -- pick up only top nodes.
14401: WHERE ue.mr_header_id = mr.mr_header_id
14402: AND NOT EXISTS (SELECT 'x'
14403: FROM ahl_ue_relationships uer
14404: WHERE uer.related_ue_id = ue.unit_effectivity_id
14405: AND relationship_code = 'PARENT')
14406: -- not applicable
14407: AND NOT EXISTS (SELECT 'x'

Line 15248: FROM ahl_ue_relationships uer, ahl_unit_effectivities_b ue1

15244: AND ue.manually_planned_flag = 'Y'
15245: AND ue.defer_from_ue_id IS NULL
15246: -- Do not pick MRs associated to a SR.
15247: AND NOT EXISTS (SELECT 'x'
15248: FROM ahl_ue_relationships uer, ahl_unit_effectivities_b ue1
15249: WHERE uer.related_ue_id = ue.unit_effectivity_id
15250: AND uer.originator_ue_id = ue1.unit_effectivity_id
15251: AND ue1.object_type = 'SR');
15252:

Line 16191: from ahl_ue_relationships

16187: last_update_date = sysdate,
16188: last_updated_by = fnd_global.user_id,
16189: object_version_number = object_version_number + 1
16190: WHERE unit_effectivity_id IN (select related_ue_id
16191: from ahl_ue_relationships
16192: where originator_ue_id = p_unit_effectivity_id);
16193:
16194: END IF;
16195: