APPS.AHL_LTP_MTL_REQ_PVT dependencies on AHL_MC_CONFIG_RELATIONS

Line 922: FROM AHL_MC_CONFIG_RELATIONS CR, AHL_MC_HEADERS_B MC

918: AND parent_relationship_id is null;
919:
920: CURSOR get_sub_mc_for_pos_csr(c_position_id IN NUMBER) IS
921: SELECT CR.mc_header_id
922: FROM AHL_MC_CONFIG_RELATIONS CR, AHL_MC_HEADERS_B MC
923: WHERE CR.relationship_id = c_position_id
924: AND MC.mc_header_id = CR.mc_header_id
925: ORDER BY MC.name;
926:

Line 2072: FROM ahl_mc_relationships mcr, ahl_mc_config_relations smc

2068:
2069: -- Cursor to get allowable sub configuration item group ids for the given position
2070: CURSOR get_sub_config_item_group(c_relationship_id IN NUMBER) IS
2071: SELECT mcr.item_group_id
2072: FROM ahl_mc_relationships mcr, ahl_mc_config_relations smc
2073: WHERE mcr.mc_header_id = smc.mc_header_id
2074: AND mcr.parent_relationship_id is null
2075: AND smc.relationship_id = c_relationship_id
2076: ORDER BY smc.priority;

Line 2628: ahl_mc_config_relations smc

2624: ia.priority item_priority
2625: FROM ahl_item_associations_b ia,
2626: mtl_system_items_b msi,
2627: ahl_mc_relationships mcr,
2628: ahl_mc_config_relations smc
2629: WHERE mcr.mc_header_id = smc.mc_header_id
2630: AND mcr.parent_relationship_id is null
2631: AND smc.relationship_id = c_relationship_id
2632: AND ia.item_group_id = mcr.item_group_id

Line 2664: ahl_mc_config_relations smc

2660: ia.priority item_priority
2661: FROM ahl_item_associations_b ia,
2662: mtl_system_items_b msi,
2663: ahl_mc_relationships mcr,
2664: ahl_mc_config_relations smc
2665: WHERE mcr.mc_header_id = smc.mc_header_id
2666: AND mcr.parent_relationship_id is null
2667: AND smc.relationship_id = c_relationship_id
2668: AND ia.item_group_id = mcr.item_group_id