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_UC_TREE_PVT dependencies on AHL_MC_HEADERS_B

Line 1129: l_mc_name ahl_mc_headers_b.name%TYPE;

1125: l_msg_count NUMBER;
1126: l_msg_data VARCHAR2(2000);
1127: l_relationship_id NUMBER;
1128: l_mc_header_id NUMBER;
1129: l_mc_name ahl_mc_headers_b.name%TYPE;
1130: l_mc_revision ahl_mc_headers_b.revision%TYPE;
1131: l_mc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
1132: l_root_instance_id NUMBER;
1133: l_root_relationship_id NUMBER;

Line 1130: l_mc_revision ahl_mc_headers_b.revision%TYPE;

1126: l_msg_data VARCHAR2(2000);
1127: l_relationship_id NUMBER;
1128: l_mc_header_id NUMBER;
1129: l_mc_name ahl_mc_headers_b.name%TYPE;
1130: l_mc_revision ahl_mc_headers_b.revision%TYPE;
1131: l_mc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
1132: l_root_instance_id NUMBER;
1133: l_root_relationship_id NUMBER;
1134: l_mc_top_rel_id NUMBER;

Line 1199: FROM ahl_mc_headers_b H,

1195: H.config_status_code,
1196: R.relationship_id,
1197: H.name,
1198: H.revision
1199: FROM ahl_mc_headers_b H,
1200: ahl_mc_relationships R
1201: WHERE H.mc_header_id = p_mc_header_id
1202: AND R.mc_header_id = H.mc_header_id
1203: AND R.parent_relationship_id IS NULL