APPS.AHL_FMP_COMMON_PVT dependencies on AHL_MC_HEADERS_B

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 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 540: FROM ahl_mc_headers_b

536: --pdoki commented for Bug 11723220
537: /*CURSOR check_mc_status ( c_mc_header_id NUMBER )
538: IS
539: SELECT 'X'
540: FROM ahl_mc_headers_b
541: WHERE mc_header_id = c_mc_header_id AND
542: config_status_code = 'COMPLETE';*/
543:
544: BEGIN

Line 624: ahl_mc_headers_b mch,

620: CURSOR check_alternate( c_relationship_id NUMBER, c_inventory_item_id NUMBER )
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,