DBA Data[Home] [Help]

APPS.AHL_PRD_DISP_UTIL_PVT dependencies on AHL_MC_CONFIG_RELATIONS

Line 1943: AHL_MC_RELATIONSHIPS rel, AHL_MC_CONFIG_RELATIONS crel, MTL_PARAMETERS morgs

1939: CURSOR get_pos_subut_item_csr(p_relationship_id IN NUMBER,
1940: p_org_id IN NUMBER ) IS
1941: SELECT ia.inventory_item_id, mtl.concatenated_segments, ia.quantity, ia.uom_code
1942: FROM AHL_ITEM_ASSOCIATIONS_B ia, MTL_SYSTEM_ITEMS_KFV mtl,
1943: AHL_MC_RELATIONSHIPS rel, AHL_MC_CONFIG_RELATIONS crel, MTL_PARAMETERS morgs
1944: WHERE ia.inventory_item_id = mtl.inventory_item_id
1945: AND mtl.organization_id = p_org_id --Make sure item is defined for p_org_id
1946: AND ia.inventory_org_id = morgs.master_organization_id
1947: AND morgs.organization_id = p_org_id