APPS.AHL_FMP_PVT dependencies on AHL_MR_RELATIONSHIPS

Line 2445: FROM ahl_mr_relationships

2441: -- MR to be processed later
2442: /*
2443: SELECT --count(distinct related_mr_header_id)
2444: count(related_mr_header_id)
2445: FROM ahl_mr_relationships
2446: WHERE EXISTS (SELECT mr_header_id
2447: FROM ahl_mr_headers_b M -- perf bug 6266738
2448: WHERE mr_header_id = related_mr_header_id
2449: AND mr_status_code = 'COMPLETE'

Line 2465: FROM ahl_mr_relationships amr

2461: AND relationship_code = 'PARENT';
2462: */
2463:
2464: SELECT count(amr.related_mr_header_id)
2465: FROM ahl_mr_relationships amr
2466: START WITH amr.mr_header_id = c_mr_header_id
2467: AND amr.relationship_code = 'PARENT'
2468: AND exists (select 'x' from ahl_mr_headers_b mr1
2469: where mr1.mr_header_id = amr.related_mr_header_id

Line 2995: FROM ahl_mr_relationships_app_v

2991:
2992: /*
2993: CURSOR get_activities(c_mr_header_id NUMBER) IS
2994: SELECT related_mr_header_id
2995: FROM ahl_mr_relationships_app_v
2996: WHERE mr_header_id = c_mr_header_id
2997: AND relationship_code = 'PARENT';
2998: */
2999: --Get attributes of a given MR