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

Line 1325: FROM ahl_mc_relationships rel, ahl_mc_headers_b hdr

1321:
1322: -- Get all the positions associated to this item group.
1323: CURSOR get_associated_posns_csr(c_item_group_id IN NUMBER) IS
1324: SELECT relationship_id
1325: FROM ahl_mc_relationships rel, ahl_mc_headers_b hdr
1326: WHERE trunc(nvl(rel.active_end_date,sysdate+1)) > trunc(sysdate)
1327: AND trunc(nvl(rel.active_start_date,sysdate-1)) < trunc(sysdate)
1328: AND hdr.mc_header_id = rel.mc_header_id
1329: AND rel.item_group_id = c_item_group_id

Line 2639: FROM AHL_MC_RELATIONSHIPS REL, AHL_MC_HEADERS_B HDR

2635:
2636: -- Get all the positions associated to this item group.
2637: CURSOR c_get_associated_posns_csr(c_item_group_id NUMBER) IS
2638: SELECT relationship_id
2639: FROM AHL_MC_RELATIONSHIPS REL, AHL_MC_HEADERS_B HDR
2640: WHERE HDR.mc_header_id = REL.mc_header_id AND
2641: REL.item_group_id = c_item_group_id AND
2642: HDR.config_status_code NOT IN ('EXPIRED','CLOSED') AND
2643: TRUNC(NVL(REL.active_end_date,SYSDATE+1)) > TRUNC(SYSDATE) AND