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_MR_LOOP_CHAIN_RELNS_PVT dependencies on AHL_MR_HEADERS_TL

Line 481: ahl_mr_headers_tl MR_TL,

477: MR.version_number,
478: MR.effective_from,
479: MR.effective_to
480: FROM ahl_mr_headers_b MR,
481: ahl_mr_headers_tl MR_TL,
482: (SELECT LOOKUP_CODE,
483: MEANING
484: FROM FND_LOOKUP_VALUES
485: WHERE LOOKUP_TYPE = 'AHL_FMP_REVISION_STATUS'

Line 745: ahl_mr_headers_tl MR_TL,

741: rel.relationship_code,
742: /* Modified for Bug# 12686413 - inactive MRs displayed in view loop/chain UI*/
743: (ROW_NUMBER() OVER( PARTITION BY rel.sequence_number ORDER BY rel.sequence_number, NVL(effective_to, SYSDATE) DESC, MR.mr_status_code)) orderSeq
744: FROM ahl_mr_headers_b MR,
745: ahl_mr_headers_tl MR_TL,
746: (SELECT LOOKUP_CODE,
747: MEANING
748: FROM FND_LOOKUP_VALUES
749: WHERE LOOKUP_TYPE = 'AHL_FMP_REVISION_STATUS'

Line 924: ahl_mr_headers_tl MR_TL

920: WHERE LOOKUP_TYPE = 'AHL_FMP_REVISION_STATUS'
921: AND LANGUAGE = USERENV('LANG')
922: ) STATUS,
923: ahl_mr_headers_b MR,
924: ahl_mr_headers_tl MR_TL
925: WHERE eff.mr_header_id = MR.mr_header_id
926: AND MR_TL.LANGUAGE = USERENV('LANG')
927: AND status.lookup_code = MR.mr_status_code
928: AND MR.mr_header_id = MR_TL.mr_header_id