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.

[Home] [Help]

APPS.AHL_MC_NODE_PVT dependencies on AHL_MC_HEADERS_B

Line 558: FROM ahl_mc_relationships_v rel, ahl_mc_headers_b mch

554: p_rel_id in number
555: )
556: IS
557: SELECT rel.ata_code, rel.position_ref_meaning , mch.name
558: FROM ahl_mc_relationships_v rel, ahl_mc_headers_b mch
559: WHERE rel.relationship_id IN
560: (
561: SELECT relationship_id
562: FROM ahl_mc_config_relations

Line 579: FROM ahl_mc_relationships_v rel, ahl_mc_headers_b mch

575: p_rel_id in number
576: )
577: IS
578: SELECT rel.ata_code , mch.name, rel.position_ref_meaning
579: FROM ahl_mc_relationships_v rel, ahl_mc_headers_b mch
580: WHERE rel.mc_header_id IN
581: (
582: SELECT mc_header_id
583: FROM ahl_mc_config_relations

Line 3592: FROM ahl_mc_headers_b mch, ahl_mc_relationships mcr

3588: -- Define cursor get_node_mc_details to read detail of the MC of a MC node
3589: CURSOR get_node_mc_details
3590: IS
3591: SELECT mch.name
3592: FROM ahl_mc_headers_b mch, ahl_mc_relationships mcr
3593: WHERE mch.mc_header_id = mcr.mc_header_id AND
3594: mcr.relationship_id = p_rel_id;
3595:
3596: -- Define cursor get_mc_details to read detail of a MC

Line 3600: FROM ahl_mc_headers_b

3596: -- Define cursor get_mc_details to read detail of a MC
3597: CURSOR get_mc_details
3598: IS
3599: SELECT name
3600: FROM ahl_mc_headers_b
3601: WHERE mc_header_id = p_subconfig_id;
3602:
3603: -- Define local variables
3604: l_mc_name VARCHAR2(80);

Line 3778: FROM ahl_mc_headers_b mch, ahl_mc_relationships mcr

3774: p_rel_id in number
3775: )
3776: IS
3777: SELECT mch.mc_header_id, mch.config_status_code
3778: FROM ahl_mc_headers_b mch, ahl_mc_relationships mcr
3779: WHERE mch.mc_header_id = mcr.mc_header_id AND
3780: mcr.relationship_id = p_rel_id;
3781:
3782: l_mc_header_id NUMBER;

Line 3794: UPDATE ahl_mc_headers_b

3790: IF (get_mc_header_status%FOUND)
3791: THEN
3792: IF (l_status = 'APPROVAL_REJECTED')
3793: THEN
3794: UPDATE ahl_mc_headers_b
3795: SET config_status_code = 'DRAFT'
3796: WHERE mc_header_id = l_mc_header_id;
3797: END IF;
3798: END IF;

Line 4072: FROM ahl_mc_config_relations submc, ahl_mc_headers_b mch

4068: -- Define cursor check_submc_exists to check whether the subconfiguration association already exists for this node
4069: CURSOR check_submc_exists
4070: IS
4071: SELECT name
4072: FROM ahl_mc_config_relations submc, ahl_mc_headers_b mch
4073: WHERE submc.mc_header_id = mch.mc_header_id AND
4074: submc.relationship_id = p_x_subconfig_rec.relationship_id AND
4075: submc.mc_header_id = p_x_subconfig_rec.mc_header_id;
4076: -- Since expired subconfig associations can be unexpired, so no need to filter on active_end_date

Line 4105: FROM ahl_mc_headers_b mch, ahl_mc_relationships mcr

4101: -- Define cursor get_node_mc_details to read detail of the MC of a MC node
4102: CURSOR get_node_mc_details(p_dest_rel_id in number)
4103: IS
4104: SELECT mch.name
4105: FROM ahl_mc_headers_b mch, ahl_mc_relationships mcr
4106: WHERE mch.mc_header_id = mcr.mc_header_id AND
4107: mcr.relationship_id = p_dest_rel_id;
4108: -- Define cursor get_mc_details to read detail of a MC
4109: CURSOR get_mc_details(p_subconfig_id in number )

Line 4112: FROM ahl_mc_headers_b

4108: -- Define cursor get_mc_details to read detail of a MC
4109: CURSOR get_mc_details(p_subconfig_id in number )
4110: IS
4111: SELECT name
4112: FROM ahl_mc_headers_b
4113: WHERE mc_header_id = p_subconfig_id;
4114: -- Declare local variables
4115: l_api_name CONSTANT VARCHAR2(30) := 'Attach_Subconfig';
4116: l_msg_count NUMBER;

Line 4690: FROM ahl_mc_headers_b mch, ahl_mc_relationships mcr

4686: -- Define cursor get_node_mc_details to read detail of the MC of a MC node
4687: CURSOR get_node_mc_details
4688: IS
4689: SELECT mch.name
4690: FROM ahl_mc_headers_b mch, ahl_mc_relationships mcr
4691: WHERE mch.mc_header_id = mcr.mc_header_id AND
4692: mcr.relationship_id = p_dest_rel_id;
4693: -- Define cursor get_mc_details to read detail of a MC
4694: CURSOR get_mc_details(p_subconfig_id in number)

Line 4697: FROM ahl_mc_headers_b

4693: -- Define cursor get_mc_details to read detail of a MC
4694: CURSOR get_mc_details(p_subconfig_id in number)
4695: IS
4696: SELECT name
4697: FROM ahl_mc_headers_b
4698: WHERE mc_header_id = p_subconfig_id;
4699: -- Define cursor get_subconfigs to read all valid subconfiguration associations with a particular MC node
4700: CURSOR get_subconfigs
4701: IS