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_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 3595: FROM ahl_mc_headers_b mch, ahl_mc_relationships mcr

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

Line 3603: FROM ahl_mc_headers_b

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

Line 3804: FROM ahl_mc_headers_b mch, ahl_mc_relationships mcr

3800: p_rel_id in number
3801: )
3802: IS
3803: SELECT mch.mc_header_id, mch.config_status_code
3804: FROM ahl_mc_headers_b mch, ahl_mc_relationships mcr
3805: WHERE mch.mc_header_id = mcr.mc_header_id AND
3806: mcr.relationship_id = p_rel_id;
3807:
3808: l_mc_header_id NUMBER;

Line 3820: UPDATE ahl_mc_headers_b

3816: IF (get_mc_header_status%FOUND)
3817: THEN
3818: IF (l_status = 'APPROVAL_REJECTED')
3819: THEN
3820: UPDATE ahl_mc_headers_b
3821: SET config_status_code = 'DRAFT'
3822: WHERE mc_header_id = l_mc_header_id;
3823: END IF;
3824: END IF;

Line 4098: FROM ahl_mc_config_relations submc, ahl_mc_headers_b mch

4094: -- Define cursor check_submc_exists to check whether the subconfiguration association already exists for this node
4095: CURSOR check_submc_exists
4096: IS
4097: SELECT name
4098: FROM ahl_mc_config_relations submc, ahl_mc_headers_b mch
4099: WHERE submc.mc_header_id = mch.mc_header_id AND
4100: submc.relationship_id = p_x_subconfig_rec.relationship_id AND
4101: submc.mc_header_id = p_x_subconfig_rec.mc_header_id;
4102: -- Since expired subconfig associations can be unexpired, so no need to filter on active_end_date

Line 4131: FROM ahl_mc_headers_b mch, ahl_mc_relationships mcr

4127: -- Define cursor get_node_mc_details to read detail of the MC of a MC node
4128: CURSOR get_node_mc_details(p_dest_rel_id in number)
4129: IS
4130: SELECT mch.name
4131: FROM ahl_mc_headers_b mch, ahl_mc_relationships mcr
4132: WHERE mch.mc_header_id = mcr.mc_header_id AND
4133: mcr.relationship_id = p_dest_rel_id;
4134: -- Define cursor get_mc_details to read detail of a MC
4135: CURSOR get_mc_details(p_subconfig_id in number )

Line 4138: FROM ahl_mc_headers_b

4134: -- Define cursor get_mc_details to read detail of a MC
4135: CURSOR get_mc_details(p_subconfig_id in number )
4136: IS
4137: SELECT name
4138: FROM ahl_mc_headers_b
4139: WHERE mc_header_id = p_subconfig_id;
4140: -- Declare local variables
4141: l_api_name CONSTANT VARCHAR2(30) := 'Attach_Subconfig';
4142: l_msg_count NUMBER;

Line 4716: FROM ahl_mc_headers_b mch, ahl_mc_relationships mcr

4712: -- Define cursor get_node_mc_details to read detail of the MC of a MC node
4713: CURSOR get_node_mc_details
4714: IS
4715: SELECT mch.name
4716: FROM ahl_mc_headers_b mch, ahl_mc_relationships mcr
4717: WHERE mch.mc_header_id = mcr.mc_header_id AND
4718: mcr.relationship_id = p_dest_rel_id;
4719: -- Define cursor get_mc_details to read detail of a MC
4720: CURSOR get_mc_details(p_subconfig_id in number)

Line 4723: FROM ahl_mc_headers_b

4719: -- Define cursor get_mc_details to read detail of a MC
4720: CURSOR get_mc_details(p_subconfig_id in number)
4721: IS
4722: SELECT name
4723: FROM ahl_mc_headers_b
4724: WHERE mc_header_id = p_subconfig_id;
4725: -- Define cursor get_subconfigs to read all valid subconfiguration associations with a particular MC node
4726: CURSOR get_subconfigs
4727: IS