APPS.AHL_FMP_COMMON_PVT dependencies on AHL_MC_PATH_POSITION_NODES

Line 411: ahl_mc_headers_b mch, ahl_mc_path_position_nodes mcp

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
415: mcr.position_key = mcp.position_key and

Line 417: from ahl_mc_path_position_nodes

413: mch.mc_id = mcp.mc_id and
414: mch.version_number = nvl(mcp.version_number, mch.version_number) and
415: mcr.position_key = mcp.position_key and
416: mcp.sequence = (select max(sequence)
417: from ahl_mc_path_position_nodes
418: where path_position_id = nvl(c_relationship_id,'-1'))
419: and mcp.path_position_id = nvl(c_relationship_id,'-1');
420:
421: CURSOR check_reln_valid_csr (c_relationship_id IN NUMBER)

Line 518: FROM ahl_mc_headers_b mch, ahl_mc_path_position_nodes mcp

514:
515: CURSOR get_mc_header_id ( c_relationship_id NUMBER )
516: IS
517: SELECT mch.mc_header_id
518: FROM ahl_mc_headers_b mch, ahl_mc_path_position_nodes mcp
519: WHERE
520: mch.mc_id = mcp.mc_id and
521: mch.version_number = nvl(mcp.version_number, mch.version_number) and
522: mcp.sequence = (select max(sequence)

Line 523: from ahl_mc_path_position_nodes

519: WHERE
520: mch.mc_id = mcp.mc_id and
521: mch.version_number = nvl(mcp.version_number, mch.version_number) and
522: mcp.sequence = (select max(sequence)
523: from ahl_mc_path_position_nodes
524: where path_position_id = nvl(c_relationship_id,'-1'))
525: and mcp.path_position_id = nvl(c_relationship_id,'-1');
526:
527: CURSOR check_mc_status ( c_mc_header_id NUMBER )

Line 614: ahl_mc_path_position_nodes mcp,

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
617: mtl_system_items_kfv MTL,
618: mtl_item_status STAT,

Line 625: from ahl_mc_path_position_nodes where

621: and mch.mc_id = mcp.mc_id
622: and mch.version_number = nvl(mcp.version_number, mch.version_number)
623: and mcr.position_key = mcp.position_key
624: and mcp.sequence = (select max(sequence)
625: from ahl_mc_path_position_nodes where
626: path_position_id = nvl(c_relationship_id,-1)
627: and path_position_id=mcp.path_position_id)
628: and mcp.path_position_id = nvl(c_relationship_id,-1)
629: and mcr.item_group_id = igass.item_group_id