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_FMP_PVT dependencies on AHL_MR_LOOP_CHAIN_RELNS

Line 1409: from ahl_mr_loop_chain_relns MLC

1405: mrb.implement_status_code,
1406: count_mr_descendents(c_mr_header_id) descendent_count,
1407: decode (nvl(lcr.relationship_code, mrr.relationship_code ), 'INITIATES', 'INITIATED_BY', lcr.relationship_code) relationship_code,
1408: (select MLC.mr_header_id
1409: from ahl_mr_loop_chain_relns MLC
1410: where MLC.mr_relationship_id = lcr.start_mr_relationship_id ) start_mr_header_id,
1411: lcr.sequence_number
1412: FROM ahl_mr_headers_b mrb,
1413: ahl_mr_loop_chain_relns lcr,

Line 1413: ahl_mr_loop_chain_relns lcr,

1409: from ahl_mr_loop_chain_relns MLC
1410: where MLC.mr_relationship_id = lcr.start_mr_relationship_id ) start_mr_header_id,
1411: lcr.sequence_number
1412: FROM ahl_mr_headers_b mrb,
1413: ahl_mr_loop_chain_relns lcr,
1414: ahl_mr_relationships mrr
1415: WHERE mrb.mr_header_id = c_mr_header_id
1416: AND lcr.mr_header_id(+) = mrb.mr_header_id
1417: AND mrr.related_mr_header_id(+) = mrb.mr_header_id