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

Line 45: FROM ahl_mr_headers_b MR

41: MR.repetitive_flag,
42: MR.implement_status_code,
43: MR.effective_from,
44: MR.effective_to
45: FROM ahl_mr_headers_b MR
46: WHERE MR.mr_header_id = p_mr_header_id_csr
47: AND MR.repetitive_flag = 'Y'
48: AND TRUNC(sysdate) <= TRUNC(NVL(MR.effective_to,sysdate+1));
49: -- Cursor to fetch the relationship details

Line 56: ahl_mr_headers_b MR

52: SELECT rel.mr_header_id,
53: rel.related_mr_header_id,
54: relationship_code
55: FROM ahl_mr_relationships rel,
56: ahl_mr_headers_b MR
57: WHERE (rel.mr_header_id = MR.mr_header_id
58: OR rel.related_mr_header_id = MR.mr_header_id)
59: AND (rel.mr_header_id = p_mr_header_id_csr
60: OR rel.related_mr_header_id = p_mr_header_id_csr)

Line 76: l_start_mr_title AHL_MR_HEADERS_B.TITLE%TYPE;

72: l_max_effective_from DATE := NULL;
73: l_min_effective_to DATE := NULL;
74: l_start_mr_rel_id NUMBER;
75: l_other_valid_start_mr NUMBER;
76: l_start_mr_title AHL_MR_HEADERS_B.TITLE%TYPE;
77: l_sequence NUMBER := 1;
78: l_mr_loop_chain_rel_cd VARCHAR2(30);
79: l_start_mr_header_id number;
80: l_mr_loop_chain MR_CHAIN_LOOP_TBL_TYPE;

Line 319: ahl_mr_headers_b mr

315: mr.mr_status_code,
316: mr.effective_from,
317: mr.effective_to
318: FROM ahl_mr_loop_chain_relns rel,
319: ahl_mr_headers_b mr
320: WHERE mr.mr_header_id = rel.mr_header_id
321: AND rel.start_mr_relationship_id IN
322: (SELECT start_mr_relationship_id
323: FROM ahl_mr_loop_chain_relns A

Line 330: FROM ahl_mr_headers_b a,

326: OR (relationship_code = c_rel_code))
327: AND ( c_start_mr_rel_id IS NULL
328: OR (start_mr_relationship_id NOT IN
329: (SELECT b.start_mr_relationship_id
330: FROM ahl_mr_headers_b a,
331: ahl_mr_loop_chain_relns b
332: WHERE a.mr_header_id = b.mr_header_id
333: AND b.start_mr_relationship_id = c_start_mr_rel_id))
334: )

Line 342: ahl_mr_headers_b WHERE title = c_start_mr_title

338: AND ((c_start_mr_header_id IS NULL)
339: OR (rel.start_mr_relationship_id NOT IN
340: (SELECT start_mr_relationship_id FROM ahl_mr_loop_chain_relns
341: WHERE mr_header_id IN (SELECT mr_header_id FROM
342: ahl_mr_headers_b WHERE title = c_start_mr_title
343: AND mr_header_id <> c_start_mr_header_id)
344: )))
345: AND
346: (c_effective_to IS NULL

Line 455: ahl_mr_headers_b mr

451: mr.mr_status_code,
452: mr.effective_from,
453: mr.effective_to
454: FROM ahl_mr_loop_chain_relns rel,
455: ahl_mr_headers_b mr
456: WHERE mr.mr_header_id = rel.mr_header_id
457: and rel.start_mr_relationship_id in
458: (select reln.start_mr_relationship_id
459: from ahl_mr_loop_chain_relns reln

Line 480: FROM ahl_mr_headers_b MR,

476: MR.revision,
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

Line 744: FROM ahl_mr_headers_b MR,

740: rel.mr_relationship_id,
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

Line 923: ahl_mr_headers_b MR,

919: FROM FND_LOOKUP_VALUES
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

Line 1146: ahl_mr_headers_b mr

1142: mr.mr_status_code,
1143: mr.effective_from,
1144: mr.effective_to
1145: FROM ahl_mr_loop_chain_relns rel,
1146: ahl_mr_headers_b mr
1147: WHERE mr.mr_header_id = rel.mr_header_id
1148: AND rel.start_mr_relationship_id IN
1149: (SELECT reln.start_mr_relationship_id
1150: FROM ahl_mr_loop_chain_relns reln

Line 1269: SELECT 'X' FROM ahl_mr_headers_b WHERE mr_header_id = p_mr_header_id_csr AND

1265: --Changes for Bug#12837789 Begins
1266: l_valid_flag CHAR(1);
1267: CURSOR get_is_mr_valid(p_mr_header_id_csr NUMBER)
1268: IS
1269: SELECT 'X' FROM ahl_mr_headers_b WHERE mr_header_id = p_mr_header_id_csr AND
1270: NVL(effective_to, SYSDATE + 1) > SYSDATE;
1271:
1272: --Changes for Bug#12837789 Ends
1273: begin

Line 1312: SELECT 'X' FROM ahl_mr_headers_b WHERE mr_header_id = p_mr_header_id_csr AND

1308: --Changes for Bug#12837789 Begins
1309: l_valid_flag CHAR(1);
1310: CURSOR get_is_mr_valid(p_mr_header_id_csr NUMBER)
1311: IS
1312: SELECT 'X' FROM ahl_mr_headers_b WHERE mr_header_id = p_mr_header_id_csr AND
1313: NVL(effective_to, SYSDATE + 1) > SYSDATE;
1314:
1315: --Changes for Bug#12837789 Ends
1316:

Line 1351: SELECT 'X' FROM ahl_mr_headers_b WHERE mr_header_id = p_mr_header_id_csr AND

1347: --Changes for Bug#12837789 Begins
1348: l_valid_flag CHAR(1);
1349: CURSOR get_is_mr_valid(p_mr_header_id_csr NUMBER)
1350: IS
1351: SELECT 'X' FROM ahl_mr_headers_b WHERE mr_header_id = p_mr_header_id_csr AND
1352: NVL(effective_to, SYSDATE + 1) > SYSDATE;
1353:
1354: --Changes for Bug#12837789 Ends
1355: