APPS.AHL_FMP_COMMON_PVT dependencies on AHL_MC_PATH_POSITION_NODES

Line 420: ahl_mc_headers_b mch, ahl_mc_path_position_nodes mcp

416: CURSOR get_rec_from_id ( c_relationship_id NUMBER )
417: IS
418: SELECT relationship_id
419: FROM ahl_mc_relationships mcr,
420: ahl_mc_headers_b mch, ahl_mc_path_position_nodes mcp
421: where mch.mc_header_id = mcr.mc_header_id and
422: mch.mc_id = mcp.mc_id and
423: mch.version_number = nvl(mcp.version_number, mch.version_number) and
424: mcr.position_key = mcp.position_key and

Line 426: from ahl_mc_path_position_nodes

422: mch.mc_id = mcp.mc_id and
423: mch.version_number = nvl(mcp.version_number, mch.version_number) and
424: mcr.position_key = mcp.position_key and
425: mcp.sequence = (select max(sequence)
426: from ahl_mc_path_position_nodes
427: where path_position_id = nvl(c_relationship_id,'-1'))
428: and mcp.path_position_id = nvl(c_relationship_id,'-1');
429:
430: CURSOR check_reln_valid_csr (c_relationship_id IN NUMBER)

Line 527: FROM ahl_mc_headers_b mch, ahl_mc_path_position_nodes mcp

523:
524: CURSOR get_mc_header_id ( c_relationship_id NUMBER )
525: IS
526: SELECT mch.mc_header_id
527: FROM ahl_mc_headers_b mch, ahl_mc_path_position_nodes mcp
528: WHERE
529: mch.mc_id = mcp.mc_id and
530: mch.version_number = nvl(mcp.version_number, mch.version_number) and
531: mcp.sequence = (select max(sequence)

Line 532: from ahl_mc_path_position_nodes

528: WHERE
529: mch.mc_id = mcp.mc_id and
530: mch.version_number = nvl(mcp.version_number, mch.version_number) and
531: mcp.sequence = (select max(sequence)
532: from ahl_mc_path_position_nodes
533: where path_position_id = nvl(c_relationship_id,'-1'))
534: and mcp.path_position_id = nvl(c_relationship_id,'-1');
535:
536: --pdoki commented for Bug 11723220

Line 625: ahl_mc_path_position_nodes mcp,

621: IS
622: SELECT 'X'
623: FROM ahl_mc_relationships mcr,
624: ahl_mc_headers_b mch,
625: ahl_mc_path_position_nodes mcp,
626: --ahl_item_associations_v igass ,
627: ahl_item_associations_vl igass, --priyan changes due to performance reasons , Refer Bug # 5078530
628: mtl_system_items_kfv MTL,
629: mtl_item_status STAT,

Line 636: from ahl_mc_path_position_nodes where

632: and mch.mc_id = mcp.mc_id
633: and mch.version_number = nvl(mcp.version_number, mch.version_number)
634: and mcr.position_key = mcp.position_key
635: and mcp.sequence = (select max(sequence)
636: from ahl_mc_path_position_nodes where
637: path_position_id = nvl(c_relationship_id,-1)
638: and path_position_id=mcp.path_position_id)
639: and mcp.path_position_id = nvl(c_relationship_id,-1)
640: and mcr.item_group_id = igass.item_group_id