APPS.AHL_FMP_COMMON_PVT dependencies on AHL_MC_RELATIONSHIPS

Line 410: FROM ahl_mc_relationships mcr,

406: /*
407: CURSOR get_rec_from_id ( c_relationship_id NUMBER )
408: IS
409: SELECT relationship_id
410: FROM ahl_mc_relationships mcr,
411: ahl_mc_headers_b mch, ahl_mc_path_position_nodes mcp
412: where mch.mc_header_id = mcr.mc_header_id and
413: mch.mc_id = mcp.mc_id and
414: mch.version_number = nvl(mcp.version_number, mch.version_number) and

Line 424: FROM ahl_mc_relationships

420:
421: CURSOR check_reln_valid_csr (c_relationship_id IN NUMBER)
422: IS
423: SELECT 'x'
424: FROM ahl_mc_relationships
425: WHERE parent_relationship_id IS NULL
426: START WITH relationship_id = c_relationship_id
427: AND trunc(sysdate) < trunc(nvl(active_end_date,sysdate+1))
428: CONNECT BY PRIOR parent_relationship_id = relationship_id

Line 612: FROM ahl_mc_relationships mcr,

608:
609: CURSOR check_alternate( c_relationship_id NUMBER, c_inventory_item_id NUMBER )
610: IS
611: SELECT 'X'
612: FROM ahl_mc_relationships mcr,
613: ahl_mc_headers_b mch,
614: ahl_mc_path_position_nodes mcp,
615: --ahl_item_associations_v igass ,
616: ahl_item_associations_vl igass, --priyan changes due to performance reasons , Refer Bug # 5078530