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

Line 1020: SELECT COUNT(*) INTO l_loop_chain_count FROM ahl_mr_loop_chain_relns WHERE mr_header_id = p_x_mr_header_rec.mr_header_id AND (relationship_code = 'LOOP' OR (relationship_code ='CHAIN' AND sequence_number <> 1)) ;

1016:
1017: IF p_x_mr_header_rec.implement_status_code = 'OPTIONAL_DO_NOT_IMPLEMENT' AND
1018: p_x_mr_header_rec.dml_operation='U'
1019: THEN
1020: SELECT COUNT(*) INTO l_loop_chain_count FROM ahl_mr_loop_chain_relns WHERE mr_header_id = p_x_mr_header_rec.mr_header_id AND (relationship_code = 'LOOP' OR (relationship_code ='CHAIN' AND sequence_number <> 1)) ;
1021:
1022: IF l_loop_chain_count > 0 THEN
1023: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_LPCH_IMPL_EXIST');
1024: FND_MSG_PUB.ADD;

Line 1035: SELECT COUNT(*) INTO l_loop_chain_count FROM ahl_mr_loop_chain_relns WHERE mr_header_id = p_x_mr_header_rec.mr_header_id;

1031: */
1032: IF p_x_mr_header_rec.REPETITIVE_FLAG = 'N' AND
1033: p_x_mr_header_rec.dml_operation='U'
1034: THEN
1035: SELECT COUNT(*) INTO l_loop_chain_count FROM ahl_mr_loop_chain_relns WHERE mr_header_id = p_x_mr_header_rec.mr_header_id;
1036:
1037: IF l_loop_chain_count > 0 THEN
1038: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_LPCH_REPT_EXIST');
1039: FND_MSG_PUB.ADD;

Line 1327: from AHL_MR_LOOP_CHAIN_RELNS

1323:
1324: CURSOR CHK_MR_IN_LOOP_OR_CHAIN (c_mr_header_id NUMBER, c_relationship_code VARCHAR2)
1325: IS
1326: select 'x'
1327: from AHL_MR_LOOP_CHAIN_RELNS
1328: where MR_HEADER_ID= c_mr_header_id
1329: and relationship_code = c_relationship_code;
1330: --sukhwsin::Complex Assembly Maintenance Changes - ends
1331:

Line 2718: SELECT * FROM ahl_mr_loop_chain_relns WHERE

2714:
2715: --Changes for SBE - Loop/Chain Relns Begins
2716: CURSOR get_mr_loop_chain_relns(p_mr_header_id_csr NUMBER)
2717: IS
2718: SELECT * FROM ahl_mr_loop_chain_relns WHERE
2719: mr_relationship_id IN
2720: (SELECT mr_relationship_id
2721: FROM ahl_mr_loop_chain_relns
2722: WHERE mr_header_id = p_mr_header_id_csr

Line 2721: FROM ahl_mr_loop_chain_relns

2717: IS
2718: SELECT * FROM ahl_mr_loop_chain_relns WHERE
2719: mr_relationship_id IN
2720: (SELECT mr_relationship_id
2721: FROM ahl_mr_loop_chain_relns
2722: WHERE mr_header_id = p_mr_header_id_csr
2723: AND mr_relationship_id <> start_mr_relationship_id
2724: );
2725:

Line 2846: DELETE FROM AHL_MR_LOOP_CHAIN_RELNS

2842: or RELATED_MR_HEADER_ID=P_MR_HEADER_ID;
2843:
2844: -- Changes for SBE Begin: Delete the relation from MR loop/chain relationships table
2845:
2846: DELETE FROM AHL_MR_LOOP_CHAIN_RELNS
2847: WHERE
2848: start_mr_relationship_id IN
2849: (SELECT mr_relationship_id
2850: FROM ahl_mr_loop_chain_relns

Line 2850: FROM ahl_mr_loop_chain_relns

2846: DELETE FROM AHL_MR_LOOP_CHAIN_RELNS
2847: WHERE
2848: start_mr_relationship_id IN
2849: (SELECT mr_relationship_id
2850: FROM ahl_mr_loop_chain_relns
2851: WHERE mr_header_id = P_MR_HEADER_ID
2852: );
2853:
2854: FOR l_mr_loop_chain_rel_rec IN get_mr_loop_chain_relns(P_MR_HEADER_ID)

Line 2856: SELECT COUNT(sequence_number) INTO l_seq_count FROM ahl_mr_loop_chain_relns WHERE sequence_number = l_mr_loop_chain_rel_rec.sequence_number AND start_mr_relationship_id = l_mr_loop_chain_rel_rec.start_mr_relationship_id;

2852: );
2853:
2854: FOR l_mr_loop_chain_rel_rec IN get_mr_loop_chain_relns(P_MR_HEADER_ID)
2855: LOOP
2856: SELECT COUNT(sequence_number) INTO l_seq_count FROM ahl_mr_loop_chain_relns WHERE sequence_number = l_mr_loop_chain_rel_rec.sequence_number AND start_mr_relationship_id = l_mr_loop_chain_rel_rec.start_mr_relationship_id;
2857:
2858: IF l_seq_count <= 1 THEN
2859: DELETE FROM ahl_mr_loop_chain_relns WHERE start_mr_relationship_id = l_mr_loop_chain_rel_rec.start_mr_relationship_id;
2860:

Line 2859: DELETE FROM ahl_mr_loop_chain_relns WHERE start_mr_relationship_id = l_mr_loop_chain_rel_rec.start_mr_relationship_id;

2855: LOOP
2856: SELECT COUNT(sequence_number) INTO l_seq_count FROM ahl_mr_loop_chain_relns WHERE sequence_number = l_mr_loop_chain_rel_rec.sequence_number AND start_mr_relationship_id = l_mr_loop_chain_rel_rec.start_mr_relationship_id;
2857:
2858: IF l_seq_count <= 1 THEN
2859: DELETE FROM ahl_mr_loop_chain_relns WHERE start_mr_relationship_id = l_mr_loop_chain_rel_rec.start_mr_relationship_id;
2860:
2861: ELSE
2862: DELETE FROM ahl_mr_loop_chain_relns WHERE mr_relationship_id = l_mr_loop_chain_rel_rec.mr_relationship_id;
2863: END IF;

Line 2862: DELETE FROM ahl_mr_loop_chain_relns WHERE mr_relationship_id = l_mr_loop_chain_rel_rec.mr_relationship_id;

2858: IF l_seq_count <= 1 THEN
2859: DELETE FROM ahl_mr_loop_chain_relns WHERE start_mr_relationship_id = l_mr_loop_chain_rel_rec.start_mr_relationship_id;
2860:
2861: ELSE
2862: DELETE FROM ahl_mr_loop_chain_relns WHERE mr_relationship_id = l_mr_loop_chain_rel_rec.mr_relationship_id;
2863: END IF;
2864: END LOOP;
2865:
2866: -- Changes for SBE - Loop/Chain Relns Ends