APPS.AHL_FMP_COMMON_PVT dependencies on AHL_MC_HEADERS_B

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

526:
527: CURSOR check_mc_status ( c_mc_header_id NUMBER )
528: IS
529: SELECT 'X'
530: FROM ahl_mc_headers_b
531: WHERE mc_header_id = c_mc_header_id AND
532: config_status_code = 'COMPLETE';
533:
534: BEGIN

Line 613: ahl_mc_headers_b mch,

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