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

Line 669: FROM ahl_mr_loop_chain_relns rel,

665: rel.ATTRIBUTE12,
666: rel.ATTRIBUTE13,
667: rel.ATTRIBUTE14,
668: rel.ATTRIBUTE15
669: FROM ahl_mr_loop_chain_relns rel,
670: ahl_mr_headers_b mr
671: WHERE mr.mr_header_id = rel.mr_header_id
672: AND rel.mr_relationship_id IN
673: (

Line 675: FROM ahl_mr_loop_chain_relns rel

671: WHERE mr.mr_header_id = rel.mr_header_id
672: AND rel.mr_relationship_id IN
673: (
674: SELECT rel.MR_RELATIONSHIP_ID
675: FROM ahl_mr_loop_chain_relns rel
676: WHERE start_mr_relationship_id IN
677: (SELECT mr_relationship_id
678: FROM ahl_mr_loop_chain_relns
679: WHERE mr_header_id = p_mr_header_id_csr

Line 678: FROM ahl_mr_loop_chain_relns

674: SELECT rel.MR_RELATIONSHIP_ID
675: FROM ahl_mr_loop_chain_relns rel
676: WHERE start_mr_relationship_id IN
677: (SELECT mr_relationship_id
678: FROM ahl_mr_loop_chain_relns
679: WHERE mr_header_id = p_mr_header_id_csr
680: )
681: )
682: AND TRUNC(sysdate) <= TRUNC(NVL(MR.effective_to,sysdate+1))

Line 716: FROM ahl_mr_loop_chain_relns rel,

712: rel.ATTRIBUTE12,
713: rel.ATTRIBUTE13,
714: rel.ATTRIBUTE14,
715: rel.ATTRIBUTE15
716: FROM ahl_mr_loop_chain_relns rel,
717: ahl_mr_headers_b mr
718: WHERE mr.mr_header_id = rel.mr_header_id
719: AND rel.mr_relationship_id IN
720: (SELECT mr_relationship_id

Line 721: FROM ahl_mr_loop_chain_relns

717: ahl_mr_headers_b mr
718: WHERE mr.mr_header_id = rel.mr_header_id
719: AND rel.mr_relationship_id IN
720: (SELECT mr_relationship_id
721: FROM ahl_mr_loop_chain_relns
722: WHERE mr_header_id = p_mr_header_id_csr
723: AND mr_relationship_id <> start_mr_relationship_id
724: )
725: AND TRUNC(sysdate) <= TRUNC(NVL(MR.effective_to,sysdate+1))

Line 1504: l_mr_loop_chain_rel_id := AHL_MR_LOOP_CHAIN_RELNS_S.NEXTVAL;

1500: IF l_start_loop_chain_rel_rec.mr_header_id = p_source_mr_header_id THEN
1501: l_start_loop_chain_rel_rec.mr_header_id := x_new_mr_header_id;
1502: END IF;
1503:
1504: l_mr_loop_chain_rel_id := AHL_MR_LOOP_CHAIN_RELNS_S.NEXTVAL;
1505:
1506: IF l_start_loop_chain_rel_rec.sequence_number = 1
1507: THEN
1508: -- Set the start mr relationship id

Line 1512: INSERT INTO AHL_MR_LOOP_CHAIN_RELNS(

1508: -- Set the start mr relationship id
1509: l_start_mr_rel_id := l_mr_loop_chain_rel_id;
1510: END IF;
1511:
1512: INSERT INTO AHL_MR_LOOP_CHAIN_RELNS(
1513: MR_RELATIONSHIP_ID,
1514: OBJECT_VERSION_NUMBER,
1515: LAST_UPDATE_DATE,
1516: LAST_UPDATED_BY,

Line 1573: INSERT INTO AHL_MR_LOOP_CHAIN_RELNS(

1569: FOR l_loop_chain_rel_rec IN mr_loop_chain_relns_csr(p_source_mr_header_id)
1570: LOOP
1571: l_loop_chain_rel_rec.mr_header_id := x_new_mr_header_id;
1572:
1573: INSERT INTO AHL_MR_LOOP_CHAIN_RELNS(
1574: MR_RELATIONSHIP_ID,
1575: OBJECT_VERSION_NUMBER,
1576: LAST_UPDATE_DATE,
1577: LAST_UPDATED_BY,

Line 1602: AHL_MR_LOOP_CHAIN_RELNS_S.NEXTVAL,

1598: ATTRIBUTE13,
1599: ATTRIBUTE14,
1600: ATTRIBUTE15)
1601: values(
1602: AHL_MR_LOOP_CHAIN_RELNS_S.NEXTVAL,
1603: 1,
1604: SYSDATE,
1605: fnd_global.user_id,
1606: SYSDATE,

Line 2186: SELECT * FROM ahl_mr_loop_chain_relns WHERE

2182: -- pdoki added for SBE Project, End.
2183: --Changes for SBE - Loop/Chain Relns Begins
2184: CURSOR get_mr_loop_chain_relns(p_mr_header_id_csr NUMBER)
2185: IS
2186: SELECT * FROM ahl_mr_loop_chain_relns WHERE
2187: mr_relationship_id IN
2188: (SELECT mr_relationship_id
2189: FROM ahl_mr_loop_chain_relns
2190: WHERE mr_header_id = p_mr_header_id_csr

Line 2189: FROM ahl_mr_loop_chain_relns

2185: IS
2186: SELECT * FROM ahl_mr_loop_chain_relns WHERE
2187: mr_relationship_id IN
2188: (SELECT mr_relationship_id
2189: FROM ahl_mr_loop_chain_relns
2190: WHERE mr_header_id = p_mr_header_id_csr
2191: AND mr_relationship_id <> start_mr_relationship_id
2192: );
2193:

Line 2409: DELETE FROM AHL_MR_LOOP_CHAIN_RELNS

2405: is less than or equal to sysdate then delete the relationship */
2406: IF TRUNC(SYSDATE) >= L_TO_DATE THEN
2407: -- Delete the entire rel if its a starting MR
2408:
2409: DELETE FROM AHL_MR_LOOP_CHAIN_RELNS
2410: WHERE
2411: start_mr_relationship_id IN
2412: (SELECT mr_relationship_id
2413: FROM ahl_mr_loop_chain_relns

Line 2413: FROM ahl_mr_loop_chain_relns

2409: DELETE FROM AHL_MR_LOOP_CHAIN_RELNS
2410: WHERE
2411: start_mr_relationship_id IN
2412: (SELECT mr_relationship_id
2413: FROM ahl_mr_loop_chain_relns
2414: WHERE mr_header_id = l_prev_mr_rec.MR_HEADER_ID
2415: );
2416:
2417: -- Check if there exist an MR for the same sequence number,

Line 2423: SELECT COUNT(sequence_number) INTO l_seq_count FROM ahl_mr_loop_chain_relns

2419: -- If not, then delete the entire rel
2420:
2421: FOR l_mr_loop_chain_rel_rec IN get_mr_loop_chain_relns(l_prev_mr_rec.MR_HEADER_ID)
2422: LOOP
2423: SELECT COUNT(sequence_number) INTO l_seq_count FROM ahl_mr_loop_chain_relns
2424: WHERE sequence_number = l_mr_loop_chain_rel_rec.sequence_number
2425: AND start_mr_relationship_id = l_mr_loop_chain_rel_rec.start_mr_relationship_id;
2426:
2427: IF l_seq_count <= 1 THEN

Line 2428: DELETE FROM ahl_mr_loop_chain_relns

2424: WHERE sequence_number = l_mr_loop_chain_rel_rec.sequence_number
2425: AND start_mr_relationship_id = l_mr_loop_chain_rel_rec.start_mr_relationship_id;
2426:
2427: IF l_seq_count <= 1 THEN
2428: DELETE FROM ahl_mr_loop_chain_relns
2429: WHERE start_mr_relationship_id = l_mr_loop_chain_rel_rec.start_mr_relationship_id;
2430:
2431: ELSE
2432: DELETE FROM ahl_mr_loop_chain_relns

Line 2432: DELETE FROM ahl_mr_loop_chain_relns

2428: DELETE FROM ahl_mr_loop_chain_relns
2429: WHERE start_mr_relationship_id = l_mr_loop_chain_rel_rec.start_mr_relationship_id;
2430:
2431: ELSE
2432: DELETE FROM ahl_mr_loop_chain_relns
2433: WHERE mr_relationship_id = l_mr_loop_chain_rel_rec.mr_relationship_id;
2434: END IF;
2435: END LOOP;
2436: END IF;